APPS.INV_RCV_STD_INSPECT_APIS dependencies on INV_RCV_INTEGRATION_APIS

Line 83: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;

79: l_serial_temp_id NUMBER;
80: l_lot_status_id NUMBER;
81: l_serial_status_id NUMBER;
82: l_lot_expiration_date DATE;
83: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
84: l_product_txn_id NUMBER;
85: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
86: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
87: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;

Line 85: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;

81: l_serial_status_id NUMBER;
82: l_lot_expiration_date DATE;
83: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
84: l_product_txn_id NUMBER;
85: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
86: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
87: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
88: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
89: l_is_rma NUMBER;

Line 86: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;

82: l_lot_expiration_date DATE;
83: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
84: l_product_txn_id NUMBER;
85: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
86: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
87: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
88: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
89: l_is_rma NUMBER;
90:

Line 87: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;

83: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
84: l_product_txn_id NUMBER;
85: l_yes VARCHAR2(1) := inv_rcv_integration_apis.G_YES;
86: l_no VARCHAR2(1) := inv_rcv_integration_apis.G_NO;
87: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
88: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
89: l_is_rma NUMBER;
90:
91: l_origination_type number;--OPM Convergence

Line 123: inv_rcv_integration_apis.insert_mtli(

119: AND inventory_item_id = p_inventory_item_id
120: AND organization_id = p_organization_id;
121:
122: --Call the insert_mtli API
123: inv_rcv_integration_apis.insert_mtli(
124: p_api_version => 1.0
125: , p_init_msg_lst => l_false
126: , x_return_status => x_return_status
127: , x_msg_count => x_msg_count

Line 194: inv_rcv_integration_apis.insert_msni(

190: l_txn_if_id := l_serial_temp_id;
191: END IF;
192:
193: --Call the insert_msni API
194: inv_rcv_integration_apis.insert_msni(
195: p_api_version => 1.0
196: , p_init_msg_lst => l_false
197: , x_return_status => x_return_status
198: , x_msg_count => x_msg_count

Line 479: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;

475: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
476: --New variables for Lot/Serial Support
477: l_lot_control_code NUMBER;
478: l_serial_control_code NUMBER;
479: l_mo_splt_tb inv_rcv_integration_apis.mo_in_tb_tp;
480: l_txn_qty_to_split NUMBER;
481: l_primary_qty_to_split NUMBER;
482: l_new_mol_id NUMBER;
483: l_split_line_id NUMBER; --for debug

Line 925: inv_rcv_integration_apis.split_mo(

921: print_debug(' p_orig_mol_id ============> ' || l_mol_line_id, 4);
922: print_debug(' p_mo_splt_tb(1).prim_qty => ' || l_mo_splt_tb(1).prim_qty, 4);
923: END IF;
924:
925: inv_rcv_integration_apis.split_mo(
926: p_orig_mol_id => l_mol_line_id
927: , p_mo_splt_tb => l_mo_splt_tb
928: , x_return_status => l_return_status
929: , x_msg_count => l_msg_count