DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_CURRENT_SCHEDULED_DATES

Line 84: delete from ENG_CURRENT_SCHEDULED_DATES

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

Line 253: select ENG_CURRENT_SCHEDULED_DATES_S.nextval

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

Line 256: insert into ENG_CURRENT_SCHEDULED_DATES (

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