APPS.INL_INTERFACE_PVT dependencies on INL_SHIP_LINES_ALL

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 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 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 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 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 */