DBA Data[Home] [Help]

APPS.CS_SPLIT_REPAIRS dependencies on DUAL

Line 130: FROM dual;

126: FOR split_lines in 1..(X_total_quantity - 1) LOOP
127:
128: SELECT cs_repairs_s.nextval
129: INTO new_line_id
130: FROM dual;
131:
132: SELECT to_number(cs_repair_number_s.nextval)
133: INTO new_repair_number
134: FROM dual;

Line 134: FROM dual;

130: FROM dual;
131:
132: SELECT to_number(cs_repair_number_s.nextval)
133: INTO new_repair_number
134: FROM dual;
135: INSERT INTO cs_repairs
136: (
137: repair_line_id,
138: last_update_date,

Line 424: FROM dual;

420: /* dbms_output.put_line('New repair record'); */
421:
422: SELECT cs_repairs_s.nextval
423: INTO new_line_id
424: FROM dual;
425:
426: SELECT to_number(cs_repair_number_s.nextval)
427: INTO new_repair_number
428: FROM dual;

Line 428: FROM dual;

424: FROM dual;
425:
426: SELECT to_number(cs_repair_number_s.nextval)
427: INTO new_repair_number
428: FROM dual;
429:
430: INSERT INTO cs_repairs
431: (
432: repair_line_id,