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_LINE_GROUPS

Line 2067: FROM inl_ship_line_groups slg

2063: p_debug_info => l_debug_info);
2064:
2065: SELECT COUNT(1)
2066: INTO l_valid_ln_group
2067: FROM inl_ship_line_groups slg
2068: WHERE slg.ship_line_group_id = x_ship_line_group_id;
2069:
2070: INL_LOGGING_PVT.Log_Variable(
2071: p_module_name => g_module_name,

Line 2108: FROM inl_ship_line_groups slg

2104: p_debug_info => l_debug_info);
2105: BEGIN
2106: SELECT slg.ship_line_group_id
2107: INTO x_ship_line_group_id
2108: FROM inl_ship_line_groups slg
2109: WHERE slg.ship_header_id = p_ship_header_id
2110: AND slg.ship_line_group_num = x_ship_line_group_num;
2111: EXCEPTION
2112: WHEN OTHERS THEN

Line 2146: inl_ship_line_groups slg

2142: SELECT sl.ship_line_group_id, slg.ship_line_group_num
2143: INTO x_ship_line_group_id,
2144: x_ship_line_group_num
2145: FROM inl_ship_lines_all sl, --Bug#10381495
2146: inl_ship_line_groups slg
2147: WHERE sl.ship_header_id = p_ship_header_id
2148: AND sl.ship_line_id = p_ship_line_id
2149: AND sl.ship_line_group_id = slg.ship_line_group_id
2150: ;

Line 8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all

8096: -- Utility name : Delete_Ship
8097: -- Type : Private
8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount
8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,
8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
8101: -- If a Charge/Tax is associated with more than one Shipment, only the associations
8102: -- of the current shipment are going to be deleted
8103: -- Pre-reqs : None
8104: -- Parameters :

Line 8329: l_debug_info := 'Delete from inl_ship_line_groups';

8325: p_var_value => sql%rowcount
8326: );
8327:
8328: -- Table
8329: l_debug_info := 'Delete from inl_ship_line_groups';
8330: INL_LOGGING_PVT.Log_Statement(
8331: p_module_name => g_module_name,
8332: p_procedure_name => l_program_name,
8333: p_debug_info => l_debug_info) ;

Line 8335: DELETE FROM inl_ship_line_groups

