eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_SHIPMENT_PVT dependencies on INL_SHIP_HEADERS

Line 512: l_debug_info := 'Update the current INL_SHIP_HEADERS_ALL.ship_status_code to COMPLETED';

508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: END IF;
511:
512: l_debug_info := 'Update the current INL_SHIP_HEADERS_ALL.ship_status_code to COMPLETED';
513: INL_LOGGING_PVT.Log_Statement (
514: p_module_name => g_module_name,
515: p_procedure_name => l_api_name,
516: p_debug_info => l_debug_info

Line 519: UPDATE inl_ship_headers

515: p_procedure_name => l_api_name,
516: p_debug_info => l_debug_info
517: ) ;
518:
519: UPDATE inl_ship_headers
520: SET ship_status_code = 'COMPLETED',
521: last_updated_by = fnd_global.user_id,
522: last_update_date = SYSDATE
523: WHERE ship_header_id = p_ship_header_id;

Line 674: FROM inl_ship_headers sh

670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: SELECT sh.ship_status_code
673: INTO l_ship_status
674: FROM inl_ship_headers sh
675: WHERE sh.ship_header_id = p_ship_header_id;
676:
677: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
678: p_procedure_name => l_api_name,

Line 690: UPDATE inl_ship_headers

686: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END IF;
689: -- Update Shipment status to VALIDATION REQ
690: UPDATE inl_ship_headers
691: SET ship_status_code = 'VALIDATION REQ'
692: WHERE ship_header_id = p_ship_header_id;
693: END IF;
694: -- Standard check of p_commit.

Line 815: FROM inl_ship_headers

811: p_procedure_name => l_proc_name) ;
812: BEGIN
813: SELECT ship_num
814: INTO l_ship_header_num
815: FROM inl_ship_headers
816: WHERE ship_header_id = p_ship_header_id;
817: EXCEPTION
818: WHEN NO_DATA_FOUND THEN
819: RETURN '';

Line 1319: FROM inl_ship_headers sh,

1315: -- Search for other Shipment lines in Validated Shipments
1316: -- with receipts for the same receipt_source_code and src_id
1317: SELECT NVL (SUM (sl.primary_qty), 0)
1318: INTO x_qty_in_others_ops
1319: FROM inl_ship_headers sh,
1320: inl_adj_ship_lines_v sl
1321: WHERE sl.ship_header_id = sh.ship_header_id
1322: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1323: AND

Line 1343: FROM inl_ship_headers sh,

1339: p_debug_info => l_debug_info) ;
1340: FOR c_ship_num IN
1341: (
1342: SELECT DISTINCT sh.ship_num
1343: FROM inl_ship_headers sh,
1344: inl_adj_ship_lines_v sl
1345: WHERE sl.ship_header_id = sh.ship_header_id
1346: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1347: AND

Line 2203: FROM inl_ship_headers_all sh,

2199: l_inv_org_id,
2200: l_location_id,
2201: l_ship_date,
2202: l_pending_matching_flag
2203: FROM inl_ship_headers_all sh,
2204: inl_ship_types_vl shipt
2205: WHERE sh.ship_type_id = shipt.ship_type_id
2206: AND sh.ship_header_id = p_ship_header_id;
2207:

Line 2249: p_table_name => 'INL_SHIP_HEADERS',

2245: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2246: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
2247: p_ship_line_id => NULL,
2248: p_charge_line_id => NULL,
2249: p_table_name => 'INL_SHIP_HEADERS',
2250: p_column_name => 'SHIP_DATE',
2251: p_column_value => TO_CHAR (l_ship_date),
2252: p_error_message => SUBSTR (FND_MSG_PUB.Get (p_msg_index => FND_MSG_PUB.Count_Msg (),
2253: p_encoded => FND_API.g_false), 1, 2000),

Line 2286: p_table_name => 'INL_SHIP_HEADERS',

2282: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2283: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
2284: p_ship_line_id => NULL,
2285: p_charge_line_id => NULL,
2286: p_table_name => 'INL_SHIP_HEADERS',
2287: p_column_name => 'SHIP_TYPE_ID',
2288: p_column_value => l_ship_type_id,
2289: p_error_message => SUBSTR (FND_MSG_PUB.Get (p_msg_index => FND_MSG_PUB.Count_Msg (),
2290: p_encoded => FND_API.g_false), 1, 2000),

Line 2569: FROM inl_ship_headers

2565:
2566: IF (NVL (fnd_msg_pub.count_msg, 0) = 0) THEN
2567: SELECT ship_status_code
2568: INTO l_ship_status
2569: FROM inl_ship_headers
2570: WHERE ship_header_id = p_ship_header_id;
2571: IF l_ship_status <> 'COMPLETED' THEN
2572: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';
2573: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

Line 2572: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';

2568: INTO l_ship_status
2569: FROM inl_ship_headers
2570: WHERE ship_header_id = p_ship_header_id;
2571: IF l_ship_status <> 'COMPLETED' THEN
2572: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';
2573: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2574: p_procedure_name => l_api_name,
2575: p_debug_info => l_debug_info) ;
2576: UPDATE inl_ship_headers

Line 2576: UPDATE inl_ship_headers

2572: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';
2573: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2574: p_procedure_name => l_api_name,
2575: p_debug_info => l_debug_info) ;
2576: UPDATE inl_ship_headers
2577: SET ship_status_code = 'VALIDATED',
2578: last_updated_by = fnd_global.user_id,
2579: last_update_date = SYSDATE
2580: WHERE ship_header_id = p_ship_header_id;

