DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on DUAL

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

151: --hr_utility.trace_on(null,'PYWF');
152:
153: gv_package := 'pay_ca_wf_pkg';
154:
155: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
156:
157: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
158: retcode := 0;
159:

Line 785: into lv_date_time from dual;

781: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
782: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
783:
784: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
785: into lv_date_time from dual;
786:
787:
788: hr_utility.trace('before create_process');
789:

Line 1069: from dual;

1065:
1066: begin
1067: select to_char(sysdate, 'HHSSSS')
1068: into lv_exp_finder_pqp
1069: from dual;
1070:
1071: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
1072:
1073: exception when no_data_found then