APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_CURRENT_SCHEDULED_DATES

Line 86: delete from ENG_CURRENT_SCHEDULED_DATES

82: and implementation_date is null;
83:
84:
85:
86: delete from ENG_CURRENT_SCHEDULED_DATES
87: where organization_id = x_organization_id
88: and revised_item_id = x_revised_item_id
89: and revised_item_sequence_id = x_revised_item_sequence_id
90: and change_notice = x_change_notice;

Line 255: select ENG_CURRENT_SCHEDULED_DATES_S.nextval

251: x_requestor_id NUMBER,
252: x_userid NUMBER) IS
253: x_schedule_id NUMBER;
254: BEGIN
255: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
256: into x_schedule_id
257: from sys.dual;
258: insert into ENG_CURRENT_SCHEDULED_DATES (
259: change_notice,

Line 258: insert into ENG_CURRENT_SCHEDULED_DATES (

254: BEGIN
255: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
256: into x_schedule_id
257: from sys.dual;
258: insert into ENG_CURRENT_SCHEDULED_DATES (
259: change_notice,
260: organization_id,
261: revised_item_id,
262: scheduled_date,