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.

[Home] [Help]

APPS.PAY_SLA_PKG dependencies on PAY_XLA_EVENTS

Line 42: initialise event_status in pay_xla_events.

38: Also simplified Postprocessing.
39: Bug 5510388.
40: 120.7 A.Logue 15-Aug-2006 Correct entity_type_code passed to
41: XLA_EVENTS_PUB_PKG.create_event, and
42: initialise event_status in pay_xla_events.
43: 120.6 A.Logue 15-Jun-2006 Fix GSCC error.
44: 120.5 A.Logue 25-May-2006 Mark payroll action as complete if
45: all actions are complete in Postprocessing.
46: 120.4 A.Logue 25-Nov-2005 Added stub preaccounting, postaccounting

Line 195: -- create entry in pay_xla_events

191: p_valuation_method => null,
192: p_security_context => l_security_context
193: );
194: --
195: -- create entry in pay_xla_events
196: --
197: insert into pay_xla_events (assignment_action_id, event_id,
198: accounting_date, event_status)
199: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');

Line 197: insert into pay_xla_events (assignment_action_id, event_id,

193: );
194: --
195: -- create entry in pay_xla_events
196: --
197: insert into pay_xla_events (assignment_action_id, event_id,
198: accounting_date, event_status)
199: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');
200: --
201: else

Line 221: -- create entry in pay_xla_events

217: p_security_context => l_security_context
218: );
219:
220: --
221: -- create entry in pay_xla_events
222: --
223: insert into pay_xla_events (assignment_action_id, event_id,
224: accounting_date, event_status)
225: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');

Line 223: insert into pay_xla_events (assignment_action_id, event_id,

219:
220: --
221: -- create entry in pay_xla_events
222: --
223: insert into pay_xla_events (assignment_action_id, event_id,
224: accounting_date, event_status)
225: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');
226: --
227: end if;

Line 270: -- create entry in pay_xla_events

266: p_security_context => l_security_context
267: );
268:
269: --
270: -- create entry in pay_xla_events
271: --
272: insert into pay_xla_events (assignment_action_id, event_id,
273: accounting_date, event_status)
274: values (i_assignment_action_id, l_event_id, c_effective_date, 'U');

Line 272: insert into pay_xla_events (assignment_action_id, event_id,

268:
269: --
270: -- create entry in pay_xla_events
271: --
272: insert into pay_xla_events (assignment_action_id, event_id,
273: accounting_date, event_status)
274: values (i_assignment_action_id, l_event_id, c_effective_date, 'U');
275: --
276: -- Raise ESTIMATE_COST_REVERSAL event type event

Line 296: -- create entry in pay_xla_events

292: );
293:
294: --
295: --
296: -- create entry in pay_xla_events
297: --
298: insert into pay_xla_events (assignment_action_id, event_id,
299: accounting_date, event_status)
300: values (i_assignment_action_id, l_event_id, l_rev_accounting_date, 'U');

Line 298: insert into pay_xla_events (assignment_action_id, event_id,

294: --
295: --
296: -- create entry in pay_xla_events
297: --
298: insert into pay_xla_events (assignment_action_id, event_id,
299: accounting_date, event_status)
300: values (i_assignment_action_id, l_event_id, l_rev_accounting_date, 'U');
301: --
302: else

Line 344: -- create entry in pay_xla_events (assignment_action_id, event_id, date)

340: p_security_context => l_security_context
341: );
342:
343: --
344: -- create entry in pay_xla_events (assignment_action_id, event_id, date)
345: --
346: insert into pay_xla_events (assignment_action_id, event_id,
347: accounting_date, event_status)
348: values (i_assignment_action_id, l_event_id, account_date.accounting_date, 'U');

Line 346: insert into pay_xla_events (assignment_action_id, event_id,

342:
343: --
344: -- create entry in pay_xla_events (assignment_action_id, event_id, date)
345: --
346: insert into pay_xla_events (assignment_action_id, event_id,
347: accounting_date, event_status)
348: values (i_assignment_action_id, l_event_id, account_date.accounting_date, 'U');
349:
350: end loop;

Line 368: PAY_XLA_EVENTS PAYE

364: XPAE.SOURCE_ID_INT_1 event_aa_id,
365: XPAE.ledger_id ledger_id
366: FROM XLA_POST_ACCTG_EVENTS_V XPAE,
367: GL_SETS_OF_BOOKS GSOB,
368: PAY_XLA_EVENTS PAYE
369: WHERE XPAE.ledger_id = GSOB.set_of_books_id
370: AND PAYE.event_id = XPAE.event_id
371: AND PAYE.event_status <> 'C';
372:

Line 395: UPDATE pay_xla_events

391: --
392: --
393: -- Mark the Events as complete
394: --
395: UPDATE pay_xla_events
396: SET event_status = 'C'
397: WHERE event_id = xlarec.event_id;
398: --
399: end loop;

Line 637: FROM PAY_XLA_EVENTS PAYE

633: IS
634: CURSOR xla_events_cur IS
635: SELECT PAYE.event_id event_id,
636: PAYE.accounting_date
637: FROM PAY_XLA_EVENTS PAYE
638: WHERE PAYE.assignment_action_id = i_assignment_action_id;
639:
640: l_completed_events number;
641: l_ledger_id pay_all_payrolls_f.gl_set_of_books_id%TYPE;

Line 653: FROM pay_xla_events

649: -- Confirm no Completed events for this action
650: --
651: SELECT count(*)
652: INTO l_completed_events
653: FROM pay_xla_events
654: WHERE assignment_action_id = i_assignment_action_id
655: AND event_status = 'C';
656:
657: IF l_completed_events <> 0 THEN

Line 726: -- delete the event from pay_xla_events

722: );
723:
724: end loop;
725:
726: -- delete the event from pay_xla_events
727: DELETE from pay_xla_events
728: WHERE assignment_action_id = i_assignment_action_id;
729:
730: END IF;

Line 727: DELETE from pay_xla_events

723:
724: end loop;
725:
726: -- delete the event from pay_xla_events
727: DELETE from pay_xla_events
728: WHERE assignment_action_id = i_assignment_action_id;
729:
730: END IF;
731: --