API para submeter para aprovação a OC

Nesse post irei mostrar uma API para submeter para aprovação uma ordem de compra via API. Crie uma Ordem de Compra 2. Rode o script abaixo DECLARE v_item_key VARCHAR2 (100); l_result NUMBER; lv_request_id NUMBER; v_phase VARCHAR2(4000); v_status VARCHAR2(4000); v_dev_phase VARCHAR2(4000); v_dev_status VARCHAR2(4000); v_message VARCHAR2(4000); CURSOR c_po_details IS SELECT pha.po_header_id, pha.org_id, pha.segment1, pha.agent_id, pdt.document_subtype, pdt.document_type_code, pha.authorization_status... Continuar Lendo →

19 19America/Sao_Paulo maio 19America/Sao_Paulo 2019 0

Creating / Updating costs by Interface

In this article I will show how to create cost records by Interface. Many companies need to replicate their costs to other organizations. This is due to the fact that its components or assemblies are manufactured in more than one organization. Oracle provides a request that copies costs to other organizations. But sometimes the company... Continuar Lendo →

19 19America/Sao_Paulo fevereiro 19America/Sao_Paulo 2018 0

API Create Reservations

In This Post I want to show how create a reservations using API Oracle Some times it's necessary to use API for work with integrations. The script below can be used for create a reservation. DECLARE l_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_new_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_new_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; x_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2 (2) := FND_API.G_TRUE;... Continuar Lendo →

12 12America/Sao_Paulo fevereiro 12America/Sao_Paulo 2018 0

Acima ↑

Tag: CREATE

API para submeter para aprovação a OC

Creating / Updating costs by Interface

API Create Reservations

Categorias

Siga-me

Posts recentes