APPS.OTA_INITIALIZATION_WF dependencies on DUAL

Line 237: FROM dual;

233: CLOSE c_people;
234: hr_utility.set_location('Entering:'||l_proc, 17);
235: SELECT to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS')
236: INTO l_wf_date
237: FROM dual;
238: --Bug#2587983 get line number
239: OPEN C_ORDER_LINE;
240: FETCH C_ORDER_LINE into l_line_number;
241: CLOSE C_ORDER_LINE;

Line 766: from sys.dual;

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:
769: -- get item key for the process
770: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

Line 822: from sys.dual;

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 );
825: -- get item key for the process
826: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

Line 870: from sys.dual;

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);
873: -- get item key for the process
874: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);

Line 1011: from sys.dual;

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);
1014:
1015: -- set creator,current and supervisor name

Line 1057: from sys.dual;

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);
1060:
1061: -- set creator,current and supervisor name

Line 1246: from sys.dual;

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);
1249:
1250: -- set creator,current and supervisor name

Line 1536: from sys.dual;

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);
1539: hr_utility.trace ('item key ' ||l_item_key);
1540: -- set creator,current and supervisor name

Line 1615: from sys.dual;

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
1618: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
1619:

Line 1863: from sys.dual;

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);
1866:
1867: -- set creator,current and supervisor name

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 2113: from sys.dual;

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
2116: l_location_name := ota_general.get_Location_code(l_location_id);
2117:

Line 2220: from sys.dual;

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
2223: l_location_name := ota_general.get_Location_code(l_location_id);
2224: