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 1532: select hr_workflow_item_key_s.nextval

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

Line 1611: select hr_workflow_item_key_s.nextval

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

Line 1857: select hr_workflow_item_key_s.nextval

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

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

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

Line 2106: select hr_workflow_item_key_s.nextval

2102: for rec in get_booking_info
2103: Loop
2104:
2105: -- Get the next item key from the sequence
2106: select hr_workflow_item_key_s.nextval
2107: into l_item_key
2108: from sys.dual;
2109:
2110: -- get location

Line 2213: select hr_workflow_item_key_s.nextval

2209: for rec in get_booking_info
2210: Loop
2211:
2212: -- Get the next item key from the sequence
2213: select hr_workflow_item_key_s.nextval
2214: into l_item_key
2215: from sys.dual;
2216:
2217: -- get location