DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_CURRENT_SCHEDULED_DATES

Line 50: DELETE FROM ENG_CURRENT_SCHEDULED_DATES

46: and revised_item_sequence_Id = p_revised_item_sequence_id
47: and change_notice = p_change_notice
48: and implementation_date is null;
49:
50: DELETE FROM ENG_CURRENT_SCHEDULED_DATES
51: where organization_id = p_organization_id
52: and revised_item_id = p_revised_item_id
53: and revised_item_sequence_Id = p_revised_item_sequence_id
54: and change_notice = p_change_notice ;

Line 568: select ENG_CURRENT_SCHEDULED_DATES_S.nextval

564: x_comments VARCHAR2) -- Bug 3589974
565: IS
566: x_schedule_id NUMBER;
567: BEGIN
568: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
569: into x_schedule_id
570: from sys.dual;
571: insert into ENG_CURRENT_SCHEDULED_DATES (
572: change_notice,

Line 571: insert into ENG_CURRENT_SCHEDULED_DATES (

567: BEGIN
568: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
569: into x_schedule_id
570: from sys.dual;
571: insert into ENG_CURRENT_SCHEDULED_DATES (
572: change_notice,
573: organization_id,
574: revised_item_id,
575: scheduled_date,