APPS.CHV_BUILD_REVISION dependencies on CHV_SCHEDULE_HEADERS

Line 64: FROM chv_schedule_headers csh

60: mps_schedule_designator,
61: mrp_compile_designator,
62: drp_compile_designator,
63: include_future_releases_flag
64: FROM chv_schedule_headers csh
65: WHERE schedule_id = p_schedule_id;
66:
67: BEGIN
68:

Line 121: -- Insert a new row into CHV_SCHEDULE_HEADERS.

117: x_vendor_site_id,
118: x_schedule_num,
119: x_schedule_revision);
120:
121: -- Insert a new row into CHV_SCHEDULE_HEADERS.
122: -- Before that, get a new unique schedule header ID.
123: -- Any error will be caught at the exception at the end of the procedure.
124: x_progress := '050';
125: SELECT chv_schedule_headers_s.NEXTVAL

Line 125: SELECT chv_schedule_headers_s.NEXTVAL

121: -- Insert a new row into CHV_SCHEDULE_HEADERS.
122: -- Before that, get a new unique schedule header ID.
123: -- Any error will be caught at the exception at the end of the procedure.
124: x_progress := '050';
125: SELECT chv_schedule_headers_s.NEXTVAL
126: INTO x_schedule_id
127: FROM DUAL;
128:
129: x_progress := '060';

Line 130: INSERT INTO chv_schedule_headers(schedule_id,

126: INTO x_schedule_id
127: FROM DUAL;
128:
129: x_progress := '060';
130: INSERT INTO chv_schedule_headers(schedule_id,
131: vendor_id,
132: vendor_site_id,
133: schedule_type,
134: schedule_subtype,