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,
142: if (c_action_type IN ('C', 'S')) then
143: --
144: -- Costing or Retrocosting : event class COSTS
145: --
146: hr_utility.set_location('pytrgl.trans_ass_costs',20);
147: --
148: SELECT pa2.assignment_action_id,
149: ppa2.payroll_action_id,
150: ppa2.action_type,
229: elsif (c_action_type = 'EC') then
230: --
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
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;
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: --
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
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;
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);
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: --
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;
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
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
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
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: --
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
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(*)
658:
659: --
660: -- SLA has processed the event and passed to GL
661: --
662: hr_utility.set_message (801, 'HR_7507_ACTION_UNDO_INTLOCK');
663: hr_utility.raise_error;
664:
665: ELSE
666:
659: --
660: -- SLA has processed the event and passed to GL
661: --
662: hr_utility.set_message (801, 'HR_7507_ACTION_UNDO_INTLOCK');
663: hr_utility.raise_error;
664:
665: ELSE
666:
667: SELECT pap.gl_set_of_books_id
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;