APPS.INL_INTERFACE_PVT dependencies on INL_SHIP_LINE_GROUPS_S

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