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_KR_WF_SUBMIT_PROGRAM_PKG dependencies on WF_ENGINE

Line 71: if wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') = 'PAYKRSOE'

67: if g_debug then
68: hr_utility.trace('Into submit_program.') ;
69: end if ;
70: --
71: if wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') = 'PAYKRSOE'
72: and wf_engine.getItemAttrText(itemtype, itemkey, 'TO_RUN_PREPAYMENTS') = 'Y'
73: and wf_engine.getItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID') is null
74: then
75: --

Line 72: and wf_engine.getItemAttrText(itemtype, itemkey, 'TO_RUN_PREPAYMENTS') = 'Y'

68: hr_utility.trace('Into submit_program.') ;
69: end if ;
70: --
71: if wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') = 'PAYKRSOE'
72: and wf_engine.getItemAttrText(itemtype, itemkey, 'TO_RUN_PREPAYMENTS') = 'Y'
73: and wf_engine.getItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID') is null
74: then
75: --
76: if g_debug then

Line 73: and wf_engine.getItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID') is null

69: end if ;
70: --
71: if wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') = 'PAYKRSOE'
72: and wf_engine.getItemAttrText(itemtype, itemkey, 'TO_RUN_PREPAYMENTS') = 'Y'
73: and wf_engine.getItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID') is null
74: then
75: --
76: if g_debug then
77: hr_utility.trace('Getting payroll action id from PrePayments to run Payslip (Korea)');

Line 82: l_prepayments_req_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PREPAYMENTS_REQ_ID_NUM');

78: end if ;
79: --
80: -- Get payroll action id from PrePayments to run Payslip (Korea)
81: --
82: l_prepayments_req_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PREPAYMENTS_REQ_ID_NUM');
83: -- Bug 4859652
84: l_business_group_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'BUSINESS_GROUP_NUMBER') ;
85: l_payroll_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PAYROLL_ID') ;
86: -- End of 4859652

Line 84: l_business_group_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'BUSINESS_GROUP_NUMBER') ;

80: -- Get payroll action id from PrePayments to run Payslip (Korea)
81: --
82: l_prepayments_req_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PREPAYMENTS_REQ_ID_NUM');
83: -- Bug 4859652
84: l_business_group_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'BUSINESS_GROUP_NUMBER') ;
85: l_payroll_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PAYROLL_ID') ;
86: -- End of 4859652
87: --
88: if g_debug then

Line 85: l_payroll_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PAYROLL_ID') ;

81: --
82: l_prepayments_req_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PREPAYMENTS_REQ_ID_NUM');
83: -- Bug 4859652
84: l_business_group_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'BUSINESS_GROUP_NUMBER') ;
85: l_payroll_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PAYROLL_ID') ;
86: -- End of 4859652
87: --
88: if g_debug then
89: hr_utility.trace('Got PrePayments request id = ' || l_prepayments_req_id );

Line 104: wf_engine.setItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID', to_char(rec.payroll_action_id));

100: end if ;
101: --
102: -- set the payroll action id as the run type period in workflow
103: --
104: wf_engine.setItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID', to_char(rec.payroll_action_id));
105: --
106: for rec1 in csr_run_type_period_name(rec.payroll_action_id) loop
107: wf_engine.setItemAttrText(itemtype, itemkey, 'RUN_TYPE_PERIOD_NAME_DISP', rec1.run_type_period_name);
108: end loop;

Line 107: wf_engine.setItemAttrText(itemtype, itemkey, 'RUN_TYPE_PERIOD_NAME_DISP', rec1.run_type_period_name);

103: --
104: wf_engine.setItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID', to_char(rec.payroll_action_id));
105: --
106: for rec1 in csr_run_type_period_name(rec.payroll_action_id) loop
107: wf_engine.setItemAttrText(itemtype, itemkey, 'RUN_TYPE_PERIOD_NAME_DISP', rec1.run_type_period_name);
108: end loop;
109: end loop ;
110: --
111: end if ;

