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_SLA_PKG dependencies on PAY_SLA_PKG

Line 1: PACKAGE BODY pay_sla_pkg AS

1: PACKAGE BODY pay_sla_pkg AS
2: /* $Header: pysla.pkb 120.13.12010000.2 2008/08/14 05:27:54 priupadh ship $ */
3: --
4: /*
5: * ***************************************************************************

Line 13: PAY_SLA_PKG - Payroll support for SLA (Sub Ledger Accounting)

9: PRODUCT
10: Oracle*Payroll
11: --
12: NAME
13: PAY_SLA_PKG - Payroll support for SLA (Sub Ledger Accounting)
14: --
15: --
16: DESCRIPTION
17: --

Line 107: hr_utility.set_location('pay_sla_pkg.trans_asg_costs',10);

103: l_event_source_info xla_events_pub_pkg.t_event_source_info;
104: l_security_context xla_events_pub_pkg.t_security;
105: BEGIN
106: --
107: hr_utility.set_location('pay_sla_pkg.trans_asg_costs',10);
108: --
109: SELECT pa.payroll_action_id,
110: pa1.assignment_id,
111: pa1.assignment_action_id,

Line 152: pay_sla_pkg.get_accounting_date

148: SELECT pa2.assignment_action_id,
149: ppa2.payroll_action_id,
150: ppa2.action_type,
151: pap.gl_set_of_books_id,
152: pay_sla_pkg.get_accounting_date
153: (ppa2.action_type, c_effective_date,
154: ppa2.effective_date, ppa2.date_earned)
155: INTO r_assignment_action_id,
156: r_payroll_action_id,

Line 235: SELECT pay_sla_pkg.get_ecost_accounting_date

231: -- Estimate Costing : event class ESTIMATE_COSTS
232: --
233: hr_utility.set_location('pytrgl.trans_ass_costs',30);
234: --
235: SELECT pay_sla_pkg.get_ecost_accounting_date
236: (pera.payroll_id, c_effective_date),
237: pap.gl_set_of_books_id
238: INTO l_rev_accounting_date,
239: l_ledger_id

Line 375: hr_utility.set_location('pay_sla_pkg.post_process_event',10);

371: AND PAYE.event_status <> 'C';
372:
373: BEGIN
374: --
375: hr_utility.set_location('pay_sla_pkg.post_process_event',10);
376: --
377: IF (p_application_id <> 801) THEN
378: RETURN;
379: END IF;

Line 390: hr_utility.set_location('pay_sla_pkg.post_process_event',10);

386: END IF;
387: --
388: for xlarec in xla_events_cur loop
389: --
390: hr_utility.set_location('pay_sla_pkg.post_process_event',10);
391: --
392: --
393: -- Mark the Events as complete
394: --

Line 417: hr_utility.set_location('Entering pay_sla_pkg.get_conversion_type',10);

413: l_user_currency_type VARCHAR2(30);
414: l_currency_type VARCHAR2(30);
415: BEGIN
416: --
417: hr_utility.set_location('Entering pay_sla_pkg.get_conversion_type',10);
418: --
419: if (g_business_group_id is not null) and
420: (i_business_group_id = g_business_group_id) and
421: (i_conversion_date = g_conversion_date) then

Line 431: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_user_currency_type '||l_user_currency_type,15);

427: l_user_currency_type := hruserdt.get_table_value(i_business_group_id,
428: 'EXCHANGE_RATE_TYPES', 'Conversion Rate Type',
429: 'PAY',i_conversion_date);
430:
431: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_user_currency_type '||l_user_currency_type,15);
432: /*Begin Bug 7283055 USER_CONVERSION_TYPE was getting returned need to return Conversion Type */
433: open get_conv_type(l_user_currency_type);
434: fetch get_conv_type into l_currency_type;
435: close get_conv_type;

Line 442: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);

438: g_business_group_id := i_business_group_id;
439: g_conversion_date := i_conversion_date;
440: --
441: end if;
442: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);
443: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);
444: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);
445: --
446: return(l_currency_type);

Line 443: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);

439: g_conversion_date := i_conversion_date;
440: --
441: end if;
442: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);
443: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);
444: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);
445: --
446: return(l_currency_type);
447: --

Line 444: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);

440: --
441: end if;
442: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);
443: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);
444: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);
445: --
446: return(l_currency_type);
447: --
448: END get_conversion_type;

Line 459: hr_utility.set_location('pay_sla_pkg.get_accounting_date',10);

455: RETURN DATE IS
456: l_accounting_date DATE;
457: BEGIN
458: --
459: hr_utility.set_location('pay_sla_pkg.get_accounting_date',10);
460: --
461: if (run_action_type in ('B', 'V')) then
462: --
463: -- For Reversals and Balance Adjustments

Line 520: hr_utility.set_location('pay_sla_pkg.get_ecost_accounting_date',10);

516: RETURN DATE IS
517: l_accounting_date DATE;
518: BEGIN
519: --
520: hr_utility.set_location('pay_sla_pkg.get_ecost_accounting_date',10);
521: --
522: --
523: -- For Estimate Costs
524: -- negation deltas at end of payroll period only

Line 589: hr_utility.set_location('pay_sla_pkg.preaccounting',10);

585: p_report_request_id NUMBER)
586: IS
587: BEGIN
588: --
589: hr_utility.set_location('pay_sla_pkg.preaccounting',10);
590: --
591: END preaccounting;
592: --
593: -- Stub for XLA postaccounting hook

Line 612: hr_utility.set_location('pay_sla_pkg.postaccounting',10);

608: p_report_request_id NUMBER)
609: IS
610: BEGIN
611: --
612: hr_utility.set_location('pay_sla_pkg.postaccounting',10);
613: --
614: END postaccounting;
615: --
616: --

Line 625: hr_utility.set_location('pay_sla_pkg.extract',10);

621: p_accounting_mode VARCHAR2)
622: IS
623: BEGIN
624: --
625: hr_utility.set_location('pay_sla_pkg.extract',10);
626: --
627: END extract;
628: --
629: -- Delet_event : called form rollback code

Line 647: hr_utility.set_location('pay_sla_pkg.delete_event',10);

643: l_security_context xla_events_pub_pkg.t_security;
644:
645: BEGIN
646: --
647: hr_utility.set_location('pay_sla_pkg.delete_event',10);
648: --
649: -- Confirm no Completed events for this action
650: --
651: SELECT count(*)

Line 775: hr_utility.set_location('pay_sla_pkg.create_custom_adrs',10);

771: l_rule_det_seq xla_rule_details_t.user_sequence%type;
772: --
773: BEGIN
774: --
775: hr_utility.set_location('pay_sla_pkg.create_custom_adrs',10);
776: --
777: for segmap in segmaps loop
778:
779: l_acc_segment := segmap.gl_account_segment;

Line 924: END pay_sla_pkg;

920: xla_adr_interface_pkg.upload_rules;
921: --
922: END create_custom_adrs;
923: --
924: END pay_sla_pkg;