APPS.PA_BILL_REV_XLA_UPGRADE dependencies on XLA_EVENTS

Line 208: xla_events_s.nextval,

204: values
205: ( project_id,
206: draft_revenue_num,
207: xla_ae_headers_s.nextval,
208: xla_events_s.nextval,
209: unbilled_code_combination_id,
210: decode(sign(unbilled_receivable_dr),
211: -1, abs(unbilled_receivable_dr), ''),
212: decode(sign(unbilled_receivable_dr),

Line 244: xla_events_s.nextval,

240: values
241: ( project_id,
242: draft_revenue_num,
243: xla_ae_headers_s.nextval,
244: xla_events_s.nextval,
245: unearned_code_combination_id,
246: decode(sign(unearned_revenue_cr),
247: 1, abs(unearned_revenue_cr), ''),
248: decode(sign(unearned_revenue_cr),

Line 280: xla_events_s.nextval,

276: values
277: ( project_id,
278: draft_revenue_num,
279: xla_ae_headers_s.nextval,
280: xla_events_s.nextval,
281: realized_gains_ccid,
282: decode(sign(realized_gains_amount),
283: 1, abs(realized_gains_amount),''),
284: decode(sign(realized_gains_amount),

Line 316: xla_events_s.nextval,

312: values
313: ( project_id,
314: draft_revenue_num,
315: xla_ae_headers_s.nextval,
316: xla_events_s.nextval,
317: realized_losses_ccid,
318: decode(sign(realized_losses_amount),
319: 1, abs(realized_losses_amount), ''),
320: decode(sign(realized_losses_amount),

Line 346: xla_events_s.nextval,

342: (REV_ROWID,
343: PROJECT_ID,
344: DRAFT_REVENUE_NUM,
345: xla_ae_headers_s.nextval,
346: xla_events_s.nextval,
347: set_of_books_id,
348: gl_date,
349: currency_code,
350: adjusted_flag)

Line 391: INTO XLA_EVENTS

387: l_last_update_login,
388: XLA_TRANSACTION_ENTITIES_S.nextval,
389: '' ,
390: transaction_number)
391: INTO XLA_EVENTS
392: (upg_batch_id,
393: upg_source_application_id,
394: application_id,
395: event_type_code,

Line 419: xla_events_s.nextval,

415: (batch_id,
416: upg_source_app_id,
417: app_id,
418: decode(adjusted_flag,'Y','REVENUE_ADJ','REVENUE'),
419: xla_events_s.nextval,
420: 'P',
421: 'P',
422: 'N',
423: gl_date,

Line 434: xla_events_s.nextval,

430: -2005,
431: 275,
432: '',
433: XLA_TRANSACTION_ENTITIES_S.nextval,
434: xla_events_s.nextval,
435: 'Y',
436: gl_date
437: )
438: INTO XLA_AE_HEADERS

Line 473: xla_events_s.nextval,

469: upg_source_app_id,
470: app_id,
471: 'DEFAULT',
472: XLA_TRANSACTION_ENTITIES_S.nextval,
473: xla_events_s.nextval,
474: decode(adjusted_flag,'Y','REVENUE_ADJ','REVENUE'),
475: xla_ae_headers_s.nextval,
476: set_of_books_id,
477: gl_date,

Line 950: xla_events_s.nextval,

946: values
947: ( project_id,
948: draft_revenue_num,
949: xla_ae_headers_s.nextval,
950: xla_events_s.nextval,
951: unbilled_code_combination_id,
952: decode(sign(mc_unbilled_receivable_dr),
953: -1, abs(mc_unbilled_receivable_dr), ''),
954: decode(sign(mc_unbilled_receivable_dr),

Line 994: xla_events_s.nextval,

990: values
991: ( project_id,
992: draft_revenue_num,
993: xla_ae_headers_s.nextval,
994: xla_events_s.nextval,
995: unearned_code_combination_id,
996: decode(sign(mc_unearned_revenue_cr),
997: 1, abs(mc_unearned_revenue_cr), ''),
998: decode(sign(mc_unearned_revenue_cr),

Line 1038: xla_events_s.nextval,

1034: values
1035: ( project_id,
1036: draft_revenue_num,
1037: xla_ae_headers_s.nextval,
1038: xla_events_s.nextval,
1039: realized_gains_ccid,
1040: decode(sign(mc_realized_gains_amount),
1041: 1, abs(mc_realized_gains_amount),''),
1042: decode(sign(mc_realized_gains_amount),

Line 1082: xla_events_s.nextval,

1078: values
1079: ( project_id,
1080: draft_revenue_num,
1081: xla_ae_headers_s.nextval,
1082: xla_events_s.nextval,
1083: realized_losses_ccid,
1084: decode(sign(mc_realized_losses_amount),
1085: 1, abs(mc_realized_losses_amount), ''),
1086: decode(sign(mc_realized_losses_amount),

Line 1216: XLA_EVENTS evt,

1212: decode(dr.draft_revenue_num_credited,null,'N','Y') adjusted_flag
1213: from pa_draft_revenues_all dr,
1214: pa_implementations_all imp,
1215: pa_mc_draft_revs_all mc,
1216: XLA_EVENTS evt,
1217: pa_xla_upg_ctrl gl,
1218: pa_projects_all pa,
1219: hr_organization_information hr
1220: where mc.rowid >= p_start_rowid