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 949: xla_events_s.nextval,

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

Line 993: xla_events_s.nextval,

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

Line 1037: xla_events_s.nextval,

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

Line 1081: xla_events_s.nextval,

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

Line 1215: XLA_EVENTS evt,

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