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

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

Line 1613: from sys.dual;

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

Line 1859: from sys.dual;

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

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

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

Line 2215: from sys.dual;

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