DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on DUAL

Line 13744: FROM dual;

13740: LOOP
13741: -- fetch the CHANGE_LIFECYCLE_STATUS_ID from sequence
13742: SELECT ENG_LIFECYCLE_STATUSES_S.NEXTVAL
13743: INTO l_lifecycle_status_id
13744: FROM dual;
13745:
13746: -- Insert the Statuses data
13747: INSERT INTO ENG_LIFECYCLE_STATUSES
13748: ( CHANGE_LIFECYCLE_STATUS_ID

Line 13927: SELECT eng_change_lines_s.nextval INTO l_change_line_unexp_rec.change_line_id FROM SYS.DUAL;

13923:
13924: FOR change_line IN c_change_tasks(p_change_type_id, p_organization_id)
13925: LOOP
13926:
13927: SELECT eng_change_lines_s.nextval INTO l_change_line_unexp_rec.change_line_id FROM SYS.DUAL;
13928: l_change_line_unexp_rec.change_id := p_change_id;
13929: l_change_line_unexp_rec.change_type_id := -1;
13930: l_change_line_rec.sequence_number := change_line.sequence_number;
13931: l_change_line_rec.name := change_line.task_name;

Line 14013: from dual;

14009: begin
14010:
14011: select ENG_CHANGE_OBJ_RELATIONSHIPS_S.nextval
14012: into l_new_prop_relation
14013: from dual;
14014:
14015: insert into eng_change_obj_relationships (
14016: CHANGE_RELATIONSHIP_ID,
14017: CHANGE_ID,