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_SIMULATION_PVT dependencies on INL_SHIP_LINE_GROUPS

Line 797: FROM inl_ship_line_groups

793: p_procedure_name => l_api_name,
794: p_debug_info => 'Get Shipment Header Id');
795: SELECT ship_header_id
796: INTO l_ship_header_id
797: FROM inl_ship_line_groups
798: WHERE ship_line_group_id = p_new_ship_line_group_id;
799:
800: OPEN ShipLines;
801: FETCH ShipLines BULK COLLECT INTO ShipLines_List;

Line 1187: FROM inl_ship_line_groups

1183: attribute12,
1184: attribute13,
1185: attribute14,
1186: attribute15
1187: FROM inl_ship_line_groups
1188: WHERE ship_header_id = p_current_ship_header_id;
1189:
1190: TYPE LineGroups_List_Type IS
1191: TABLE OF LineGroups%ROWTYPE;

Line 1244: SELECT inl_ship_line_groups_s.NEXTVAL

1240: p_procedure_name => l_api_name,
1241: p_debug_info => 'Get the next Line Group Id');
1242:
1243: -- Get Shipment Header's nextval
1244: SELECT inl_ship_line_groups_s.NEXTVAL
1245: INTO l_ship_line_group_id
1246: FROM dual;
1247:
1248: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1250: p_debug_info => 'Insert into INL_SHIP_LINE_GROUPS');

1246: FROM dual;
1247:
1248: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1249: p_procedure_name => l_api_name,
1250: p_debug_info => 'Insert into INL_SHIP_LINE_GROUPS');
1251:
1252: INSERT INTO inl_ship_line_groups (ship_line_group_id,
1253: ship_line_group_reference,
1254: ship_header_id,

Line 1252: INSERT INTO inl_ship_line_groups (ship_line_group_id,

1248: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1249: p_procedure_name => l_api_name,
1250: p_debug_info => 'Insert into INL_SHIP_LINE_GROUPS');
1251:
1252: INSERT INTO inl_ship_line_groups (ship_line_group_id,
1253: ship_line_group_reference,
1254: ship_header_id,
1255: ship_line_group_num,
1256: src_type_code,

Line 1334: WHERE to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

1330: SELECT from_parent_table_name,
1331: from_parent_table_id
1332: BULK COLLECT INTO l_from_association_tbl
1333: FROM inl_associations
1334: WHERE to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
1335: AND to_parent_table_id = LineGroups_List(i).ship_line_group_id
1336: AND ship_header_id = p_current_ship_header_id;
1337: EXCEPTION
1338: WHEN NO_DATA_FOUND THEN

Line 1364: p_to_parent_table_name => 'INL_SHIP_LINE_GROUPS',

1360: p_commit => l_commit,
1361: p_current_ship_header_id => p_current_ship_header_id,
1362: p_new_ship_header_id => p_new_ship_header_id,
1363: p_from_parent_table_id => l_from_association_tbl(j).from_parent_table_id,
1364: p_to_parent_table_name => 'INL_SHIP_LINE_GROUPS',
1365: p_current_to_parent_table_id => LineGroups_List(i).ship_line_group_id,
1366: p_new_to_parent_table_id => l_ship_line_group_id,
1367: x_return_status => l_return_status,
1368: x_msg_count => l_msg_count,