APPS.OTA_INITIALIZATION_WF dependencies on HR_WORKFLOW_ITEM_KEY_S

Line 764: select hr_workflow_item_key_s.nextval

760:
761: if p_event_fired = 'INSTRUCTOR_CANCEL' then
762:
763: -- Get the next item key from the sequence
764: select hr_workflow_item_key_s.nextval
765: into l_item_key
766: from sys.dual;
767:
768:

Line 820: select hr_workflow_item_key_s.nextval

816: open get_resource_info;
817: fetch get_resource_info into resource_rec;
818: if get_resource_info%FOUND then
819: -- Get the next item key from the sequence
820: select hr_workflow_item_key_s.nextval
821: into l_item_key
822: from sys.dual;
823:
824: hr_utility.trace ('Before Createprocess ' ||resource_rec.trainer_id );

Line 868: select hr_workflow_item_key_s.nextval

864: for rec in get_all_resources_info
865: Loop
866:
867: -- Get the next item key from the sequence
868: select hr_workflow_item_key_s.nextval
869: into l_item_key
870: from sys.dual;
871:
872: hr_utility.trace ('Before Createprocess ' ||rec.trainer_id);

Line 1009: select hr_workflow_item_key_s.nextval

1005:
1006: if p_event_fired = 'CLASS_CANCEL' then
1007:
1008: -- Get the next item key from the sequence
1009: select hr_workflow_item_key_s.nextval
1010: into l_item_key
1011: from sys.dual;
1012: -- get item key for the process
1013: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

Line 1055: select hr_workflow_item_key_s.nextval

1051: for rec in get_booking_info
1052: Loop
1053:
1054: -- Get the next item key from the sequence
1055: select hr_workflow_item_key_s.nextval
1056: into l_item_key
1057: from sys.dual;
1058: -- get item key for the process
1059: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

Line 1244: select hr_workflow_item_key_s.nextval

1240: fetch get_lp_info into l_LP_name,l_person_id,l_start_date;
1241: close get_lp_info;
1242:
1243: -- Get the next item key from the sequence
1244: select hr_workflow_item_key_s.nextval
1245: into l_item_key
1246: from sys.dual;
1247: -- get item key for the process
1248: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

Line 1534: select hr_workflow_item_key_s.nextval

1530:
1531: hr_utility.trace ('title ' ||l_title);
1532:
1533: -- Get the next item key from the sequence
1534: select hr_workflow_item_key_s.nextval
1535: into l_item_key
1536: from sys.dual;
1537: -- get item key for the process
1538: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

Line 1613: select hr_workflow_item_key_s.nextval

1609: l_end_date_comments := '';
1610: end if;
1611:
1612: -- Get the next item key from the sequence
1613: select hr_workflow_item_key_s.nextval
1614: into l_item_key
1615: from sys.dual;
1616:
1617: -- get item key for the process

Line 1861: select hr_workflow_item_key_s.nextval

1857:
1858: Loop
1859:
1860: -- Get the next item key from the sequence
1861: select hr_workflow_item_key_s.nextval
1862: into l_item_key
1863: from sys.dual;
1864: -- get item key for the process
1865: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);

Line 1950: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;

1946: open csr_booking_status;
1947: fetch csr_booking_status into l_status_type,l_person_id, l_contact_id,l_event_id;
1948: close csr_booking_status;
1949:
1950: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
1951:
1952: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1953: set_wf_item_attr(p_person_id => l_person_id, p_item_type => l_item_type, p_item_key => l_item_key);
1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);

Line 2111: select hr_workflow_item_key_s.nextval

2107: for rec in get_booking_info
2108: Loop
2109:
2110: -- Get the next item key from the sequence
2111: select hr_workflow_item_key_s.nextval
2112: into l_item_key
2113: from sys.dual;
2114:
2115: -- get location

Line 2218: select hr_workflow_item_key_s.nextval

2214: for rec in get_booking_info
2215: Loop
2216:
2217: -- Get the next item key from the sequence
2218: select hr_workflow_item_key_s.nextval
2219: into l_item_key
2220: from sys.dual;
2221:
2222: -- get location