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