1177: IS
1178:
1179: Cursor line_ship_set IS
1180: Select line_id,ato_line_id,item_type_code
1181: From oe_order_lines_all
1182: Where ship_set_id = p_ship_set_id;
1183:
1184: Cursor line_arrival_set IS
1185: Select line_id,ato_line_id,item_type_code
1182: Where ship_set_id = p_ship_set_id;
1183:
1184: Cursor line_arrival_set IS
1185: Select line_id,ato_line_id,item_type_code
1186: From oe_order_lines_all
1187: Where arrival_set_id = p_arrival_set_id;
1188:
1189: Cursor line_smc IS
1190: Select line_id,ato_line_id,item_type_code
1187: Where arrival_set_id = p_arrival_set_id;
1188:
1189: Cursor line_smc IS
1190: Select line_id,ato_line_id,item_type_code
1191: From oe_order_lines_all
1192: Where top_model_line_id = p_top_model_line_id;
1193:
1194: l_result Boolean := TRUE;
1195: l_index Number;