Line 2583: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';

2579: last_update_date = SYSDATE
2580: WHERE ship_header_id = p_ship_header_id;
2581: END IF;
2582: ELSE
2583: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';
2584: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2585: p_procedure_name => l_api_name,
2586: p_debug_info => l_debug_info) ;
2587: UPDATE inl_ship_headers

Line 2587: UPDATE inl_ship_headers

2583: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';
2584: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2585: p_procedure_name => l_api_name,
2586: p_debug_info => l_debug_info) ;
2587: UPDATE inl_ship_headers
2588: SET ship_status_code = 'ON HOLD',
2589: last_updated_by = fnd_global.user_id,
2590: last_update_date = SYSDATE
2591: WHERE ship_header_id = p_ship_header_id;

Line 3346: inl_ship_headers sh

3342: l_from_parent_table_id , /* 20 */
3343: l_curr_match_id /* 21 */
3344: FROM inl_corr_matches_v mat,
3345: inl_ship_lines sl ,
3346: inl_ship_headers sh
3347: WHERE mat.match_id = p_match_id
3348: AND mat.to_parent_table_name = 'INL_SHIP_LINES'
3349: AND mat.adj_already_generated_flag = 'N'
3350: AND sl.ship_header_id = sh.ship_header_id

Line 5787: inl_ship_headers sh ,

5783: m.to_parent_table_id
5784: FROM
5785: inl_charge_lines cl,
5786: inl_ship_lines sl ,
5787: inl_ship_headers sh ,
5788: inl_corr_matches_v m
5789: WHERE
5790: cl.charge_line_id (+) = DECODE (m.to_parent_table_name, 'INL_CHARGE_LINES', m.to_parent_table_id, NULL)
5791: AND sl.ship_line_id (+) = DECODE (m.to_parent_table_name, 'INL_SHIP_LINES', m.to_parent_table_id, NULL)

Line 5810: inl_ship_headers sh,

5806: NULL AS tax_code ,
5807: NULL AS to_parent_table_name,
5808: NULL AS to_parent_table_id
5809: FROM
5810: inl_ship_headers sh,
5811: inl_corr_matches_v m
5812: WHERE
5813: sh.ship_header_id = m.ship_header_id
5814: AND m.ship_header_id = p_ship_header_id

Line 5850: FROM inl_ship_headers

5846: ) ;
5847:
5848: SELECT adjustment_num + 1
5849: INTO l_adjustment_num
5850: FROM inl_ship_headers
5851: WHERE ship_header_id = p_ship_header_id FOR UPDATE;
5852:
5853: l_debug_info := 'l_adjustment_num';
5854: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name, p_procedure_name => l_api_name, p_var_name => l_debug_info, p_var_value => TO_CHAR (l_adjustment_num)) ;

Line 5966: UPDATE inl_ship_headers

5962: ) ;
5963:
5964: -- Update Shipment Header Adjustment Number
5965: IF l_adjust_updt_flag THEN
5966: UPDATE inl_ship_headers
5967: SET adjustment_num = l_adjustment_num
5968: WHERE ship_header_id = p_ship_header_id;
5969: END IF;
5970: END;

Line 6347: FROM inl_ship_headers

6343: SELECT pending_matching_flag,
6344: organization_id
6345: INTO l_pending_matching_flag,
6346: l_organization_id
6347: FROM inl_ship_headers
6348: WHERE ship_header_id = p_ship_header_id;
6349:
6350: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
6351: p_procedure_name => l_api_name,

Line 6391: UPDATE inl_ship_headers

6387: p_procedure_name => l_api_name,
6388: p_debug_info => l_debug_info
6389: ) ;
6390:
6391: UPDATE inl_ship_headers
6392: SET pending_matching_flag = 'N',
6393: last_updated_by = fnd_global.user_id,
6394: last_update_date = SYSDATE,
6395: last_update_login = fnd_global.login_id

Line 6600: FROM inl_ship_headers

6596:
6597: -- Cursor to get all Pending Shipments
6598: CURSOR c_pending_shipments IS
6599: SELECT ship_header_id
6600: FROM inl_ship_headers
6601: WHERE ship_status_code = 'COMPLETED'
6602: AND pending_matching_flag = 'Y'
6603: AND (p_organization_id IS NULL
6604: OR organization_id = p_organization_id);

Line 6749: UPDATE inl_ship_headers

6745: BEGIN
6746: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6747: -- Initialize API return status to success
6748: x_return_status := FND_API.G_RET_STS_SUCCESS;
6749: UPDATE inl_ship_headers
6750: SET pending_matching_flag = p_pending_matching_flag,
6751: created_by = fnd_global.user_id ,
6752: creation_date = SYSDATE ,
6753: last_updated_by = fnd_global.user_id ,

Line 6821: inl_ship_headers sh

6817: SELECT a.ship_header_id ,
6818: sh.ship_status_code ship_status,
6819: sh.pending_matching_flag
6820: FROM inl_associations a,
6821: inl_ship_headers sh
6822: WHERE sh.ship_header_id = a.ship_header_id
6823: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
6824: AND a.from_parent_table_id = p_charge_line_id
6825: AND a.ship_header_id <> p_ship_header_id;