DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on RCV_TRANSACTIONS

Line 3581: IF x_new_to_parent_table_name = 'RCV_TRANSACTIONS' THEN

3577: p_module_name => g_module_name,
3578: p_procedure_name => l_proc_name,
3579: p_debug_info => l_debug_info
3580: ) ;
3581: IF x_new_to_parent_table_name = 'RCV_TRANSACTIONS' THEN
3582: x_new_to_parent_table_name := 'INL_SHIP_LINES';
3583: SELECT lcm_shipment_line_id
3584: INTO x_new_to_parent_table_id
3585: FROM rcv_transactions rt

Line 3585: FROM rcv_transactions rt

3581: IF x_new_to_parent_table_name = 'RCV_TRANSACTIONS' THEN
3582: x_new_to_parent_table_name := 'INL_SHIP_LINES';
3583: SELECT lcm_shipment_line_id
3584: INTO x_new_to_parent_table_id
3585: FROM rcv_transactions rt
3586: WHERE rt.transaction_id = x_new_to_parent_table_id
3587: ;
3588: END IF;
3589: Set_existingMatchInfoFlag(

Line 6295: 'RCV_TRANSACTIONS'

6291: 'INL_SHIP_LINES',
6292: 'INL_SHIP_LINE_GROUPS',
6293: 'INL_CHARGE_LINES',
6294: 'INL_TAX_LINES',
6295: 'RCV_TRANSACTIONS'
6296: )
6297: OR (p_transaction_type = 'CREATE'
6298: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',
6299: 'INL_SHIP_HEADERS_INT')

Line 6388: ELSIF p_to_parent_table_name = 'RCV_TRANSACTIONS' THEN

6384: INTO l_ship_header_id
6385: FROM inl_ship_headers
6386: WHERE ship_header_int_id = p_to_parent_table_id;
6387: l_INT_importedOk := 'Y';
6388: ELSIF p_to_parent_table_name = 'RCV_TRANSACTIONS' THEN
6389: l_INT_importedOk := 'Y';
6390: SELECT lcm_shipment_line_id
6391: INTO l_ship_line_id
6392: FROM rcv_transactions rt

Line 6392: FROM rcv_transactions rt

6388: ELSIF p_to_parent_table_name = 'RCV_TRANSACTIONS' THEN
6389: l_INT_importedOk := 'Y';
6390: SELECT lcm_shipment_line_id
6391: INTO l_ship_line_id
6392: FROM rcv_transactions rt
6393: WHERE rt.transaction_id = p_to_parent_table_id;
6394: SELECT ship_header_id
6395: INTO l_ship_header_id
6396: FROM inl_ship_lines