Line 114: hr_utility.trace('Now calling fnd_wf_standard.executeconcprogram for program ' || wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') ) ;

110: --
111: end if ;
112: --
113: if g_debug then
114: hr_utility.trace('Now calling fnd_wf_standard.executeconcprogram for program ' || wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') ) ;
115: end if ;
116: --
117: fnd_wf_standard.executeconcprogram(itemtype, itemkey, actid, funcmode, resultout) ;
118: --

Line 226: if wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRMTH' then -- we're running monthly

222: * Get the request ids if we are running the monthly or bonus payroll processes, and
223: * use the request ids to get the number of assignments processed
224: */
225: lb_to_get_counts := false ; -- initialize to false
226: if wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRMTH' then -- we're running monthly
227: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'MONTHLY_PAYROLL_REQ_ID_NUM');
228: --
229: if g_debug then
230: hr_utility.trace('Got Monthly Payroll request id = ' || ln_req_id );

Line 227: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'MONTHLY_PAYROLL_REQ_ID_NUM');

223: * use the request ids to get the number of assignments processed
224: */
225: lb_to_get_counts := false ; -- initialize to false
226: if wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRMTH' then -- we're running monthly
227: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'MONTHLY_PAYROLL_REQ_ID_NUM');
228: --
229: if g_debug then
230: hr_utility.trace('Got Monthly Payroll request id = ' || ln_req_id );
231: end if ;

Line 234: elsif wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRBON' then -- we're running bonus

230: hr_utility.trace('Got Monthly Payroll request id = ' || ln_req_id );
231: end if ;
232: --
233: lb_to_get_counts := true ; -- will need to get assignment count information
234: elsif wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRBON' then -- we're running bonus
235: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'BONUS_PAYROLL_REQ_ID_NUM');
236: --
237: if g_debug then
238: hr_utility.trace('Got Bonus Payroll request id = ' || ln_req_id );

Line 235: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'BONUS_PAYROLL_REQ_ID_NUM');

231: end if ;
232: --
233: lb_to_get_counts := true ; -- will need to get assignment count information
234: elsif wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRBON' then -- we're running bonus
235: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'BONUS_PAYROLL_REQ_ID_NUM');
236: --
237: if g_debug then
238: hr_utility.trace('Got Bonus Payroll request id = ' || ln_req_id );
239: end if ;

Line 250: l_payroll_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'PAYROLL_ID') ; -- Bug 5042942

246: -- initialize counters
247: ln_complete := 0;
248: ln_error := 0;
249: ln_unprocessed := 0;
250: l_payroll_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'PAYROLL_ID') ; -- Bug 5042942
251: for asg_info_rec in asg_info_cur loop
252: if asg_info_rec.ASG_STATUS = 'C' then
253: ln_complete := asg_info_rec.ASG_COUNT;
254: elsif asg_info_rec.ASG_STATUS = 'E' then

Line 262: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'SUCCESSFULLY_PROCESSED_COUNT', ln_complete) ;

258: end if;
259: end loop ;
260:
261: -- set corresponding item attributes
262: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'SUCCESSFULLY_PROCESSED_COUNT', ln_complete) ;
263: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'ERRORED_PROCESSED_COUNT', ln_error) ;
264: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'UN_PROCESSED_COUNT', ln_unprocessed) ;
265: end if ;
266: --

Line 263: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'ERRORED_PROCESSED_COUNT', ln_error) ;

259: end loop ;
260:
261: -- set corresponding item attributes
262: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'SUCCESSFULLY_PROCESSED_COUNT', ln_complete) ;
263: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'ERRORED_PROCESSED_COUNT', ln_error) ;
264: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'UN_PROCESSED_COUNT', ln_unprocessed) ;
265: end if ;
266: --
267: p_result := 'COMPLETE' ;

Line 264: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'UN_PROCESSED_COUNT', ln_unprocessed) ;

260:
261: -- set corresponding item attributes
262: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'SUCCESSFULLY_PROCESSED_COUNT', ln_complete) ;
263: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'ERRORED_PROCESSED_COUNT', ln_error) ;
264: wf_engine.setItemAttrNumber(p_itemtype, p_itemkey, 'UN_PROCESSED_COUNT', ln_unprocessed) ;
265: end if ;
266: --
267: p_result := 'COMPLETE' ;
268: --