APPS.PAY_WF_PKG dependencies on DUAL

Line 171: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

167: --hr_utility.trace_on(null,'PYWF');
168: gv_package := 'pay_wf_pkg';
169: l_RequestorUsername := 'SYSADMIN';
170:
171: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
172:
173: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
174: retcode := 0;
175:

Line 621: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;

617: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
618: hr_utility.trace('WF process name is : '|| Workflowprocess);
619:
620: begin
621: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
622: end;
623:
624: hr_utility.trace('b4 create_process');
625:

Line 1026: from dual;

1022: Begin
1023: /*
1024: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
1025: into l_profile_per_sec_id
1026: from dual;
1027: */
1028: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1029: into l_profile_per_sec_id
1030: from dual;

Line 1030: from dual;

1026: from dual;
1027: */
1028: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1029: into l_profile_per_sec_id
1030: from dual;
1031: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1032: into l_profile_per_bg
1033: from dual;
1034: /*

Line 1033: from dual;

1029: into l_profile_per_sec_id
1030: from dual;
1031: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1032: into l_profile_per_bg
1033: from dual;
1034: /*
1035: select fnd_profile_server.value('SECURITY_GROUP_ID')
1036: into l_profile_sec_grp_id
1037: from dual;

Line 1037: from dual;

1033: from dual;
1034: /*
1035: select fnd_profile_server.value('SECURITY_GROUP_ID')
1036: into l_profile_sec_grp_id
1037: from dual;
1038: */
1039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
1040: into l_profile_sec_grp_id
1041: from dual;

Line 1041: from dual;

1037: from dual;
1038: */
1039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
1040: into l_profile_sec_grp_id
1041: from dual;
1042:
1043: select fnd_profile_server.value('USERNAME')
1044: into l_profile_user_name
1045: from dual;

Line 1045: from dual;

1041: from dual;
1042:
1043: select fnd_profile_server.value('USERNAME')
1044: into l_profile_user_name
1045: from dual;
1046:
1047: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1048: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1049: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);