8331: p_module_name => g_module_name,
8332: p_procedure_name => l_program_name,
8333: p_debug_info => l_debug_info) ;
8334:
8335: DELETE FROM inl_ship_line_groups
8336: WHERE ship_header_id = p_ship_header_id;
8337:
8338: INL_LOGGING_PVT.Log_Variable(
8339: p_module_name => g_module_name,

Line 8493: FROM inl_ship_line_groups

8489: current_SLnGr_rec.src_type_code, /* 05 */
8490: current_SLnGr_rec.party_id, /* 06 */
8491: current_SLnGr_rec.party_site_id, /* 07 */
8492: current_SLnGr_rec.source_organization_id /* 08 */
8493: FROM inl_ship_line_groups
8494: WHERE ship_header_id = x_ship_ln_int_rec.ship_header_id
8495: AND NVL(src_type_code, L_FND_MISS_CHAR) = NVL(x_ship_ln_int_rec.ship_line_src_type_code, L_FND_MISS_CHAR)
8496: AND party_id = x_ship_ln_int_rec.party_id
8497: AND party_site_id = x_ship_ln_int_rec.party_site_id

Line 8512: SELECT inl_ship_line_groups_s.NEXTVAL

8508:
8509: EXCEPTION
8510: WHEN NO_DATA_FOUND THEN
8511: -- Create a Line Group record
8512: SELECT inl_ship_line_groups_s.NEXTVAL
8513: INTO current_SLnGr_rec.ship_line_group_id
8514: FROM dual;
8515: SELECT MAX(ship_line_group_num)
8516: INTO current_SLnGr_rec.ship_line_group_num

Line 8517: FROM inl_ship_line_groups

8513: INTO current_SLnGr_rec.ship_line_group_id
8514: FROM dual;
8515: SELECT MAX(ship_line_group_num)
8516: INTO current_SLnGr_rec.ship_line_group_num
8517: FROM inl_ship_line_groups
8518: WHERE ship_header_id = x_ship_ln_int_rec.ship_header_id;
8519:
8520: x_ship_ln_int_rec.ship_line_group_id := current_SLnGr_rec.ship_line_group_id;
8521:

Line 8530: l_debug_info := 'Inserting inl_ship_line_groups';

8526: current_SLnGr_rec.party_id := x_ship_ln_int_rec.party_id;
8527: current_SLnGr_rec.party_site_id := x_ship_ln_int_rec.party_site_id;
8528: current_SLnGr_rec.source_organization_id := x_ship_ln_int_rec.source_organization_id;
8529:
8530: l_debug_info := 'Inserting inl_ship_line_groups';
8531: INL_LOGGING_PVT.Log_Statement(
8532: p_module_name => g_module_name,
8533: p_procedure_name => l_program_name,
8534: p_debug_info => l_debug_info) ;

Line 8540: INSERT INTO inl_ship_line_groups (

8536: p_module_name => g_module_name,
8537: p_procedure_name => l_program_name,
8538: p_var_name => 'current_SLnGr_rec.ship_line_group_id',
8539: p_var_value => current_SLnGr_rec.ship_line_group_id) ;
8540: INSERT INTO inl_ship_line_groups (
8541: ship_line_group_id, --01
8542: ship_line_group_reference, --02
8543: ship_header_id, --03
8544: ship_line_group_num, --04

Line 8636: UPDATE inl_ship_line_groups

8632: p_module_name => g_module_name,
8633: p_procedure_name => l_program_name,
8634: p_debug_info => l_debug_info) ;
8635:
8636: UPDATE inl_ship_line_groups
8637: SET
8638: ship_line_group_reference = NVL(x_ship_ln_int_rec.ship_line_group_reference,ship_line_group_reference),
8639: ship_line_int_id = NVL(x_ship_ln_int_rec.ship_line_int_id ,ship_line_int_id ),
8640: interface_source_table = NVL(x_ship_ln_int_rec.interface_source_table ,interface_source_table ),

Line 10031: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN

10027: SELECT ship_header_id
10028: INTO x_ship_header_id
10029: FROM inl_ship_lines_all --Bug#10381495
10030: WHERE ship_line_id = x_new_to_parent_table_id;
10031: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
10032: SELECT ship_header_id
10033: INTO x_ship_header_id
10034: FROM inl_ship_line_groups
10035: WHERE ship_line_group_id = x_new_to_parent_table_id;

Line 10034: FROM inl_ship_line_groups

10030: WHERE ship_line_id = x_new_to_parent_table_id;
10031: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
10032: SELECT ship_header_id
10033: INTO x_ship_header_id
10034: FROM inl_ship_line_groups
10035: WHERE ship_line_group_id = x_new_to_parent_table_id;
10036: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN
10037: l_ship_header_id_tab.DELETE;
10038: SELECT DISTINCT(a.ship_header_id) BULK COLLECT

Line 12539: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

12535: AND (
12536: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
12537: AND a.to_parent_table_id = sl.ship_header_id)
12538: OR
12539: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
12540: AND a.to_parent_table_id = sl.ship_line_group_id)
12541: OR
12542: (a.to_parent_table_name = 'INL_SHIP_LINES'
12543: AND a.to_parent_table_id = NVL(sl.parent_ship_line_id,sl.ship_line_id))

Line 12603: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

12599: AND (
12600: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
12601: AND a.to_parent_table_id = sl.ship_header_id)
12602: OR
12603: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
12604: AND a.to_parent_table_id = sl.ship_line_group_id)
12605: OR
12606: (a.to_parent_table_name = 'INL_SHIP_LINES'
12607: AND a.to_parent_table_id = NVL(sl.parent_ship_line_id,sl.ship_line_id))

Line 13178: 'INL_SHIP_LINE_GROUPS',

13174: ) ;
13175:
13176: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',
13177: 'INL_SHIP_LINES',
13178: 'INL_SHIP_LINE_GROUPS',
13179: 'INL_CHARGE_LINES',
13180: 'INL_TAX_LINES',
13181: 'RCV_TRANSACTIONS'
13182: )

Line 13212: ELSIF p_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN

13208: WHERE ship_line_id = p_to_parent_table_id;
13209: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
13210: l_matchTpCdOk := 'Y';
13211: END IF;
13212: ELSIF p_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
13213: l_INT_importedOk := 'Y';
13214: SELECT ship_header_id
13215: INTO l_ship_header_id
13216: FROM inl_ship_line_groups

Line 13216: FROM inl_ship_line_groups

13212: ELSIF p_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
13213: l_INT_importedOk := 'Y';
13214: SELECT ship_header_id
13215: INTO l_ship_header_id
13216: FROM inl_ship_line_groups
13217: WHERE ship_line_group_id = p_to_parent_table_id;
13218: IF p_match_type_code = 'CHARGE' THEN
13219: l_matchTpCdOk := 'Y';
13220: END IF;