DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_CURRENT_SCHEDULED_DATES

Line 33: DELETE FROM ENG_CURRENT_SCHEDULED_DATES

29: and revised_item_sequence_Id = p_revised_item_sequence_id
30: and change_notice = p_change_notice
31: and implementation_date is null;
32:
33: DELETE FROM ENG_CURRENT_SCHEDULED_DATES
34: where organization_id = p_organization_id
35: and revised_item_id = p_revised_item_id
36: and revised_item_sequence_Id = p_revised_item_sequence_id
37: and change_notice = p_change_notice ;

Line 551: select ENG_CURRENT_SCHEDULED_DATES_S.nextval

547: x_comments VARCHAR2) -- Bug 3589974
548: IS
549: x_schedule_id NUMBER;
550: BEGIN
551: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
552: into x_schedule_id
553: from sys.dual;
554: insert into ENG_CURRENT_SCHEDULED_DATES (
555: change_notice,

Line 554: insert into ENG_CURRENT_SCHEDULED_DATES (

550: BEGIN
551: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
552: into x_schedule_id
553: from sys.dual;
554: insert into ENG_CURRENT_SCHEDULED_DATES (
555: change_notice,
556: organization_id,
557: revised_item_id,
558: scheduled_date,