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 49: initialise event_status in pay_xla_events.

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.
53: 120.4 A.Logue 25-Nov-2005 Added stub preaccounting, postaccounting

Line 202: -- create entry in pay_xla_events

198: p_valuation_method => null,
199: p_security_context => l_security_context
200: );
201: --
202: -- create entry in pay_xla_events
203: --
204: insert into pay_xla_events (assignment_action_id, event_id,
205: accounting_date, event_status)
206: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');

Line 204: insert into pay_xla_events (assignment_action_id, event_id,

200: );
201: --
202: -- create entry in pay_xla_events
203: --
204: insert into pay_xla_events (assignment_action_id, event_id,
205: accounting_date, event_status)
206: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');
207: --
208: else

Line 231: -- create entry in pay_xla_events

227: p_security_context => l_security_context
228: );
229:
230: --
231: -- create entry in pay_xla_events
232: --
233: insert into pay_xla_events (assignment_action_id, event_id,
234: accounting_date, event_status)
235: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');

Line 233: insert into pay_xla_events (assignment_action_id, event_id,

229:
230: --
231: -- create entry in pay_xla_events
232: --
233: insert into pay_xla_events (assignment_action_id, event_id,
234: accounting_date, event_status)
235: values (i_assignment_action_id, l_event_id, l_accounting_date, 'U');
236: --
237: end if;

Line 280: -- create entry in pay_xla_events

276: p_security_context => l_security_context
277: );
278:
279: --
280: -- create entry in pay_xla_events
281: --
282: insert into pay_xla_events (assignment_action_id, event_id,
283: accounting_date, event_status)
284: values (i_assignment_action_id, l_event_id, c_effective_date, 'U');

Line 282: insert into pay_xla_events (assignment_action_id, event_id,

278:
279: --
280: -- create entry in pay_xla_events
281: --
282: insert into pay_xla_events (assignment_action_id, event_id,
283: accounting_date, event_status)
284: values (i_assignment_action_id, l_event_id, c_effective_date, 'U');
285: --
286: -- Raise ESTIMATE_COST_REVERSAL event type event

Line 306: -- create entry in pay_xla_events

302: );
303:
304: --
305: --
306: -- create entry in pay_xla_events
307: --
308: insert into pay_xla_events (assignment_action_id, event_id,
309: accounting_date, event_status)
310: values (i_assignment_action_id, l_event_id, l_rev_accounting_date, 'U');

Line 308: insert into pay_xla_events (assignment_action_id, event_id,

304: --
305: --
306: -- create entry in pay_xla_events
307: --
308: insert into pay_xla_events (assignment_action_id, event_id,
309: accounting_date, event_status)
310: values (i_assignment_action_id, l_event_id, l_rev_accounting_date, 'U');
311: --
312: else

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

350: p_security_context => l_security_context
351: );
352:
353: --
354: -- create entry in pay_xla_events (assignment_action_id, event_id, date)
355: --
356: insert into pay_xla_events (assignment_action_id, event_id,
357: accounting_date, event_status)
358: values (i_assignment_action_id, l_event_id, account_date.accounting_date, 'U');

Line 356: insert into pay_xla_events (assignment_action_id, event_id,

352:
353: --
354: -- create entry in pay_xla_events (assignment_action_id, event_id, date)
355: --
356: insert into pay_xla_events (assignment_action_id, event_id,
357: accounting_date, event_status)
358: values (i_assignment_action_id, l_event_id, account_date.accounting_date, 'U');
359:
360: end loop;

Line 378: PAY_XLA_EVENTS PAYE

374: XPAE.SOURCE_ID_INT_1 event_aa_id,
375: XPAE.ledger_id ledger_id
376: FROM XLA_POST_ACCTG_EVENTS_V XPAE,
377: GL_SETS_OF_BOOKS GSOB,
378: PAY_XLA_EVENTS PAYE
379: WHERE XPAE.ledger_id = GSOB.set_of_books_id
380: AND PAYE.event_id = XPAE.event_id
381: AND PAYE.event_status <> 'C';
382:

Line 405: UPDATE pay_xla_events

401: --
402: --
403: -- Mark the Events as complete
404: --
405: UPDATE pay_xla_events
406: SET event_status = 'C'
407: WHERE event_id = xlarec.event_id;
408: --
409: end loop;

Line 647: FROM PAY_XLA_EVENTS PAYE

643: IS
644: CURSOR xla_events_cur IS
645: SELECT PAYE.event_id event_id,
646: PAYE.accounting_date
647: FROM PAY_XLA_EVENTS PAYE
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;

Line 663: FROM pay_xla_events

659: -- Confirm no Completed events for this action
660: --
661: SELECT count(*)
662: INTO l_completed_events
663: FROM pay_xla_events
664: WHERE assignment_action_id = i_assignment_action_id
665: AND event_status = 'C';
666:
667: IF l_completed_events <> 0 THEN

Line 745: -- delete the event from pay_xla_events

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
747: WHERE assignment_action_id = i_assignment_action_id;
748:
749: END IF;

Line 746: DELETE from pay_xla_events

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
747: WHERE assignment_action_id = i_assignment_action_id;
748:
749: END IF;
750: --