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.

[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on INL_SHIP_LINES

Line 97: IF p_parent_table_name = 'INL_SHIP_LINES_INT' THEN

93: p_procedure_name => l_proc_name,
94: p_debug_info => l_debug_info
95: ) ;
96: -- In case of error during Shipment Line import process
97: IF p_parent_table_name = 'INL_SHIP_LINES_INT' THEN
98: l_debug_info := 'Set Shipment Line Interface status to ERROR.';
99: INL_LOGGING_PVT.LOG_STATEMENT(
100: P_MODULE_NAME => G_MODULE_NAME,
101: P_PROCEDURE_NAME => L_PROC_NAME,

Line 104: UPDATE inl_ship_lines_int

100: P_MODULE_NAME => G_MODULE_NAME,
101: P_PROCEDURE_NAME => L_PROC_NAME,
102: P_DEBUG_INFO => L_DEBUG_INFO
103: ) ;
104: UPDATE inl_ship_lines_int
105: SET processing_status_code = 'ERROR' ,
106: request_id = fnd_global.conc_request_id,
107: last_updated_by = fnd_global.user_id ,
108: last_update_date = SYSDATE ,

Line 117: FROM inl_ship_lines_int

113: WHERE ship_line_int_id = p_parent_table_id
114: AND processing_status_code <> 'ERROR';
115: SELECT ship_header_int_id
116: INTO l_ship_header_int_id
117: FROM inl_ship_lines_int
118: WHERE ship_line_int_id = p_parent_table_id;
119: ELSIF p_parent_table_name = 'INL_MATCHES_INT' THEN
120: l_debug_info := 'Set Match Interface status to ERROR.';
121: INL_LOGGING_PVT.Log_Statement(

Line 824: p_parent_table_name => 'INL_SHIP_LINES_INT',

820: WHEN OTHERS THEN
821: l_result := FND_API.G_FALSE;
822: -- Add a line into inl_ship_errors
823: Handle_InterfError(
824: p_parent_table_name => 'INL_SHIP_LINES_INT',
825: p_parent_table_id => p_ship_line_int_id,
826: p_column_name => 'SHIP_LINE_TYPE_ID',
827: p_column_value => p_ship_line_type_id,
828: p_error_message_name => 'INL_ERR_LN_TP',

Line 1401: FROM inl_ship_lines_int

1397: END IF;
1398: ELSE
1399: SELECT COUNT( *)
1400: INTO l_aux
1401: FROM inl_ship_lines_int
1402: WHERE ship_header_int_id = p_ship_header_int_id
1403: AND
1404: (
1405: ship_header_id IS NOT NULL

Line 1427: FROM inl_ship_lines_int

1423: -- Add a line into inl_ship_errors
1424: FOR c_lin_err IN
1425: (
1426: SELECT ship_line_int_id
1427: FROM inl_ship_lines_int
1428: WHERE ship_header_int_id = p_ship_header_int_id
1429: AND
1430: (
1431: ship_header_id IS NOT NULL

Line 1437: p_parent_table_name => 'INL_SHIP_LINES_INT',

1433: )
1434: )
1435: LOOP
1436: Handle_InterfError(
1437: p_parent_table_name => 'INL_SHIP_LINES_INT',
1438: p_parent_table_id => c_lin_err.ship_line_int_id,
1439: p_column_name => 'TRANSACTION_TYPE',
1440: p_column_value => p_transaction_type,
1441: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NNULL',

Line 1486: FROM inl_ship_lines_int a

1482: END IF;
1483: END IF;
1484: SELECT COUNT( *)
1485: INTO l_aux
1486: FROM inl_ship_lines_int a
1487: WHERE a.ship_header_int_id = p_ship_header_int_id
1488: AND a.ship_line_id IS NOT NULL
1489: AND NOT EXISTS
1490: (

Line 1492: FROM inl_ship_lines_all l,

1488: AND a.ship_line_id IS NOT NULL
1489: AND NOT EXISTS
1490: (
1491: SELECT 1
1492: FROM inl_ship_lines_all l,
1493: inl_ship_line_groups g
1494: WHERE l.ship_line_id = a.ship_line_id
1495: AND l.ship_line_group_id = g.ship_line_group_id
1496: AND NVL(a.ship_line_group_reference, FND_API.G_MISS_CHAR) = NVL(g.ship_line_group_reference, FND_API.G_MISS_CHAR)

Line 1535: FROM inl_ship_lines_int a

1531: END IF;
1532: -- Add a line into inl_ship_errors for each line
1533: FOR c_lin_err IN (
1534: SELECT ship_line_int_id
1535: FROM inl_ship_lines_int a
1536: WHERE a.ship_header_int_id = p_ship_header_int_id
1537: AND a.ship_line_id IS NOT NULL
1538: AND NOT EXISTS
1539: (

Line 1541: FROM inl_ship_lines_all l,

1537: AND a.ship_line_id IS NOT NULL
1538: AND NOT EXISTS
1539: (
1540: SELECT 1
1541: FROM inl_ship_lines_all l,
1542: inl_ship_line_groups g
1543: WHERE l.ship_line_id = a.ship_line_id
1544: AND l.ship_line_group_id = g.ship_line_group_id
1545: AND NVL(a.ship_line_group_reference, FND_API.G_MISS_CHAR) = NVL(g.ship_line_group_reference, FND_API.G_MISS_CHAR)

Line 1569: p_parent_table_name => 'INL_SHIP_LINES_INT',

1565: AND NVL(a.attribute15_lg, FND_API.G_MISS_CHAR) = NVL(g.attribute15, FND_API.G_MISS_CHAR)
1566: )
1567: ) LOOP
1568: Handle_InterfError(
1569: p_parent_table_name => 'INL_SHIP_LINES_INT',
1570: p_parent_table_id => c_lin_err.ship_line_int_id,
1571: p_column_name => 'TRANSACTION_TYPE',
1572: p_column_value => p_transaction_type,
1573: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_UPD_GRP',

Line 1613: FROM inl_ship_lines_int

1609: ELSE
1610: -- Check for all ids in lines
1611: SELECT COUNT( *)
1612: INTO l_aux
1613: FROM inl_ship_lines_int
1614: WHERE ship_header_int_id = p_ship_header_int_id
1615: AND (ship_header_id IS NULL
1616: OR ship_line_id IS NULL
1617: )

Line 1646: FROM inl_ship_lines_int

1642: END IF;
1643: -- Check for lines under a given interface header
1644: SELECT COUNT( *)
1645: INTO l_aux
1646: FROM inl_ship_lines_int
1647: WHERE ship_header_int_id = p_ship_header_int_id;
1648: -- Check if all lines were included into the Open Interface
1649: IF NVL(l_aux, 0) > 0 THEN
1650: SELECT COUNT( *)

Line 1652: FROM inl_ship_lines_all a

1648: -- Check if all lines were included into the Open Interface
1649: IF NVL(l_aux, 0) > 0 THEN
1650: SELECT COUNT( *)
1651: INTO l_aux
1652: FROM inl_ship_lines_all a
1653: WHERE a.ship_header_id = p_ship_header_id
1654: AND NOT EXISTS
1655: (
1656: SELECT 1

Line 1657: FROM inl_ship_lines_int b

1653: WHERE a.ship_header_id = p_ship_header_id
1654: AND NOT EXISTS
1655: (
1656: SELECT 1
1657: FROM inl_ship_lines_int b
1658: WHERE b.ship_header_int_id = p_ship_header_int_id
1659: AND b.ship_header_id = a.ship_header_id
1660: AND b.ship_line_id = a.ship_line_id
1661: )

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 2254: l_debug_info := 'Delete from inl_ship_lines_all';

2250: ) ;
2251: DELETE FROM inl.inl_associations
2252: WHERE ship_header_id = p_ship_header_id;
2253:
2254: l_debug_info := 'Delete from inl_ship_lines_all';
2255: INL_LOGGING_PVT.Log_Statement(
2256: p_module_name => g_module_name,
2257: p_procedure_name => l_proc_name,
2258: p_debug_info => l_debug_info

Line 2260: DELETE FROM inl.inl_ship_lines_all

2256: p_module_name => g_module_name,
2257: p_procedure_name => l_proc_name,
2258: p_debug_info => l_debug_info
2259: ) ;
2260: DELETE FROM inl.inl_ship_lines_all
2261: WHERE ship_header_id = p_ship_header_id;
2262:
2263: l_debug_info := 'Delete from inl_ship_line_groups';
2264: INL_LOGGING_PVT.Log_Statement(

Line 2385: FROM inl_ship_lines_int l

2381: AND h.processing_status_code = 'RUNNING'
2382: AND (h.transaction_type = 'DELETE'
2383: OR EXISTS (
2384: SELECT 1
2385: FROM inl_ship_lines_int l
2386: WHERE l.ship_header_int_id = h.ship_header_int_id
2387: AND ROWNUM < 2
2388: )
2389: )

Line 2429: UPDATE inl_ship_lines_int

2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427: -- Set processing status code to 'COMPLETED' for all lines
2428: -- related to the current and imported Shipment Header
2429: UPDATE inl_ship_lines_int
2430: SET processing_status_code = 'COMPLETED' ,
2431: request_id = fnd_global.conc_request_id,
2432: last_updated_by = fnd_global.user_id ,
2433: last_update_date = SYSDATE ,

Line 2987: FROM inl_ship_lines_int l

2983: AND h.transaction_type <> 'DELETE'
2984: AND h.last_task_code >= '10'
2985: AND EXISTS (
2986: SELECT 1
2987: FROM inl_ship_lines_int l
2988: WHERE l.ship_header_int_id = h.ship_header_int_id
2989: AND l.processing_status_code = 'RUNNING'
2990: AND ROWNUM < 2
2991: );

Line 3061: FROM inl_ship_lines_all

3057: IF validLines_List(iLine).ship_line_num IS NULL THEN
3058: -- Get the next Ship Line Number
3059: SELECT MAX(ship_line_num)
3060: INTO validLines_List(iLine).ship_line_num
3061: FROM inl_ship_lines_all
3062: WHERE ship_header_id = headersToProcess_List(iHead) .ship_header_id
3063: AND ship_line_group_id = rec_ship_line_groups.ship_line_group_id;
3064:
3065: validLines_List(iLine).ship_line_num := NVL(validLines_List(iLine).ship_line_num, 0) + 1;

Line 3080: SELECT inl_ship_Lines_all_s.NEXTVAL

3076: p_procedure_name => l_proc_name,
3077: p_debug_info => l_debug_info
3078: ) ;
3079: -- Get the next Shipment Line Id
3080: SELECT inl_ship_Lines_all_s.NEXTVAL
3081: INTO l_ship_line_id
3082: FROM dual;
3083:
3084: INL_LOGGING_PVT.Log_Variable(

Line 3097: INSERT INTO inl_ship_lines_all (

3093: p_procedure_name => l_proc_name,
3094: p_debug_info => l_debug_info
3095: ) ;
3096: -- Insert an INL SHIP LINE record
3097: INSERT INTO inl_ship_lines_all (
3098: ship_header_id, /* 01 */
3099: ship_line_group_id, /* 02 */
3100: ship_line_id, /* 03 */
3101: ship_line_num, /* 04 */

Line 3263: UPDATE inl_ship_lines_all

3259: p_procedure_name => l_proc_name,
3260: p_debug_info => l_debug_info
3261: ) ;
3262: -- update the INL SHIP LINE record
3263: UPDATE inl_ship_lines_all
3264: SET ship_line_num = NVL(validLines_List(iLine).ship_line_num, ship_line_num),/* 01 */
3265: ship_line_type_id = validLines_List(iLine).ship_line_type_id, /* 02 */
3266: ship_line_src_type_code = validLines_List(iLine).ship_line_src_type_code, /* 03 */
3267: ship_line_source_id = validLines_List(iLine).ship_line_source_id, /* 04 */

Line 3343: UPDATE inl_ship_lines_int

3339: p_debug_info => l_debug_info
3340: ) ;
3341: -- Set processing status code to COMPLETED
3342: -- for a given and imported Shipment Line
3343: UPDATE inl_ship_lines_int
3344: SET processing_status_code = 'COMPLETED' ,
3345: ship_header_id = headersToProcess_List(iHead).ship_header_id,
3346: ship_line_id = l_ship_line_id ,
3347: request_id = fnd_global.conc_request_id ,

Line 3582: x_new_to_parent_table_name := 'INL_SHIP_LINES';

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
3586: WHERE rt.transaction_id = x_new_to_parent_table_id

Line 3877: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINES' 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
3880: FROM inl_ship_lines
3881: WHERE ship_line_id = x_new_to_parent_table_id;

Line 3880: FROM inl_ship_lines

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
3880: FROM inl_ship_lines
3881: WHERE ship_line_id = x_new_to_parent_table_id;
3882: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
3883: SELECT ship_header_id
3884: INTO x_ship_header_id

Line 4545: FROM inl_ship_lines_int

4541: poo_organization_id ,
4542: poo_to_organization_code ,
4543: poo_location_id ,
4544: poo_location_code
4545: FROM inl_ship_lines_int
4546: WHERE ship_header_int_id = P_ship_header_int_id
4547: AND processing_status_code = 'PENDING'; --'ERROR' IN CASE OF FAIL
4548: TYPE toDeriveLines_List_Type IS TABLE OF toDeriveLines%ROWTYPE;
4549: toDeriveLines_List toDeriveLines_List_Type ;

Line 4613: UPDATE inl_ship_lines_int

4609: toDeriveLines_list(i) .secondary_uom_code := l_2ary_uom_code;
4610: toDeriveLines_list(i) .secondary_unit_price :=(toDeriveLines_list(i) .txn_qty * toDeriveLines_list(i) .txn_unit_price) / l_2ary_qty;
4611: END IF;
4612: IF l_updated_flag = 'Y' THEN
4613: UPDATE inl_ship_lines_int
4614: SET party_id = toDeriveLines_list(i) .party_id ,
4615: party_site_id = toDeriveLines_list(i) .party_site_id ,
4616: source_organization_id = toDeriveLines_list(i) .source_organization_id ,
4617: ship_line_type_id = toDeriveLines_list(i) .ship_line_type_id ,

Line 5069: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

5065: SELECT m1.match_id,
5066: m1.matched_qty ,
5067: m1.matched_uom_code
5068: FROM inl_corr_matches_v m1
5069: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
5070: AND m1.to_parent_table_id = p_ship_line_id
5071: AND m1.match_type_code = 'ITEM'
5072: AND m1.replace_estim_qty_flag = 'N'
5073: -- In case of resubmit the same actual value more than once, the

Line 5098: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

5094: m1.matched_qty ,
5095: m1.matched_uom_code ,
5096: m1.replace_estim_qty_flag
5097: FROM inl_matches_int m1
5098: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
5099: AND m1.to_parent_table_id = p_ship_line_id
5100: AND m1.match_int_id <> NVL(p_updated_match_id, 0)
5101: AND m1.processing_status_code = 'RUNNING'
5102: ORDER BY m1.match_int_id

Line 5148: FROM inl_ship_lines sl

5144: INTO l_ship_header_id,
5145: l_ship_line_num ,
5146: l_inventory_item_id ,
5147: l_ship_line_group_id
5148: FROM inl_ship_lines sl
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

Line 5200: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

5196: INTO l_unproc_actual_qty,
5197: l_unproc_uom_code,
5198: l_unproc_match_id
5199: FROM inl_corr_matches_v m1
5200: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
5201: AND m1.to_parent_table_id = p_ship_line_id
5202: AND m1.match_type_code = 'ITEM'
5203: AND m1.replace_estim_qty_flag = 'Y'
5204: AND m1.adj_already_generated_flag = 'N'

Line 5284: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

5280: )
5281: )
5282: INTO l_unproc_actual_qty
5283: FROM inl_corr_matches_v m1
5284: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
5285: AND m1.to_parent_table_id = p_ship_line_id
5286: AND m1.match_type_code = 'ITEM'
5287: AND m1.replace_estim_qty_flag = 'N'
5288: AND m1.adj_already_generated_flag = 'N'

Line 6291: 'INL_SHIP_LINES',

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',
6295: 'RCV_TRANSACTIONS'

Line 6298: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',

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

Line 6316: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN

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;
6316: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
6317: l_INT_importedOk := 'Y';
6318: SELECT ship_header_id
6319: INTO l_ship_header_id
6320: FROM inl_ship_lines

Line 6320: FROM inl_ship_lines

6316: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
6317: l_INT_importedOk := 'Y';
6318: SELECT ship_header_id
6319: INTO l_ship_header_id
6320: FROM inl_ship_lines
6321: WHERE ship_line_id = p_to_parent_table_id;
6322: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
6323: l_matchTpCdOk := 'Y';
6324: END IF;

Line 6359: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN

6355: WHERE tax_line_id = p_to_parent_table_id;
6356: IF p_match_type_code IN('TAX') THEN
6357: l_matchTpCdOk := 'Y';
6358: END IF;
6359: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN
6360: SELECT ship_header_id
6361: INTO l_ship_header_id
6362: FROM inl_ship_lines_int
6363: WHERE ship_line_int_id = p_to_parent_table_id;

Line 6362: FROM inl_ship_lines_int

6358: END IF;
6359: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN
6360: SELECT ship_header_id
6361: INTO l_ship_header_id
6362: FROM inl_ship_lines_int
6363: WHERE ship_line_int_id = p_to_parent_table_id;
6364: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
6365: l_matchTpCdOk := 'Y';
6366: END IF;

Line 6370: FROM inl_ship_lines

6366: END IF;
6367: -- Check if the Interface has been imported
6368: SELECT ship_header_id
6369: INTO l_ship_header_id
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

Line 6396: FROM inl_ship_lines

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
6397: WHERE ship_line_id = l_ship_line_id;
6398: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
6399: l_matchTpCdOk := 'Y';
6400: END IF;

Line 7368: IF((p_match_int_rec.to_parent_table_name = 'INL_SHIP_LINES'

7364: p_module_name => g_module_name,
7365: p_procedure_name => l_func_name,
7366: p_debug_info => l_debug_info
7367: );
7368: IF((p_match_int_rec.to_parent_table_name = 'INL_SHIP_LINES'
7369: AND p_match_int_rec.match_type_code = 'ITEM')
7370: OR (l_parent_to_parent_table_name = 'INL_SHIP_LINES'
7371: AND l_parent_match_type_code = 'ITEM'
7372: )

Line 7370: OR (l_parent_to_parent_table_name = 'INL_SHIP_LINES'

7366: p_debug_info => l_debug_info
7367: );
7368: IF((p_match_int_rec.to_parent_table_name = 'INL_SHIP_LINES'
7369: AND p_match_int_rec.match_type_code = 'ITEM')
7370: OR (l_parent_to_parent_table_name = 'INL_SHIP_LINES'
7371: AND l_parent_match_type_code = 'ITEM'
7372: )
7373: ) AND p_match_int_rec.matched_qty IS NOT NULL
7374: THEN

Line 8095: FROM inl_ship_lines_int l

8091: h.transaction_type = 'DELETE'
8092: OR EXISTS
8093: (
8094: SELECT 1
8095: FROM inl_ship_lines_int l
8096: WHERE l.ship_header_int_id = h.ship_header_int_id
8097: AND ROWNUM < 2
8098: )
8099: ) ;

Line 8112: FROM inl_ship_lines_int l

8108: SELECT
8109: ship_header_int_id ,
8110: ship_line_int_id ,
8111: ship_line_type_id
8112: FROM inl_ship_lines_int l
8113: WHERE l.processing_status_code = 'PENDING'
8114: AND l.ship_header_int_id = p_ship_header_int_id;
8115:
8116: TYPE ship_lin_int_list_type IS TABLE OF c_ship_lin_int%ROWTYPE;

Line 8350: UPDATE inl_ship_lines_int

8346: program_id = fnd_global.conc_program_id,
8347: program_update_date = SYSDATE ,
8348: program_application_id = fnd_global.prog_appl_id
8349: WHERE ship_header_int_id = l_ship_header_int_id;
8350: UPDATE inl_ship_lines_int
8351: SET processing_status_code = 'RUNNING' ,
8352: request_id = fnd_global.conc_request_id,
8353: last_updated_by = fnd_global.user_id ,
8354: last_update_date = SYSDATE ,

Line 8378: UPDATE inl_ship_lines_int

8374: program_id = fnd_global.conc_program_id,
8375: program_update_date = SYSDATE ,
8376: program_application_id = fnd_global.prog_appl_id
8377: WHERE ship_header_int_id = l_ship_header_int_id;
8378: UPDATE inl_ship_lines_int
8379: SET processing_status_code = 'COMPLETED' ,
8380: request_id = fnd_global.conc_request_id,
8381: last_updated_by = fnd_global.user_id ,
8382: last_update_date = SYSDATE ,

Line 8478: FROM inl_ship_lines_int l

8474: AND h.last_task_code >= '20'
8475: AND EXISTS
8476: (
8477: SELECT 1
8478: FROM inl_ship_lines_int l
8479: WHERE l.ship_header_int_id = h.ship_header_int_id
8480: AND ROWNUM < 2
8481: )
8482: AND h.request_id = fnd_global.conc_request_id;

Line 8517: FROM inl_ship_lines_int l

8513: OR h.org_id = p_org_id)
8514: AND h.processing_status_code = 'RUNNING'
8515: AND (h.transaction_type = 'DELETE'
8516: OR EXISTS (SELECT 1
8517: FROM inl_ship_lines_int l
8518: WHERE l.ship_header_int_id = h.ship_header_int_id
8519: AND ROWNUM < 2
8520: )
8521: )