DBA Data[Home] [Help]

APPS.PA_BILL_REV_XLA_UPGRADE dependencies on XLA_AE_HEADERS

Line 207: xla_ae_headers_s.nextval,

203: adjusted_flag)
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), ''),

Line 243: xla_ae_headers_s.nextval,

239: adjusted_flag)
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), ''),

Line 279: xla_ae_headers_s.nextval,

275: adjusted_flag)
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),''),

Line 315: xla_ae_headers_s.nextval,

311: adjusted_Flag)
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), ''),

Line 345: xla_ae_headers_s.nextval,

341: values
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,

Line 438: INTO XLA_AE_HEADERS

434: xla_events_s.nextval,
435: 'Y',
436: gl_date
437: )
438: INTO XLA_AE_HEADERS
439: (upg_batch_id,
440: upg_source_application_id,
441: application_id,
442: amb_context_code,

Line 475: xla_ae_headers_s.nextval,

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,
478: gl_period_name,
479: '',

Line 948: xla_ae_headers_s.nextval,

944: adjusted_flag)
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), ''),

Line 992: xla_ae_headers_s.nextval,

988: adjusted_flag)
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), ''),

Line 1036: xla_ae_headers_s.nextval,

1032: adjusted_flag)
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),''),

Line 1080: xla_ae_headers_s.nextval,

1076: adjusted_flag)
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), ''),

Line 1116: xla_ae_headers_s.nextval,

1112: values
1113: (rev_rowid,
1114: PROJECT_ID,
1115: DRAFT_REVENUE_NUM,
1116: xla_ae_headers_s.nextval,
1117: event_id,
1118: currency_code,
1119: gl_date,
1120: ledger_id,

Line 1124: INTO XLA_AE_HEADERS

1120: ledger_id,
1121: rep_set_of_books_id,
1122: adjusted_flag)
1123:
1124: INTO XLA_AE_HEADERS
1125: (upg_batch_id,
1126: upg_source_application_id,
1127: application_id,
1128: amb_context_code,

Line 1159: xla_ae_headers_s.nextval,

1155: 'DEFAULT',
1156: entity_id,
1157: event_id,
1158: decode(adjusted_flag,'Y','REVENUE_ADJ','REVENUE'),
1159: xla_ae_headers_s.nextval,
1160: rep_set_of_books_id,
1161: gl_date,
1162: gl_period_name,
1163: 'A',