APPS.CHV_BUILD_SCHEDULES dependencies on CHV_SCHEDULE_HEADERS_S

Line 546: SELECT chv_schedule_headers_s.NEXTVAL

542: -- Insert a new row into CHV_SCHEDULE_HEADERS.
543: -- Before that, get a new unique schedule header ID.
544: -- Any error will be caught at the exception at the end of the procedure.
545: x_progress := '050';
546: SELECT chv_schedule_headers_s.NEXTVAL
547: INTO x_schedule_id
548: FROM DUAL;
549:
550: ---- dbms_output.put_line('Schedule Header id'||x_schedule_id);

Line 568: INSERT INTO chv_schedule_headers(schedule_id,

564: ---- dbms_output.put_line('Build_schedule: user id'||x_user_id);
565: ---- dbms_output.put_line('Build_schedule: login id'||x_login_id);
566:
567: x_progress := '060';
568: INSERT INTO chv_schedule_headers(schedule_id,
569: vendor_id,
570: vendor_site_id,
571: schedule_type,
572: schedule_subtype,

Line 1248: SELECT chv_schedule_headers_s2.NEXTVAL

1244: -- Select the next largest number to be used for the next schedule
1245: -- generated today; Set the revision to 0 for a new schedule.
1246: x_progress := '010';
1247:
1248: SELECT chv_schedule_headers_s2.NEXTVAL
1249: INTO x_count_l
1250: FROM DUAL;
1251:
1252: x_schedule_num := TO_CHAR(SYSDATE, 'YYYYMMDD') || '-' ||