APPS.CS_SPLIT_REPAIRS dependencies on CS_REPAIR_HISTORY

Line 58: INSERT INTO cs_repair_history

54: UPDATE cs_repairs
55: SET quantity_received = 1
56: where repair_line_id = X_repair_line_id;
57:
58: INSERT INTO cs_repair_history
59: (
60: REPAIR_LINE_ID,
61: LAST_UPDATE_DATE,
62: LAST_UPDATED_BY,

Line 120: ,cs_repair_history_s.nextval

116: ,NULL
117: ,NULL
118: ,NULL
119: ,NULL
120: ,cs_repair_history_s.nextval
121: );
122:
123: /* Insert the remaining (quantity - 1) lines using values from the */
124: /* original repair line. */

Line 275: INSERT INTO cs_repair_history

271: WHERE repair_line_id = X_repair_line_id;
272:
273: /* Insert history records for the new lines */
274:
275: INSERT INTO cs_repair_history
276: (
277: REPAIR_LINE_ID,
278: LAST_UPDATE_DATE,
279: LAST_UPDATED_BY,

Line 335: ,cs_repair_history_s.nextval

331: ,context
332: ,program_id
333: ,program_application_id
334: ,program_update_date
335: ,cs_repair_history_s.nextval
336: FROM cs_repair_history
337: WHERE repair_line_id = x_repair_line_id;
338:
339: END LOOP;

Line 336: FROM cs_repair_history

332: ,program_id
333: ,program_application_id
334: ,program_update_date
335: ,cs_repair_history_s.nextval
336: FROM cs_repair_history
337: WHERE repair_line_id = x_repair_line_id;
338:
339: END LOOP;
340:

Line 353: INSERT INTO cs_repair_history

349: UPDATE cs_repairs
350: SET quantity_received = x_first_quantity
351: where repair_line_id = X_repair_line_id;
352:
353: INSERT INTO cs_repair_history
354: (
355: REPAIR_LINE_ID,
356: LAST_UPDATE_DATE,
357: LAST_UPDATED_BY,

Line 415: ,cs_repair_history_s.nextval

411: ,NULL
412: ,NULL
413: ,NULL
414: ,NULL
415: ,cs_repair_history_s.nextval
416: );
417:
418: /* Insert a repair line with the total_quantity - first_quantity */
419:

Line 570: INSERT INTO cs_repair_history

566: WHERE repair_line_id = X_repair_line_id;
567:
568: /* Insert history records for the new line */
569:
570: INSERT INTO cs_repair_history
571: (
572: REPAIR_LINE_ID,
573: LAST_UPDATE_DATE,
574: LAST_UPDATED_BY,

Line 630: ,cs_repair_history_s.nextval

626: ,context
627: ,program_id
628: ,program_application_id
629: ,program_update_date
630: ,cs_repair_history_s.nextval
631: FROM cs_repair_history
632: WHERE repair_line_id = x_repair_line_id;
633:
634: END IF;

Line 631: FROM cs_repair_history

627: ,program_id
628: ,program_application_id
629: ,program_update_date
630: ,cs_repair_history_s.nextval
631: FROM cs_repair_history
632: WHERE repair_line_id = x_repair_line_id;
633:
634: END IF;
635: