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 →

API to create a Customer

This post I put a code to create a client, it will serve as a basic register to be able to issue a sales order. DECLARE v_location_rec hz_location_v2pub.location_rec_type; v_party_site_rec hz_party_site_v2pub.party_site_rec_type; v_cust_site_use_rec hz_cust_account_site_v2pub.cust_site_use_rec_type; v_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type; v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type; v_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type; v_organization_rec hz_party_v2pub.organization_rec_type; v_cust_account_id NUMBER; v_account_number VARCHAR2(2000); v_party_id NUMBER; v_party_number VARCHAR2(2000); v_profile_id NUMBER; v_return_status VARCHAR2(2000); v_msg_count NUMBER; v_msg_data... Continuar Lendo →

Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren

Acima ↑