DBA Data[Home] [Help]

APPS.PAY_SLA_PKG dependencies on XLA_EVENTS_PUB_PKG

Line 48: XLA_EVENTS_PUB_PKG.create_event, and

44: completed).
45: Also simplified Postprocessing.
46: Bug 5510388.
47: 120.7 A.Logue 15-Aug-2006 Correct entity_type_code passed to
48: XLA_EVENTS_PUB_PKG.create_event, and
49: initialise event_status in pay_xla_events.
50: 120.6 A.Logue 15-Jun-2006 Fix GSCC error.
51: 120.5 A.Logue 25-May-2006 Mark payroll action as complete if
52: all actions are complete in Postprocessing.

Line 110: l_event_source_info xla_events_pub_pkg.t_event_source_info;

106: l_accounting_date DATE;
107: l_rev_accounting_date DATE;
108: l_event_id NUMBER;
109: --
110: l_event_source_info xla_events_pub_pkg.t_event_source_info;
111: l_security_context xla_events_pub_pkg.t_security;
112: BEGIN
113: --
114: hr_utility.set_location('pay_sla_pkg.trans_asg_costs',10);

Line 111: l_security_context xla_events_pub_pkg.t_security;

107: l_rev_accounting_date DATE;
108: l_event_id NUMBER;
109: --
110: l_event_source_info xla_events_pub_pkg.t_event_source_info;
111: l_security_context xla_events_pub_pkg.t_security;
112: BEGIN
113: --
114: hr_utility.set_location('pay_sla_pkg.trans_asg_costs',10);
115: --

Line 145: -- Calls to XLA_EVENTS_PUB_PKG.create_event

141: l_event_source_info.transaction_number := to_char(i_assignment_action_id);
142: l_event_source_info.entity_type_code := 'ASSIGNMENTS';
143:
144: --
145: -- Calls to XLA_EVENTS_PUB_PKG.create_event
146: -- (or XLA_EVENTS_PUB_PKG.create_bulk_events)
147: --
148:
149: if (c_action_type IN ('C', 'S')) then

Line 146: -- (or XLA_EVENTS_PUB_PKG.create_bulk_events)

142: l_event_source_info.entity_type_code := 'ASSIGNMENTS';
143:
144: --
145: -- Calls to XLA_EVENTS_PUB_PKG.create_event
146: -- (or XLA_EVENTS_PUB_PKG.create_bulk_events)
147: --
148:
149: if (c_action_type IN ('C', 'S')) then
150: --

Line 193: l_event_id := XLA_EVENTS_PUB_PKG.create_event (

189: l_event_source_info.source_id_int_1 := i_assignment_action_id;
190: --l_event_source_info.source_id_date_1 := l_accounting_date;
191: l_event_source_info.source_id_char_1 := to_char(l_accounting_date, 'YYYY/MM/DD');
192:
193: l_event_id := XLA_EVENTS_PUB_PKG.create_event (
194: p_event_source_info => l_event_source_info,
195: p_event_type_code => 'COST',
196: p_event_date => l_accounting_date,
197: p_event_status_code => 'U',

Line 221: l_event_id := XLA_EVENTS_PUB_PKG.create_event (

217: -- For Retrocosting accounting date is taken as the effective date of retrocosting process
218: l_accounting_date := c_effective_date ;
219: l_event_source_info.source_id_char_1 := to_char(l_accounting_date, 'YYYY/MM/DD');
220:
221: l_event_id := XLA_EVENTS_PUB_PKG.create_event (
222: p_event_source_info => l_event_source_info,
223: p_event_type_code => 'RETRO_COST',
224: p_event_date => l_accounting_date,
225: p_event_status_code => 'U',

Line 270: l_event_id := XLA_EVENTS_PUB_PKG.create_event (

266: l_event_source_info.source_id_int_1 := i_assignment_action_id;
267: --l_event_source_info.source_id_date_1 := c_effective_date;
268: l_event_source_info.source_id_char_1 := to_char(c_effective_date, 'YYYY/MM/DD');
269:
270: l_event_id := XLA_EVENTS_PUB_PKG.create_event (
271: p_event_source_info => l_event_source_info,
272: p_event_type_code => 'ESTIMATE_COST',
273: p_event_date => c_effective_date,
274: p_event_status_code => 'U',

Line 295: l_event_id := XLA_EVENTS_PUB_PKG.create_event (

291: --l_event_source_info.source_id_date_1 := l_rev_accounting_date;
292: l_event_source_info.source_id_char_1 := to_char(l_rev_accounting_date,
293: 'YYYY/MM/DD');
294:
295: l_event_id := XLA_EVENTS_PUB_PKG.create_event (
296: p_event_source_info => l_event_source_info,
297: p_event_type_code => 'ESITMATE_COST_REVERSAL',
298: p_event_date => l_rev_accounting_date,
299: p_event_status_code => 'U',

Line 344: l_event_id := XLA_EVENTS_PUB_PKG.create_event (

340: --l_event_source_info.source_id_date_1 := account_date.accounting_date;
341: l_event_source_info.source_id_char_1 :=
342: to_char(account_date.accounting_date, 'YYYY/MM/DD');
343:
344: l_event_id := XLA_EVENTS_PUB_PKG.create_event (
345: p_event_source_info => l_event_source_info,
346: p_event_type_code => 'PAYMENT_COST',
347: p_event_date => account_date.accounting_date,
348: p_event_status_code => 'U',

Line 652: l_event_source_info xla_events_pub_pkg.t_event_source_info;

648: WHERE PAYE.assignment_action_id = i_assignment_action_id;
649:
650: l_completed_events number;
651: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
652: l_event_source_info xla_events_pub_pkg.t_event_source_info;
653: l_security_context xla_events_pub_pkg.t_security;
654:
655: BEGIN
656: --

Line 653: l_security_context xla_events_pub_pkg.t_security;

649:
650: l_completed_events number;
651: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;
652: l_event_source_info xla_events_pub_pkg.t_event_source_info;
653: l_security_context xla_events_pub_pkg.t_security;
654:
655: BEGIN
656: --
657: hr_utility.set_location('pay_sla_pkg.delete_event',10);

Line 734: hr_utility.trace('Before XLA_EVENTS_PUB_PKG.delete_event');

730:
731: l_event_source_info.source_id_char_1 := to_char(xlarec.accounting_date,
732: 'YYYY/MM/DD');
733:
734: hr_utility.trace('Before XLA_EVENTS_PUB_PKG.delete_event');
735: -- delete the event in SLA
736: XLA_EVENTS_PUB_PKG.delete_event (
737: p_event_source_info => l_event_source_info,
738: p_event_id => xlarec.event_id,

Line 736: XLA_EVENTS_PUB_PKG.delete_event (

732: 'YYYY/MM/DD');
733:
734: hr_utility.trace('Before XLA_EVENTS_PUB_PKG.delete_event');
735: -- delete the event in SLA
736: XLA_EVENTS_PUB_PKG.delete_event (
737: p_event_source_info => l_event_source_info,
738: p_event_id => xlarec.event_id,
739: p_valuation_method => null,
740: p_security_context => l_security_context

Line 742: hr_utility.trace('After XLA_EVENTS_PUB_PKG.delete_event');

738: p_event_id => xlarec.event_id,
739: p_valuation_method => null,
740: p_security_context => l_security_context
741: );
742: hr_utility.trace('After XLA_EVENTS_PUB_PKG.delete_event');
743: end loop;
744:
745: -- delete the event from pay_xla_events
746: DELETE from pay_xla_events