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_INTERFACE_PVT dependencies on INL_SHIP_HEADERS

Line 156: IF p_parent_table_name = 'INL_SHIP_HEADERS_INT' OR l_ship_header_int_id IS NOT NULL THEN

152: program_application_id = fnd_global.prog_appl_id
153: WHERE match_amount_int_id = p_parent_table_id
154: AND processing_status_code <> 'ERROR';
155: END IF;
156: IF p_parent_table_name = 'INL_SHIP_HEADERS_INT' OR l_ship_header_int_id IS NOT NULL THEN
157: l_debug_info := 'Set Shipment Header Interface status to ERROR.';
158: INL_LOGGING_PVT.Log_Statement(
159: p_module_name => g_module_name,
160: p_procedure_name => l_proc_name,

Line 163: UPDATE inl_ship_headers_int

159: p_module_name => g_module_name,
160: p_procedure_name => l_proc_name,
161: p_debug_info => l_debug_info
162: ) ;
163: UPDATE inl_ship_headers_int
164: SET processing_status_code = 'ERROR' ,
165: request_id = fnd_global.conc_request_id,
166: last_updated_by = fnd_global.user_id ,
167: last_update_date = SYSDATE ,

Line 569: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

565: IF p_ship_num IS NOT NULL THEN
566: l_result := FND_API.G_FALSE;
567: -- Add a line into inl_ship_errors
568: Handle_InterfError(
569: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
570: p_parent_table_id => p_ship_header_int_id,
571: p_column_name => 'SHIP_NUM',
572: p_column_value => p_ship_num,
573: p_error_message_name => 'INL_ERR_SHIP_NUM_NNULL',

Line 589: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

585: IF p_ship_num IS NULL THEN
586: l_result := FND_API.G_FALSE;
587: -- Add a line into inl_ship_errors
588: Handle_InterfError(
589: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
590: p_parent_table_id => p_ship_header_int_id,
591: p_column_name => 'SHIP_NUM',
592: p_column_value => p_ship_num,
593: p_error_message_name => 'INL_ERR_SHIP_NUM_NULL',

Line 703: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

699: WHEN OTHERS THEN
700: l_result := FND_API.G_FALSE;
701: -- Add a line into inl_ship_errors
702: Handle_InterfError(
703: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
704: p_parent_table_id => p_ship_header_int_id,
705: p_column_name => 'SHIP_TYPE_ID',
706: p_column_value => p_ship_type_id,
707: p_error_message_name => 'INL_ERR_SHIP_TP',

Line 922: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

918: IF p_org_id IS NULL THEN
919: l_result := FND_API.G_FALSE;
920: -- Add a line into inl_ship_errors
921: Handle_InterfError(
922: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
923: p_parent_table_id => p_ship_header_int_id,
924: p_column_name => 'ORG_ID',
925: p_column_value => p_org_id,
926: p_error_message_name => 'INL_ERR_OP_UNIT_NULL',

Line 953: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

949: IF NVL(l_org_count, 0) = 0 THEN
950: l_result := FND_API.G_FALSE;
951: -- Add a line into inl_ship_errors
952: Handle_InterfError(
953: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
954: p_parent_table_id => p_ship_header_int_id,
955: p_column_name => 'ORG_ID',
956: p_column_value => p_org_id,
957: p_error_message_name => 'INL_ERR_INVL_OP_UNIT',

Line 1051: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1047: IF p_organization_id IS NULL THEN
1048: l_result := FND_API.G_FALSE;
1049: -- Add a line into inl_ship_errors
1050: Handle_InterfError(
1051: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1052: p_parent_table_id => p_ship_header_int_id,
1053: p_column_name => 'ORGANIZATION_ID',
1054: p_column_value => p_organization_id,
1055: p_error_message_name => 'INL_ERR_INV_ORG_NULL',

Line 1080: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1076: l_result := FND_API.G_FALSE;
1077: l_organization_count := 0;
1078: -- Add a line into inl_ship_errors
1079: Handle_InterfError(
1080: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1081: p_parent_table_id => p_ship_header_int_id,
1082: p_column_name => 'ORGANIZATION_ID',
1083: p_column_value => p_organization_id,
1084: p_error_message_name => 'INL_ERR_INVL_INV_ORG',

Line 1110: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1106: IF NVL(l_organization_count, 0) = 0 THEN
1107: l_result := FND_API.G_FALSE;
1108: -- Add a line into inl_ship_errors
1109: Handle_InterfError(
1110: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1111: p_parent_table_id => p_ship_header_int_id,
1112: p_column_name => 'ORGANIZATION_ID',
1113: p_column_value => p_organization_id,
1114: p_error_message_name => 'INL_ERR_NO_LCM_OPT_DEF',

Line 1381: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1377: IF p_ship_header_id IS NOT NULL THEN
1378: l_response := FALSE;
1379: -- Add a line into inl_ship_errors
1380: Handle_InterfError(
1381: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1382: p_parent_table_id => p_ship_header_int_id,
1383: p_column_name => 'TRANSACTION_TYPE',
1384: p_column_value => p_transaction_type,
1385: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NNULL',

Line 1410: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1406: OR ship_line_id IS NOT NULL
1407: ) ;
1408: IF NVL(l_aux, 0) > 0 THEN
1409: Handle_InterfError(
1410: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1411: p_parent_table_id => p_ship_header_int_id,
1412: p_column_name => 'TRANSACTION_TYPE',
1413: p_column_value => p_transaction_type,
1414: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NNULL',

Line 1464: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1460: IF p_ship_header_id IS NULL THEN
1461: l_response := FALSE;
1462: -- Add a line into inl_ship_errors
1463: Handle_InterfError(
1464: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1465: p_parent_table_id => p_ship_header_int_id,
1466: p_column_name => 'TRANSACTION_TYPE',
1467: p_column_value => p_transaction_type,
1468: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 1521: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1517: ) ;
1518: IF NVL(l_aux, 0) > 0 THEN
1519: l_response := FALSE;
1520: Handle_InterfError(
1521: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1522: p_parent_table_id => p_ship_header_int_id,
1523: p_column_name => 'TRANSACTION_TYPE',
1524: p_column_value => p_transaction_type,
1525: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_UPD_GRP',

Line 1590: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1586: IF p_ship_header_id IS NULL THEN
1587: l_response := FALSE;
1588: -- Add a line into inl_ship_errors
1589: Handle_InterfError(
1590: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1591: p_parent_table_id => p_ship_header_int_id,
1592: p_column_name => 'TRANSACTION_TYPE',
1593: p_column_value => p_transaction_type,
1594: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 1623: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1619: IF NVL(l_aux, 0) > 0 THEN
1620: l_response := FALSE;
1621: -- Add a line into inl_ship_errors
1622: Handle_InterfError(
1623: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1624: p_parent_table_id => p_ship_header_int_id,
1625: p_column_name => 'TRANSACTION_TYPE',
1626: p_column_value => p_transaction_type,
1627: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 1667: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1663: IF NVL(l_aux, 0) > 0 THEN
1664: l_response := FALSE;
1665: -- Add a line into inl_ship_errors
1666: Handle_InterfError(
1667: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1668: p_parent_table_id => p_ship_header_int_id,
1669: p_column_name => 'TRANSACTION_TYPE',
1670: p_column_value => p_transaction_type,
1671: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_DEL',

Line 1687: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1683: ELSE
1684: l_response := FALSE;
1685: -- Add a line into inl_ship_errors
1686: Handle_InterfError(
1687: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1688: p_parent_table_id => p_ship_header_int_id,
1689: p_column_name => 'TRANSACTION_TYPE',
1690: p_column_value => p_transaction_type,
1691: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 1712: FROM inl_ship_headers_all a

1708: AND p_ship_header_id IS NOT NULL
1709: THEN
1710: SELECT SHIP_STATUS_CODE
1711: INTO l_status
1712: FROM inl_ship_headers_all a
1713: WHERE a.ship_header_id = p_ship_header_id;
1714: IF l_status = 'COMPLETED' THEN
1715: l_response := FALSE;
1716: -- Add a line into inl_ship_errors

Line 1718: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1714: IF l_status = 'COMPLETED' THEN
1715: l_response := FALSE;
1716: -- Add a line into inl_ship_errors
1717: Handle_InterfError(
1718: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1719: p_parent_table_id => p_ship_header_int_id,
1720: p_column_name => 'TRANSACTION_TYPE',
1721: p_column_value => p_transaction_type,
1722: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_STA_INVL',

Line 1895: p_in_param_value1 => 'INL_SHIP_HEADERS_INT',

1891: p_module_name => g_module_name,
1892: p_procedure_name => l_func_name,
1893: p_call_api_name => 'Validate_LastTaskCode',
1894: p_in_param_name1 => 'p_parent_table_name',
1895: p_in_param_value1 => 'INL_SHIP_HEADERS_INT',
1896: p_in_param_name2 => 'p_parent_table_id',
1897: p_in_param_value2 => p_ship_header_int_id,
1898: p_in_param_name3 => 'p_last_task_code',
1899: p_in_param_value3 => p_last_task_code

Line 1902: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1898: p_in_param_name3 => 'p_last_task_code',
1899: p_in_param_value3 => p_last_task_code
1900: ) ;
1901: l_response := Validate_LastTaskCode(
1902: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1903: p_parent_table_id => p_ship_header_int_id,
1904: p_last_task_code => p_last_task_code,
1905: x_return_status => l_return_status) ;
1906: -- If any errors happen abort API.

Line 2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all

2170: -- Utility name : Delete_Ship
2171: -- Type : Private
2172: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations,
2173: -- inl_allocations, inl_tax_lines, inl_charge_lines,
2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
2175: -- Pre-reqs : None
2176: -- Parameters :
2177: -- IN : p_ship_header_id IN NUMBER
2178: --

Line 2272: l_debug_info := 'Delete from inl_ship_headers_all';

2268: ) ;
2269: DELETE FROM inl.inl_ship_line_groups
2270: WHERE ship_header_id = p_ship_header_id;
2271:
2272: l_debug_info := 'Delete from inl_ship_headers_all';
2273: INL_LOGGING_PVT.Log_Statement(
2274: p_module_name => g_module_name,
2275: p_procedure_name => l_proc_name,
2276: p_debug_info => l_debug_info

Line 2278: DELETE FROM inl.inl_ship_headers_all WHERE ship_header_id = p_ship_header_id;

2274: p_module_name => g_module_name,
2275: p_procedure_name => l_proc_name,
2276: p_debug_info => l_debug_info
2277: ) ;
2278: DELETE FROM inl.inl_ship_headers_all WHERE ship_header_id = p_ship_header_id;
2279: -- Standard End of Procedure/Function Logging
2280: INL_LOGGING_PVT.Log_EndProc(
2281: p_module_name => g_module_name,
2282: p_procedure_name => l_proc_name

Line 2318: -- table to INL_SHIP_HEADERS_ALL

2314: END Delete_Ship;
2315: -- Utility name : Import_Headers
2316: -- Type : Private
2317: -- Function : Import Shipment Headers from Interface
2318: -- table to INL_SHIP_HEADERS_ALL
2319: --
2320: -- Pre-reqs : None
2321: -- Parameters :
2322: -- IN : p_group_id IN NUMBER

Line 2373: FROM inl_ship_headers_int h

2369: h.attribute13 ,
2370: h.attribute14 ,
2371: h.attribute15 ,
2372: h.ship_header_id
2373: FROM inl_ship_headers_int h
2374: WHERE (p_group_id IS NULL
2375: OR h.group_id = p_group_id
2376: )
2377: AND ( p_org_id IS NULL

Line 2460: UPDATE inl_ship_headers

2456: p_module_name => g_module_name,
2457: p_procedure_name => l_proc_name,
2458: p_debug_info => l_debug_info
2459: ) ;
2460: UPDATE inl_ship_headers
2461: SET ship_num = DECODE(l_user_defined_ship_num_code, 'AUTOMATIC', ship_num, validHeaders_List(iHead) .ship_num), -- 02
2462: ship_date = validHeaders_List(iHead) .ship_date , -- 03
2463: ship_type_id = validHeaders_List(iHead) .ship_type_id , -- 04
2464: legal_entity_id = validHeaders_List(iHead) .legal_entity_id , -- 08

Line 2500: SELECT inl_ship_headers_all_s.NEXTVAL

2496: attribute15 = validHeaders_List(iHead) .attribute15 -- 42
2497: WHERE ship_header_id = validHeaders_List(iHead) .ship_header_id;
2498: ELSE
2499: -- Get Shipment Header's nextval
2500: SELECT inl_ship_headers_all_s.NEXTVAL
2501: INTO validHeaders_List(iHead) .ship_header_id
2502: FROM dual;
2503:
2504: INL_LOGGING_PVT.Log_Variable(

Line 2548: INTO inl_ship_headers (

2544: p_debug_info => l_debug_info
2545: ) ;
2546: -- Insert an INL SHIP HEADER record
2547: INSERT
2548: INTO inl_ship_headers (
2549: ship_header_id , -- 01
2550: ship_num , -- 02
2551: ship_date , -- 03
2552: ship_type_id , -- 04

Line 2645: UPDATE inl_ship_headers_int

2641: p_debug_info => l_debug_info
2642: ) ;
2643: -- Set processing status code to COMPLETED
2644: -- for the current and imported Shipment Header
2645: UPDATE inl_ship_headers_int
2646: SET processing_status_code = 'COMPLETED' ,
2647: ship_header_id = validHeaders_List(iHead).ship_header_id,
2648: request_id = fnd_global.conc_request_id ,
2649: last_updated_by = fnd_global.user_id ,

Line 2977: FROM inl_ship_headers_int h

2973: IS
2974: SELECT h.ship_header_int_id,
2975: h.ship_header_id ,
2976: h.transaction_type
2977: FROM inl_ship_headers_int h
2978: WHERE (p_group_id IS NULL
2979: OR group_id = p_group_id)
2980: AND (p_org_id IS NULL
2981: OR h.org_id = p_org_id)

Line 3872: IF x_new_to_parent_table_name = 'INL_SHIP_HEADERS' THEN

3868: x_nrec_tax_amt := NVL(x_nrec_tax_amt, 0) + NVL(l_mat_nrec_tax_amt_P, 0) ;
3869: END IF;
3870: END IF;
3871:
3872: IF x_new_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
3873: SELECT ship_header_id
3874: INTO x_ship_header_id
3875: FROM inl_ship_headers
3876: WHERE ship_header_id = x_new_to_parent_table_id;

Line 3875: FROM inl_ship_headers

3871:
3872: IF x_new_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
3873: SELECT ship_header_id
3874: INTO x_ship_header_id
3875: FROM inl_ship_headers
3876: WHERE ship_header_id = x_new_to_parent_table_id;
3877: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINES' THEN
3878: SELECT ship_header_id
3879: INTO x_ship_header_id

Line 4321: UPDATE inl_ship_headers sH

4317: p_procedure_name => l_proc_name,
4318: p_debug_info => l_debug_info
4319: );
4320: -- Set Pending Matching Flag = 'Y' to the current Shipment Header
4321: UPDATE inl_ship_headers sH
4322: SET sH.pending_matching_flag = 'Y',
4323: sH.request_id = fnd_global.conc_request_id,
4324: sH.last_updated_by = fnd_global.user_id,
4325: sH.last_update_date = SYSDATE,

Line 4423: UPDATE inl_ship_headers_int sh

4419: p_procedure_name => l_proc_name
4420: ) ;
4421: -- Initialize API return status to success
4422: x_return_status := FND_API.G_RET_STS_SUCCESS;
4423: UPDATE inl_ship_headers_int sh
4424: SET sh.location_id = (
4425: SELECT hou.location_id
4426: FROM hr_organization_units hou,
4427: hr_locations hl

Line 5153: FROM inl_ship_headers

5149: WHERE ship_line_id = p_ship_line_id;
5150: -- Get Organization_Id for UOM conversion purpose
5151: SELECT organization_id
5152: INTO l_organization_id
5153: FROM inl_ship_headers
5154: WHERE ship_header_id = l_ship_header_id;
5155:
5156: l_debug_info := 'Get from Adjustment View the TXN_QTY and TXN_UOM_CODE';
5157: INL_LOGGING_PVT.Log_Statement(

Line 6290: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',

6286: p_var_name => 'p_match_type_code',
6287: p_var_value => p_match_type_code
6288: ) ;
6289:
6290: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',
6291: 'INL_SHIP_LINES',
6292: 'INL_SHIP_LINE_GROUPS',
6293: 'INL_CHARGE_LINES',
6294: 'INL_TAX_LINES',

Line 6299: 'INL_SHIP_HEADERS_INT')

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')
6300: )
6301: OR(p_match_type_code = 'CORRECTION'
6302: AND p_to_parent_table_name IN('AP_INVOICE_DISTRIBUTIONS')
6303: )

Line 6307: IF p_to_parent_table_name = 'INL_SHIP_HEADERS' THEN

6303: )
6304: THEN
6305: l_nameOk := 'Y';
6306: BEGIN
6307: IF p_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
6308: l_INT_importedOk := 'Y';
6309: SELECT ship_header_id
6310: INTO l_ship_header_id
6311: FROM inl_ship_headers

Line 6311: FROM inl_ship_headers

6307: IF p_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
6308: l_INT_importedOk := 'Y';
6309: SELECT ship_header_id
6310: INTO l_ship_header_id
6311: FROM inl_ship_headers
6312: WHERE ship_header_id = p_to_parent_table_id;
6313: IF p_match_type_code = 'CHARGE' THEN
6314: l_matchTpCdOk := 'Y';
6315: END IF;

Line 6374: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN

6370: FROM inl_ship_lines
6371: WHERE ship_line_int_id = p_to_parent_table_id;
6372:
6373: l_INT_importedOk := 'Y';
6374: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN
6375: SELECT ship_header_id
6376: INTO l_ship_header_id
6377: FROM inl_ship_headers_int
6378: WHERE ship_header_int_id = p_to_parent_table_id;

Line 6377: FROM inl_ship_headers_int

6373: l_INT_importedOk := 'Y';
6374: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN
6375: SELECT ship_header_id
6376: INTO l_ship_header_id
6377: FROM inl_ship_headers_int
6378: WHERE ship_header_int_id = p_to_parent_table_id;
6379: IF p_match_type_code IN('CHARGE') THEN
6380: l_matchTpCdOk := 'Y';
6381: END IF;

Line 6385: FROM inl_ship_headers

6381: END IF;
6382: -- Check if the Interface record has been imported
6383: SELECT ship_header_id
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';

Line 8077: FROM inl_ship_headers_int h

8073: transaction_type ,
8074: ship_header_id ,
8075: ship_num ,
8076: ship_type_id
8077: FROM inl_ship_headers_int h
8078: WHERE
8079: (
8080: p_group_id IS NULL
8081: OR h.group_id = p_group_id

Line 8203: Reset_InterfError(p_parent_table_name => 'INL_SHIP_HEADERS_INT', p_parent_table_id => ship_hdr_int_list(i) .ship_header_int_id, x_return_status => l_return_status) ;

8199: p_module_name => g_module_name,
8200: p_procedure_name => l_proc_name,
8201: p_debug_info => l_debug_info
8202: );
8203: Reset_InterfError(p_parent_table_name => 'INL_SHIP_HEADERS_INT', p_parent_table_id => ship_hdr_int_list(i) .ship_header_int_id, x_return_status => l_return_status) ;
8204: -- If any errors happen abort API.
8205: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8206: RAISE FND_API.G_EXC_ERROR;
8207: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 8340: UPDATE inl_ship_headers_int

8336: p_module_name => g_module_name,
8337: p_procedure_name => l_proc_name,
8338: p_debug_info => l_debug_info
8339: );
8340: UPDATE inl_ship_headers_int
8341: SET processing_status_code = 'RUNNING' ,
8342: request_id = fnd_global.conc_request_id,
8343: last_updated_by = fnd_global.user_id ,
8344: last_update_date = SYSDATE ,

Line 8368: UPDATE inl_ship_headers_int

8364: p_module_name => g_module_name,
8365: p_procedure_name => l_proc_name,
8366: p_debug_info => l_debug_info
8367: );
8368: UPDATE inl_ship_headers_int
8369: SET processing_status_code = 'COMPLETED' ,
8370: request_id = fnd_global.conc_request_id,
8371: last_updated_by = fnd_global.user_id ,
8372: last_update_date = SYSDATE ,

Line 8461: FROM inl_ship_headers_int h

8457: SELECT h.ship_header_id,
8458: h.ship_header_int_id,
8459: h.last_task_code ,
8460: h.transaction_type
8461: FROM inl_ship_headers_int h
8462: WHERE
8463: (
8464: p_group_id IS NULL
8465: OR h.group_id = p_group_id

Line 8509: FROM inl_ship_headers_int h

8505: -- Get the Last Task Code to control
8506: -- which actions must be executed
8507: SELECT MAX(last_task_code)
8508: INTO l_mx_last_task_code
8509: FROM inl_ship_headers_int h
8510: WHERE (p_group_id IS NULL
8511: OR h.group_id = p_group_id)
8512: AND (p_org_id IS NULL
8513: OR h.org_id = p_org_id)