eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_WF_PKG dependencies on DUAL

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

176: --hr_utility.trace_on(null,'PYWF');
177: gv_package := 'pay_wf_pkg';
178: l_RequestorUsername := 'SYSADMIN';
179:
180: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
181:
182: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
183: retcode := 0;
184:

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

430: --hr_utility.trace_on(null,'PYWF');
431: gv_package := 'pay_wf_pkg';
432: l_RequestorUsername := 'SYSADMIN';
433:
434: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
435:
436: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
437: retcode := 0;
438:

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

885: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
886: hr_utility.trace('WF process name is : '|| Workflowprocess);
887:
888: begin
889: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
890: end;
891:
892: hr_utility.trace('b4 create_process');
893:

Line 1294: from dual;

1290: Begin
1291: /*
1292: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
1293: into l_profile_per_sec_id
1294: from dual;
1295: */
1296: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1297: into l_profile_per_sec_id
1298: from dual;

Line 1298: from dual;

1294: from dual;
1295: */
1296: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1297: into l_profile_per_sec_id
1298: from dual;
1299: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1300: into l_profile_per_bg
1301: from dual;
1302: /*

Line 1301: from dual;

1297: into l_profile_per_sec_id
1298: from dual;
1299: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1300: into l_profile_per_bg
1301: from dual;
1302: /*
1303: select fnd_profile_server.value('SECURITY_GROUP_ID')
1304: into l_profile_sec_grp_id
1305: from dual;

Line 1305: from dual;

1301: from dual;
1302: /*
1303: select fnd_profile_server.value('SECURITY_GROUP_ID')
1304: into l_profile_sec_grp_id
1305: from dual;
1306: */
1307:
1308: /* Bug 9211154 - There is no profile 'SECURITY_GROUP_ID' and hence below query will always return NULL'
1309: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))

Line 1311: from dual;

1307:
1308: /* Bug 9211154 - There is no profile 'SECURITY_GROUP_ID' and hence below query will always return NULL'
1309: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
1310: into l_profile_sec_grp_id
1311: from dual;
1312: */
1313: --Bug 9211154 Setting the value as fnd security group id
1314: l_profile_sec_grp_id := l_sec_grp_id;
1315:

Line 1318: from dual;

1314: l_profile_sec_grp_id := l_sec_grp_id;
1315:
1316: select fnd_profile_server.value('USERNAME')
1317: into l_profile_user_name
1318: from dual;
1319:
1320: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
1321: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
1322: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);

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

2608: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
2609: hr_utility.trace('WF process name is : '|| Workflowprocess);
2610:
2611: begin
2612: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS') into lv_date_time from dual;
2613: end;
2614:
2615: hr_utility.trace('b4 create_process');
2616:

Line 3024: from dual;

3020: Begin
3021: /*
3022: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
3023: into l_profile_per_sec_id
3024: from dual;
3025: */
3026: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
3027: into l_profile_per_sec_id
3028: from dual;

Line 3028: from dual;

3024: from dual;
3025: */
3026: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
3027: into l_profile_per_sec_id
3028: from dual;
3029: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
3030: into l_profile_per_bg
3031: from dual;
3032: /*

Line 3031: from dual;

3027: into l_profile_per_sec_id
3028: from dual;
3029: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
3030: into l_profile_per_bg
3031: from dual;
3032: /*
3033: select fnd_profile_server.value('SECURITY_GROUP_ID')
3034: into l_profile_sec_grp_id
3035: from dual;

Line 3035: from dual;

3031: from dual;
3032: /*
3033: select fnd_profile_server.value('SECURITY_GROUP_ID')
3034: into l_profile_sec_grp_id
3035: from dual;
3036: */
3037:
3038: /* Bug 9211154 - There is no profile 'SECURITY_GROUP_ID' and hence below query will always return NULL'
3039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))

Line 3041: from dual;

3037:
3038: /* Bug 9211154 - There is no profile 'SECURITY_GROUP_ID' and hence below query will always return NULL'
3039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
3040: into l_profile_sec_grp_id
3041: from dual;
3042: */
3043: --Bug 9211154 Setting the value as fnd security group id
3044: l_profile_sec_grp_id := l_sec_grp_id;
3045:

Line 3048: from dual;

3044: l_profile_sec_grp_id := l_sec_grp_id;
3045:
3046: select fnd_profile_server.value('USERNAME')
3047: into l_profile_user_name
3048: from dual;
3049:
3050: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
3051: hr_utility.trace('jj payuswfpkg l_profile_per_bg = '||l_profile_per_bg);
3052: hr_utility.trace('jj payuswfpkg l_profile_sec_grp_id = '||l_profile_sec_grp_id);