[Home] [Help]
784: -- rcv_clear_global in INVRCVCB.pls and not g_header_intf_id
785: -- we look at g_shipment_header_id to figure out if we need
786: -- to generate a new value for header_intf_id to insert in RTI.
787: IF g_shipment_header_id IS NULL THEN
788: SELECT rcv_headers_interface_s.NEXTVAL
789: INTO g_header_intf_id
790: FROM dual;
791: END IF;
792:
6706: INTO v_processing_status_code
6707: FROM RCV_TRANSACTIONS_INTERFACE
6708: WHERE HEADER_INTERFACE_ID in
6709: (SELECT HEADER_INTERFACE_ID
6710: FROM RCV_HEADERS_INTERFACE
6711: WHERE receipt_num = p_lcmReceiptNum
6712: AND SHIP_TO_ORGANIZATION_ID = p_lcmOrgID)
6713: AND ROWNUM < 2;
6714:
7394: , p_attribute13 IN VARCHAR2 DEFAULT NULL
7395: , p_attribute14 IN VARCHAR2 DEFAULT NULL
7396: , p_attribute15 IN VARCHAR2 DEFAULT NULL
7397: ) IS
7398: l_header rcv_headers_interface%ROWTYPE;
7399: l_rowid VARCHAR2(40);
7400: l_sysdate DATE := SYSDATE;
7401: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7402: l_msg_count NUMBER;
7508:
7509: l_progress := '20';
7510:
7511: IF g_header_intf_id IS NULL THEN
7512: SELECT rcv_headers_interface_s.NEXTVAL
7513: INTO g_header_intf_id
7514: FROM SYS.DUAL;
7515: END IF;
7516:
7515: END IF;
7516:
7517: l_progress := '25';
7518:
7519: INSERT INTO rcv_headers_interface
7520: (
7521: header_interface_id
7522: , group_id
7523: , processing_status_code
7733: WHERE shipment_header_id = g_shipment_header_id;
7734: end if;
7735: --bug9409867 end
7736: l_progress := '40';
7737: UPDATE rcv_headers_interface
7738: SET customer_id = Nvl(p_customer_id, customer_id)
7739: , last_update_date = l_sysdate
7740: , last_update_login = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_update_login)
7741: , last_updated_by = NVL(inv_rcv_common_apis.g_po_startup_value.user_id, last_updated_by)