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.

APPS.XLA_00140_AAD_S_000018_PKG dependencies on IGI_IAC_XLA_LINES_GT

Line 229990: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

229986: FROM (
229987: SELECT xet.event_id event_id
229988: , l2.line_number line_number
229989: , CASE r
229990: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
229991: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
229992: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
229993: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
229994: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 230000: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

229996: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
229997: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
229998: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
229999: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
230000: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

229997: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
229998: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
229999: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
230000: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'

229998: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
229999: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
230000: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

229999: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
230000: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

230000: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

230001: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

230002: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
230010: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'

Line 230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

230003: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
230010: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
230011: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

230004: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
230010: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
230011: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
230012: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

230005: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
230010: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
230011: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
230012: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
230013: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 230010: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'

230006: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
230007: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
230008: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
230009: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
230010: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
230011: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
230012: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
230013: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
230014: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 230017: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'

230013: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
230014: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
230015: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
230016: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
230017: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
230018: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
230019: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
230020:
230021: ELSE null

Line 230018: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'

230014: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
230015: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
230016: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
230017: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
230018: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
230019: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
230020:
230021: ELSE null
230022: END object_name

Line 230019: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'

230015: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
230016: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
230017: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
230018: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
230019: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
230020:
230021: ELSE null
230022: END object_name
230023: , CASE r

Line 230163: , IGI_IAC_XLA_LINES_GT l3

230159: END source_value
230160: , null source_meaning
230161: FROM xla_events_gt xet
230162: , FA_XLA_EXT_LINES_B_GT l2
230163: , IGI_IAC_XLA_LINES_GT l3
230164: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
230165: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
230166: AND xet.event_class_code = C_EVENT_CLASS_CODE
230167: AND l2.event_id = xet.event_id

Line 230307: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

230303: TYPE t_array_source_3 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
230304: TYPE t_array_source_32 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.DEFAULT_CCID%TYPE INDEX BY BINARY_INTEGER;
230305: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
230306:
230307: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
230308: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
230309: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
230310: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
230311: TYPE t_array_source_8 IS TABLE OF FA_XLA_EXT_LINES_B_GT.PAYABLES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230317: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

230313: TYPE t_array_source_11 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_COST_ACCT%TYPE INDEX BY BINARY_INTEGER;
230314: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
230315: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
230316: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
230317: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

230314: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
230315: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
230316: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
230317: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

230315: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
230316: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
230317: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

230316: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
230317: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

230317: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

230318: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

230319: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230327: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

230320: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230327: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
230328: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

230321: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230327: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
230328: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
230329: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

230322: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230327: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
230328: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
230329: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
230330: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 230327: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

230323: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
230324: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
230325: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
230326: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
230327: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
230328: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
230329: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
230330: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
230331: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 230334: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

230330: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
230331: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
230332: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
230333: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
230334: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
230335: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
230336: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
230337:
230338: l_array_source_1 t_array_source_1;

Line 230335: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

230331: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
230332: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
230333: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
230334: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
230335: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
230336: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
230337:
230338: l_array_source_1 t_array_source_1;
230339: l_array_source_3 t_array_source_3;

Line 230336: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

230332: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
230333: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
230334: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
230335: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
230336: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
230337:
230338: l_array_source_1 t_array_source_1;
230339: l_array_source_3 t_array_source_3;
230340: l_array_source_32 t_array_source_32;

Line 230479: , IGI_IAC_XLA_LINES_GT l3

230475: , l3.IAC_AMOUNT source_65
230476: , l3.IAC_CURRENCY_CODE source_66
230477: FROM xla_events_gt xet
230478: , FA_XLA_EXT_LINES_B_GT l2
230479: , IGI_IAC_XLA_LINES_GT l3
230480: WHERE xet.event_id between x_first_event_id and x_last_event_id
230481: and xet.event_date between p_pad_start_date and p_pad_end_date
230482: and xet.event_class_code = C_EVENT_CLASS_CODE
230483: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 231861: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

231857: FROM (
231858: SELECT xet.event_id event_id
231859: , l2.line_number line_number
231860: , CASE r
231861: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
231862: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
231863: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
231864: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
231865: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 231871: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

231867: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
231868: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
231869: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
231870: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
231871: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

231868: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
231869: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
231870: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
231871: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'

231869: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
231870: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
231871: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

231870: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
231871: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

231871: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

231872: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

231873: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
231881: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'

Line 231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

231874: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
231881: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
231882: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

231875: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
231881: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
231882: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
231883: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

231876: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
231881: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
231882: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
231883: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
231884: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 231881: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'

231877: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
231878: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
231879: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
231880: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
231881: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
231882: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
231883: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
231884: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
231885: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 231888: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'

231884: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
231885: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
231886: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
231887: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
231888: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
231889: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
231890: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
231891:
231892: ELSE null

Line 231889: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'

231885: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
231886: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
231887: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
231888: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
231889: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
231890: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
231891:
231892: ELSE null
231893: END object_name

Line 231890: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'

231886: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
231887: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
231888: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
231889: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
231890: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
231891:
231892: ELSE null
231893: END object_name
231894: , CASE r

Line 232034: , IGI_IAC_XLA_LINES_GT l3

232030: END source_value
232031: , null source_meaning
232032: FROM xla_events_gt xet
232033: , FA_XLA_EXT_LINES_B_GT l2
232034: , IGI_IAC_XLA_LINES_GT l3
232035: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
232036: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
232037: AND xet.event_class_code = C_EVENT_CLASS_CODE
232038: AND l2.event_id = xet.event_id

Line 232180: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

232176: TYPE t_array_source_22 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.AR_INTERCOMPANY_ACCT%TYPE INDEX BY BINARY_INTEGER;
232177: TYPE t_array_source_32 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.DEFAULT_CCID%TYPE INDEX BY BINARY_INTEGER;
232178: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
232179:
232180: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
232181: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
232182: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
232183: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
232184: TYPE t_array_source_8 IS TABLE OF FA_XLA_EXT_LINES_B_GT.PAYABLES_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232190: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

232186: TYPE t_array_source_11 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_COST_ACCT%TYPE INDEX BY BINARY_INTEGER;
232187: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
232188: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
232189: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
232190: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

232187: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
232188: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
232189: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
232190: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

232188: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
232189: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
232190: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

232189: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
232190: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

232190: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

232191: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

232192: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232200: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

232193: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232200: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
232201: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

232194: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232200: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
232201: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
232202: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

232195: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232200: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
232201: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
232202: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
232203: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 232200: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

232196: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
232197: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
232198: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
232199: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
232200: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
232201: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
232202: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
232203: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
232204: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 232207: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

232203: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
232204: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
232205: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
232206: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
232207: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
232208: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
232209: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
232210:
232211: l_array_source_1 t_array_source_1;

Line 232208: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

232204: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
232205: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
232206: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
232207: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
232208: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
232209: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
232210:
232211: l_array_source_1 t_array_source_1;
232212: l_array_source_3 t_array_source_3;

Line 232209: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

232205: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
232206: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
232207: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
232208: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
232209: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
232210:
232211: l_array_source_1 t_array_source_1;
232212: l_array_source_3 t_array_source_3;
232213: l_array_source_21 t_array_source_21;

Line 232356: , IGI_IAC_XLA_LINES_GT l3

232352: , l3.IAC_AMOUNT source_65
232353: , l3.IAC_CURRENCY_CODE source_66
232354: FROM xla_events_gt xet
232355: , FA_XLA_EXT_LINES_B_GT l2
232356: , IGI_IAC_XLA_LINES_GT l3
232357: WHERE xet.event_id between x_first_event_id and x_last_event_id
232358: and xet.event_date between p_pad_start_date and p_pad_end_date
232359: and xet.event_class_code = C_EVENT_CLASS_CODE
232360: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 235198: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

235194: FROM (
235195: SELECT xet.event_id event_id
235196: , l2.line_number line_number
235197: , CASE r
235198: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
235199: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
235200: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
235201: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
235202: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 235207: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'

235203: WHEN 6 THEN 'FA_XLA_EXT_LINES_B_GT'
235204: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
235205: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
235206: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
235207: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

235204: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
235205: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
235206: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
235207: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

235205: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
235206: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
235207: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'

235206: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
235207: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

235207: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

235208: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

235209: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
235217: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

235210: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
235217: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
235218: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

235211: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
235217: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
235218: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
235219: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

235212: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
235217: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
235218: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
235219: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
235220: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 235217: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

235213: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
235214: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
235215: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
235216: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
235217: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
235218: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
235219: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
235220: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
235221: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 235225: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'

235221: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
235222: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
235223: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
235224: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
235225: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
235226: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
235227: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
235228:
235229: ELSE null

Line 235226: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'

235222: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
235223: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
235224: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
235225: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
235226: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
235227: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
235228:
235229: ELSE null
235230: END object_name

Line 235227: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'

235223: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
235224: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
235225: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
235226: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
235227: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
235228:
235229: ELSE null
235230: END object_name
235231: , CASE r

Line 235371: , IGI_IAC_XLA_LINES_GT l3

235367: END source_value
235368: , null source_meaning
235369: FROM xla_events_gt xet
235370: , FA_XLA_EXT_LINES_B_GT l2
235371: , IGI_IAC_XLA_LINES_GT l3
235372: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
235373: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
235374: AND xet.event_class_code = C_EVENT_CLASS_CODE
235375: AND l2.event_id = xet.event_id

Line 235515: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

235511: TYPE t_array_source_3 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
235512: TYPE t_array_source_32 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.DEFAULT_CCID%TYPE INDEX BY BINARY_INTEGER;
235513: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
235514:
235515: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
235516: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
235517: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
235518: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
235519: TYPE t_array_source_11 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_COST_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 235524: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

235520: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
235521: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
235522: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
235523: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
235524: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

235521: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
235522: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
235523: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
235524: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

235522: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
235523: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
235524: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

235523: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
235524: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

235524: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

235525: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

235526: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235534: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

235527: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235534: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
235535: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

235528: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235534: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
235535: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
235536: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

235529: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235534: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
235535: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
235536: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
235537: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 235534: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

235530: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
235531: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
235532: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
235533: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
235534: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
235535: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
235536: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
235537: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
235538: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 235542: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

235538: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
235539: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
235540: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
235541: TYPE t_array_source_55 IS TABLE OF FA_XLA_EXT_LINES_B_GT.SOURCE_DEST_CODE%TYPE INDEX BY BINARY_INTEGER;
235542: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
235543: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
235544: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
235545:
235546: l_array_source_1 t_array_source_1;

Line 235543: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

235539: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
235540: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
235541: TYPE t_array_source_55 IS TABLE OF FA_XLA_EXT_LINES_B_GT.SOURCE_DEST_CODE%TYPE INDEX BY BINARY_INTEGER;
235542: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
235543: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
235544: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
235545:
235546: l_array_source_1 t_array_source_1;
235547: l_array_source_3 t_array_source_3;

Line 235544: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

235540: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
235541: TYPE t_array_source_55 IS TABLE OF FA_XLA_EXT_LINES_B_GT.SOURCE_DEST_CODE%TYPE INDEX BY BINARY_INTEGER;
235542: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
235543: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
235544: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
235545:
235546: l_array_source_1 t_array_source_1;
235547: l_array_source_3 t_array_source_3;
235548: l_array_source_32 t_array_source_32;

Line 235687: , IGI_IAC_XLA_LINES_GT l3

235683: , l3.IAC_AMOUNT source_65
235684: , l3.IAC_CURRENCY_CODE source_66
235685: FROM xla_events_gt xet
235686: , FA_XLA_EXT_LINES_B_GT l2
235687: , IGI_IAC_XLA_LINES_GT l3
235688: WHERE xet.event_id between x_first_event_id and x_last_event_id
235689: and xet.event_date between p_pad_start_date and p_pad_end_date
235690: and xet.event_class_code = C_EVENT_CLASS_CODE
235691: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 252019: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

252015: FROM (
252016: SELECT xet.event_id event_id
252017: , l2.line_number line_number
252018: , CASE r
252019: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
252020: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
252021: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
252022: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
252023: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 252032: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

252028: WHEN 10 THEN 'FA_XLA_EXT_LINES_B_GT'
252029: WHEN 11 THEN 'FA_XLA_EXT_LINES_B_GT'
252030: WHEN 12 THEN 'FA_XLA_EXT_LINES_B_GT'
252031: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
252032: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

252029: WHEN 11 THEN 'FA_XLA_EXT_LINES_B_GT'
252030: WHEN 12 THEN 'FA_XLA_EXT_LINES_B_GT'
252031: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
252032: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

252030: WHEN 12 THEN 'FA_XLA_EXT_LINES_B_GT'
252031: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
252032: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

252031: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
252032: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

252032: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

252033: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'
252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

252034: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'
252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'
252042: WHEN 24 THEN 'IGI_IAC_XLA_LINES_GT'

Line 252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'

252035: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'
252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'
252042: WHEN 24 THEN 'IGI_IAC_XLA_LINES_GT'
252043: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'

252036: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'
252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'
252042: WHEN 24 THEN 'IGI_IAC_XLA_LINES_GT'
252043: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
252044: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'

252037: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'
252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'
252042: WHEN 24 THEN 'IGI_IAC_XLA_LINES_GT'
252043: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
252044: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
252045: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 252042: WHEN 24 THEN 'IGI_IAC_XLA_LINES_GT'

252038: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
252039: WHEN 21 THEN 'IGI_IAC_XLA_LINES_GT'
252040: WHEN 22 THEN 'IGI_IAC_XLA_LINES_GT'
252041: WHEN 23 THEN 'IGI_IAC_XLA_LINES_GT'
252042: WHEN 24 THEN 'IGI_IAC_XLA_LINES_GT'
252043: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
252044: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
252045: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
252046: WHEN 28 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 252051: WHEN 33 THEN 'IGI_IAC_XLA_LINES_GT'

252047: WHEN 29 THEN 'FA_XLA_EXT_LINES_B_GT'
252048: WHEN 30 THEN 'FA_XLA_EXT_LINES_B_GT'
252049: WHEN 31 THEN 'FA_XLA_EXT_LINES_B_GT'
252050: WHEN 32 THEN 'FA_XLA_EXT_LINES_B_GT'
252051: WHEN 33 THEN 'IGI_IAC_XLA_LINES_GT'
252052: WHEN 34 THEN 'IGI_IAC_XLA_LINES_GT'
252053: WHEN 35 THEN 'IGI_IAC_XLA_LINES_GT'
252054:
252055: ELSE null

Line 252052: WHEN 34 THEN 'IGI_IAC_XLA_LINES_GT'

252048: WHEN 30 THEN 'FA_XLA_EXT_LINES_B_GT'
252049: WHEN 31 THEN 'FA_XLA_EXT_LINES_B_GT'
252050: WHEN 32 THEN 'FA_XLA_EXT_LINES_B_GT'
252051: WHEN 33 THEN 'IGI_IAC_XLA_LINES_GT'
252052: WHEN 34 THEN 'IGI_IAC_XLA_LINES_GT'
252053: WHEN 35 THEN 'IGI_IAC_XLA_LINES_GT'
252054:
252055: ELSE null
252056: END object_name

Line 252053: WHEN 35 THEN 'IGI_IAC_XLA_LINES_GT'

252049: WHEN 31 THEN 'FA_XLA_EXT_LINES_B_GT'
252050: WHEN 32 THEN 'FA_XLA_EXT_LINES_B_GT'
252051: WHEN 33 THEN 'IGI_IAC_XLA_LINES_GT'
252052: WHEN 34 THEN 'IGI_IAC_XLA_LINES_GT'
252053: WHEN 35 THEN 'IGI_IAC_XLA_LINES_GT'
252054:
252055: ELSE null
252056: END object_name
252057: , CASE r

Line 252217: , IGI_IAC_XLA_LINES_GT l3

252213: END source_value
252214: , null source_meaning
252215: FROM xla_events_gt xet
252216: , FA_XLA_EXT_LINES_B_GT l2
252217: , IGI_IAC_XLA_LINES_GT l3
252218: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
252219: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
252220: AND xet.event_class_code = C_EVENT_CLASS_CODE
252221: AND l2.event_id = xet.event_id

Line 252364: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

252360: TYPE t_array_source_59 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.BOOK_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
252361: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
252362: TYPE t_array_source_72 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
252363:
252364: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
252365: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
252366: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
252367: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
252368: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 252377: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

252373: TYPE t_array_source_33 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
252374: TYPE t_array_source_34 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
252375: TYPE t_array_source_35 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
252376: TYPE t_array_source_36 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
252377: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

252374: TYPE t_array_source_34 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
252375: TYPE t_array_source_35 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
252376: TYPE t_array_source_36 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
252377: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

252375: TYPE t_array_source_35 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
252376: TYPE t_array_source_36 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
252377: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

252376: TYPE t_array_source_36 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
252377: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

252377: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

252378: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

252379: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252387: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

252380: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252387: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
252388: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

252381: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252387: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
252388: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
252389: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

252382: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252387: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
252388: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
252389: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252390: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 252387: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

252383: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
252384: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
252385: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
252386: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
252387: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
252388: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
252389: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252390: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
252391: TYPE t_array_source_56 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_ID%TYPE INDEX BY BINARY_INTEGER;

Line 252396: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

252392: TYPE t_array_source_58 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
252393: TYPE t_array_source_61 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252394: TYPE t_array_source_62 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RUN_ID%TYPE INDEX BY BINARY_INTEGER;
252395: TYPE t_array_source_63 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252396: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
252397: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252398: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
252399:
252400: l_array_source_1 t_array_source_1;

Line 252397: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

252393: TYPE t_array_source_61 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252394: TYPE t_array_source_62 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RUN_ID%TYPE INDEX BY BINARY_INTEGER;
252395: TYPE t_array_source_63 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252396: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
252397: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252398: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
252399:
252400: l_array_source_1 t_array_source_1;
252401: l_array_source_3 t_array_source_3;

Line 252398: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

252394: TYPE t_array_source_62 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RUN_ID%TYPE INDEX BY BINARY_INTEGER;
252395: TYPE t_array_source_63 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252396: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
252397: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
252398: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
252399:
252400: l_array_source_1 t_array_source_1;
252401: l_array_source_3 t_array_source_3;
252402: l_array_source_32 t_array_source_32;

Line 252557: , IGI_IAC_XLA_LINES_GT l3

252553: , l3.IAC_AMOUNT source_65
252554: , l3.IAC_CURRENCY_CODE source_66
252555: FROM xla_events_gt xet
252556: , FA_XLA_EXT_LINES_B_GT l2
252557: , IGI_IAC_XLA_LINES_GT l3
252558: WHERE xet.event_id between x_first_event_id and x_last_event_id
252559: and xet.event_date between p_pad_start_date and p_pad_end_date
252560: and xet.event_class_code = C_EVENT_CLASS_CODE
252561: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 253983: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

253979: FROM (
253980: SELECT xet.event_id event_id
253981: , l2.line_number line_number
253982: , CASE r
253983: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'
253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'

253980: SELECT xet.event_id event_id
253981: , l2.line_number line_number
253982: , CASE r
253983: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'
253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'

253981: , l2.line_number line_number
253982: , CASE r
253983: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'
253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'

253982: , CASE r
253983: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'
253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'

253983: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'
253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'

253984: WHEN 2 THEN 'IGI_IAC_XLA_LINES_GT'
253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'

253985: WHEN 3 THEN 'IGI_IAC_XLA_LINES_GT'
253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'

253986: WHEN 4 THEN 'IGI_IAC_XLA_LINES_GT'
253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'

253987: WHEN 5 THEN 'IGI_IAC_XLA_LINES_GT'
253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'

253988: WHEN 6 THEN 'IGI_IAC_XLA_LINES_GT'
253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

253989: WHEN 7 THEN 'IGI_IAC_XLA_LINES_GT'
253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

253990: WHEN 8 THEN 'IGI_IAC_XLA_LINES_GT'
253991: WHEN 9 THEN 'IGI_IAC_XLA_LINES_GT'
253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

253992: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

253993: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

253994: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
254002: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

253995: WHEN 13 THEN 'FA_XLA_EXT_LINES_B_GT'
253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
254002: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
254003:

Line 254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

253996: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
254002: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
254003:
254004: ELSE null

Line 254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

253997: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
254002: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
254003:
254004: ELSE null
254005: END object_name

Line 254002: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

253998: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
253999: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
254000: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
254001: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
254002: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
254003:
254004: ELSE null
254005: END object_name
254006: , CASE r

Line 254106: , IGI_IAC_XLA_LINES_GT l3

254102: END source_value
254103: , null source_meaning
254104: FROM xla_events_gt xet
254105: , FA_XLA_EXT_LINES_B_GT l2
254106: , IGI_IAC_XLA_LINES_GT l3
254107: , (select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)
254108: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
254109: AND xet.event_class_code = C_EVENT_CLASS_CODE
254110: AND l2.event_id = xet.event_id

Line 254248: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

254244:
254245: TYPE t_array_source_3 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
254246: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
254247:
254248: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

254245: TYPE t_array_source_3 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
254246: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
254247:
254248: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

254246: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
254247:
254248: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

254247:
254248: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

254248: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

254249: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

254250: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

254251: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

254252: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

254253: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

254254: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

254255: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
254256: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

254257: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;

Line 254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

254258: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;
254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

254259: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;
254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
254267: TYPE t_array_source_70 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;

254260: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;
254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
254267: TYPE t_array_source_70 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
254268:

Line 254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;

254261: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;
254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
254267: TYPE t_array_source_70 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
254268:
254269: l_array_source_3 t_array_source_3;

Line 254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

254262: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;
254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
254267: TYPE t_array_source_70 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
254268:
254269: l_array_source_3 t_array_source_3;
254270: l_array_source_71 t_array_source_71;

Line 254267: TYPE t_array_source_70 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

254263: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
254264: TYPE t_array_source_67 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_ID%TYPE INDEX BY BINARY_INTEGER;
254265: TYPE t_array_source_68 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_ID%TYPE INDEX BY BINARY_INTEGER;
254266: TYPE t_array_source_69 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
254267: TYPE t_array_source_70 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
254268:
254269: l_array_source_3 t_array_source_3;
254270: l_array_source_71 t_array_source_71;
254271:

Line 254386: , IGI_IAC_XLA_LINES_GT l3

254382: , l3.IAC_DISTRIBUTION_ID source_69
254383: , l3.IAC_ADJUSTMENT_LINE_ID source_70
254384: FROM xla_events_gt xet
254385: , FA_XLA_EXT_LINES_B_GT l2
254386: , IGI_IAC_XLA_LINES_GT l3
254387: WHERE xet.event_id between x_first_event_id and x_last_event_id
254388: and xet.event_date between p_pad_start_date and p_pad_end_date
254389: and xet.event_class_code = C_EVENT_CLASS_CODE
254390: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 255575: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

255571: FROM (
255572: SELECT xet.event_id event_id
255573: , l2.line_number line_number
255574: , CASE r
255575: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
255576: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
255577: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
255578: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
255579: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 255584: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'

255580: WHEN 6 THEN 'FA_XLA_EXT_LINES_B_GT'
255581: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
255582: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
255583: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
255584: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

255581: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
255582: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
255583: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
255584: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

255582: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
255583: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
255584: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'

255583: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
255584: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

255584: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

255585: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

255586: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
255594: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

255587: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
255594: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
255595: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

255588: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
255594: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
255595: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
255596: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

255589: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
255594: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
255595: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
255596: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
255597: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 255594: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

255590: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
255591: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
255592: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
255593: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
255594: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
255595: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
255596: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
255597: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
255598: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 255602: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'

255598: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
255599: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
255600: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
255601: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
255602: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
255603: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
255604: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
255605:
255606: ELSE null

Line 255603: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'

255599: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
255600: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
255601: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
255602: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
255603: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
255604: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
255605:
255606: ELSE null
255607: END object_name

Line 255604: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'

255600: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
255601: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
255602: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
255603: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
255604: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
255605:
255606: ELSE null
255607: END object_name
255608: , CASE r

Line 255748: , IGI_IAC_XLA_LINES_GT l3

255744: END source_value
255745: , null source_meaning
255746: FROM xla_events_gt xet
255747: , FA_XLA_EXT_LINES_B_GT l2
255748: , IGI_IAC_XLA_LINES_GT l3
255749: ,(select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
255750: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
255751: AND xet.event_type_code = C_EVENT_TYPE_CODE
255752: AND l2.event_id = xet.event_id

Line 255902: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

255898: TYPE t_array_source_30 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.REVAL_RSV_RETIRED_LOSS_ACCT%TYPE INDEX BY BINARY_INTEGER;
255899: TYPE t_array_source_32 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.DEFAULT_CCID%TYPE INDEX BY BINARY_INTEGER;
255900: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
255901:
255902: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
255903: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
255904: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
255905: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
255906: TYPE t_array_source_11 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_COST_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 255911: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

255907: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
255908: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
255909: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
255910: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
255911: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

255908: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
255909: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
255910: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
255911: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

255909: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
255910: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
255911: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

255910: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
255911: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

255911: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

255912: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

255913: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255921: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

255914: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255921: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
255922: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

255915: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255921: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
255922: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
255923: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

255916: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255921: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
255922: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
255923: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
255924: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 255921: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

255917: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
255918: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
255919: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
255920: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
255921: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
255922: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
255923: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
255924: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
255925: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 255929: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

255925: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
255926: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255927: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
255928: TYPE t_array_source_54 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GAIN_LOSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255929: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
255930: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255931: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
255932:
255933: l_array_source_1 t_array_source_1;

Line 255930: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

255926: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255927: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
255928: TYPE t_array_source_54 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GAIN_LOSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255929: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
255930: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255931: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
255932:
255933: l_array_source_1 t_array_source_1;
255934: l_array_source_3 t_array_source_3;

Line 255931: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

255927: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
255928: TYPE t_array_source_54 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GAIN_LOSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255929: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
255930: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
255931: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
255932:
255933: l_array_source_1 t_array_source_1;
255934: l_array_source_3 t_array_source_3;
255935: l_array_source_14 t_array_source_14;

Line 256095: , IGI_IAC_XLA_LINES_GT l3

256091: , l3.IAC_AMOUNT source_65
256092: , l3.IAC_CURRENCY_CODE source_66
256093: FROM xla_events_gt xet
256094: , FA_XLA_EXT_LINES_B_GT l2
256095: , IGI_IAC_XLA_LINES_GT l3
256096: WHERE xet.event_id between x_first_event_id and x_last_event_id
256097: and xet.event_date between p_pad_start_date and p_pad_end_date
256098: and xet.event_type_code = C_EVENT_TYPE_CODE
256099: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 259164: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

259160: FROM (
259161: SELECT xet.event_id event_id
259162: , l2.line_number line_number
259163: , CASE r
259164: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
259165: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
259166: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
259167: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
259168: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 259173: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'

259169: WHEN 6 THEN 'FA_XLA_EXT_LINES_B_GT'
259170: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
259171: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
259172: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
259173: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

259170: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
259171: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
259172: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
259173: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

259171: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
259172: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
259173: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'

259172: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
259173: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

259173: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

259174: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

259175: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
259183: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

259176: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
259183: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
259184: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

259177: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
259183: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
259184: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
259185: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

259178: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
259183: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
259184: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
259185: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
259186: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 259183: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

259179: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
259180: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
259181: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
259182: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
259183: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
259184: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
259185: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
259186: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
259187: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 259191: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'

259187: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
259188: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
259189: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
259190: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
259191: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
259192: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
259193: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
259194:
259195: ELSE null

Line 259192: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'

259188: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
259189: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
259190: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
259191: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
259192: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
259193: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
259194:
259195: ELSE null
259196: END object_name

Line 259193: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'

259189: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
259190: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
259191: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
259192: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
259193: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
259194:
259195: ELSE null
259196: END object_name
259197: , CASE r

Line 259337: , IGI_IAC_XLA_LINES_GT l3

259333: END source_value
259334: , null source_meaning
259335: FROM xla_events_gt xet
259336: , FA_XLA_EXT_LINES_B_GT l2
259337: , IGI_IAC_XLA_LINES_GT l3
259338: ,(select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
259339: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
259340: AND xet.event_type_code = C_EVENT_TYPE_CODE
259341: AND l2.event_id = xet.event_id

Line 259491: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

259487: TYPE t_array_source_30 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.REVAL_RSV_RETIRED_LOSS_ACCT%TYPE INDEX BY BINARY_INTEGER;
259488: TYPE t_array_source_32 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.DEFAULT_CCID%TYPE INDEX BY BINARY_INTEGER;
259489: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
259490:
259491: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
259492: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
259493: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
259494: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
259495: TYPE t_array_source_11 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_COST_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 259500: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

259496: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
259497: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
259498: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
259499: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
259500: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

259497: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
259498: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
259499: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
259500: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

259498: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
259499: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
259500: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

259499: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
259500: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

259500: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

259501: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

259502: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259510: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

259503: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259510: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
259511: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

259504: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259510: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
259511: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
259512: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

259505: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259510: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
259511: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
259512: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
259513: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 259510: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

259506: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
259507: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
259508: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
259509: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
259510: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
259511: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
259512: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
259513: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
259514: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 259518: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

259514: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
259515: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259516: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
259517: TYPE t_array_source_54 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GAIN_LOSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259518: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
259519: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259520: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
259521:
259522: l_array_source_1 t_array_source_1;

Line 259519: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

259515: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259516: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
259517: TYPE t_array_source_54 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GAIN_LOSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259518: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
259519: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259520: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
259521:
259522: l_array_source_1 t_array_source_1;
259523: l_array_source_3 t_array_source_3;

Line 259520: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

259516: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
259517: TYPE t_array_source_54 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GAIN_LOSS_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259518: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
259519: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
259520: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
259521:
259522: l_array_source_1 t_array_source_1;
259523: l_array_source_3 t_array_source_3;
259524: l_array_source_14 t_array_source_14;

Line 259684: , IGI_IAC_XLA_LINES_GT l3

259680: , l3.IAC_AMOUNT source_65
259681: , l3.IAC_CURRENCY_CODE source_66
259682: FROM xla_events_gt xet
259683: , FA_XLA_EXT_LINES_B_GT l2
259684: , IGI_IAC_XLA_LINES_GT l3
259685: WHERE xet.event_id between x_first_event_id and x_last_event_id
259686: and xet.event_date between p_pad_start_date and p_pad_end_date
259687: and xet.event_type_code = C_EVENT_TYPE_CODE
259688: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 268611: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'

268607: FROM (
268608: SELECT xet.event_id event_id
268609: , l2.line_number line_number
268610: , CASE r
268611: WHEN 1 THEN 'IGI_IAC_XLA_LINES_GT'
268612: WHEN 2 THEN 'FA_XLA_EXT_LINES_B_GT'
268613: WHEN 3 THEN 'FA_XLA_EXT_LINES_B_GT'
268614: WHEN 4 THEN 'FA_XLA_EXT_LINES_B_GT'
268615: WHEN 5 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 268620: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'

268616: WHEN 6 THEN 'FA_XLA_EXT_LINES_B_GT'
268617: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
268618: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
268619: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
268620: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'

268617: WHEN 7 THEN 'FA_XLA_EXT_LINES_B_GT'
268618: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
268619: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
268620: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'

268618: WHEN 8 THEN 'FA_XLA_EXT_LINES_B_GT'
268619: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
268620: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'

268619: WHEN 9 THEN 'FA_XLA_EXT_LINES_B_GT'
268620: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'

268620: WHEN 10 THEN 'IGI_IAC_XLA_LINES_GT'
268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'

268621: WHEN 11 THEN 'IGI_IAC_XLA_LINES_GT'
268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'

268622: WHEN 12 THEN 'IGI_IAC_XLA_LINES_GT'
268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
268630: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

Line 268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'

268623: WHEN 13 THEN 'IGI_IAC_XLA_LINES_GT'
268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
268630: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
268631: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'

268624: WHEN 14 THEN 'IGI_IAC_XLA_LINES_GT'
268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
268630: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
268631: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
268632: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'

268625: WHEN 15 THEN 'IGI_IAC_XLA_LINES_GT'
268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
268630: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
268631: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
268632: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
268633: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 268630: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'

268626: WHEN 16 THEN 'IGI_IAC_XLA_LINES_GT'
268627: WHEN 17 THEN 'IGI_IAC_XLA_LINES_GT'
268628: WHEN 18 THEN 'IGI_IAC_XLA_LINES_GT'
268629: WHEN 19 THEN 'IGI_IAC_XLA_LINES_GT'
268630: WHEN 20 THEN 'IGI_IAC_XLA_LINES_GT'
268631: WHEN 21 THEN 'FA_XLA_EXT_LINES_B_GT'
268632: WHEN 22 THEN 'FA_XLA_EXT_LINES_B_GT'
268633: WHEN 23 THEN 'FA_XLA_EXT_LINES_B_GT'
268634: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'

Line 268638: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'

268634: WHEN 24 THEN 'FA_XLA_EXT_LINES_B_GT'
268635: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
268636: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
268637: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
268638: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
268639: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
268640: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
268641:
268642: ELSE null

Line 268639: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'

268635: WHEN 25 THEN 'FA_XLA_EXT_LINES_B_GT'
268636: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
268637: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
268638: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
268639: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
268640: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
268641:
268642: ELSE null
268643: END object_name

Line 268640: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'

268636: WHEN 26 THEN 'FA_XLA_EXT_LINES_B_GT'
268637: WHEN 27 THEN 'FA_XLA_EXT_LINES_B_GT'
268638: WHEN 28 THEN 'IGI_IAC_XLA_LINES_GT'
268639: WHEN 29 THEN 'IGI_IAC_XLA_LINES_GT'
268640: WHEN 30 THEN 'IGI_IAC_XLA_LINES_GT'
268641:
268642: ELSE null
268643: END object_name
268644: , CASE r

Line 268784: , IGI_IAC_XLA_LINES_GT l3

268780: END source_value
268781: , null source_meaning
268782: FROM xla_events_gt xet
268783: , FA_XLA_EXT_LINES_B_GT l2
268784: , IGI_IAC_XLA_LINES_GT l3
268785: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
268786: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
268787: AND xet.event_class_code = C_EVENT_CLASS_CODE
268788: AND l2.event_id = xet.event_id

Line 268930: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;

268926: TYPE t_array_source_22 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.AR_INTERCOMPANY_ACCT%TYPE INDEX BY BINARY_INTEGER;
268927: TYPE t_array_source_32 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.DEFAULT_CCID%TYPE INDEX BY BINARY_INTEGER;
268928: TYPE t_array_source_71 IS TABLE OF FA_XLA_EXT_HEADERS_B_GT.TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
268929:
268930: TYPE t_array_source_2 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE_MEANING%TYPE INDEX BY BINARY_INTEGER;
268931: TYPE t_array_source_4 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_DEPRN_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
268932: TYPE t_array_source_5 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_CCID%TYPE INDEX BY BINARY_INTEGER;
268933: TYPE t_array_source_6 IS TABLE OF FA_XLA_EXT_LINES_B_GT.BONUS_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
268934: TYPE t_array_source_11 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ASSET_COST_ACCT%TYPE INDEX BY BINARY_INTEGER;

Line 268939: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;

268935: TYPE t_array_source_12 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DEPRN_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
268936: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
268937: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
268938: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
268939: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;

268936: TYPE t_array_source_13 IS TABLE OF FA_XLA_EXT_LINES_B_GT.REVAL_RESERVE_ACCT%TYPE INDEX BY BINARY_INTEGER;
268937: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
268938: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
268939: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

268937: TYPE t_array_source_19 IS TABLE OF FA_XLA_EXT_LINES_B_GT.GENERATED_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
268938: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
268939: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

268938: TYPE t_array_source_31 IS TABLE OF FA_XLA_EXT_LINES_B_GT.EXPENSE_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
268939: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;

268939: TYPE t_array_source_37 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ASSET_COST_CCID%TYPE INDEX BY BINARY_INTEGER;
268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;

268940: TYPE t_array_source_38 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_BACKLOG_DEPRN_RSV_CCID%TYPE INDEX BY BINARY_INTEGER;
268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;

268941: TYPE t_array_source_39 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268949: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

268942: TYPE t_array_source_40 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_DEPRN_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268949: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
268950: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;

268943: TYPE t_array_source_41 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_GENERAL_FUND_CCID%TYPE INDEX BY BINARY_INTEGER;
268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268949: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
268950: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
268951: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;

268944: TYPE t_array_source_42 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AP_CCID%TYPE INDEX BY BINARY_INTEGER;
268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268949: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
268950: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
268951: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
268952: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 268949: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;

268945: TYPE t_array_source_43 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_INTERCO_AR_CCID%TYPE INDEX BY BINARY_INTEGER;
268946: TYPE t_array_source_44 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_NBV_RETIRED_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
268947: TYPE t_array_source_45 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_OPERATING_EXPENSE_CCID%TYPE INDEX BY BINARY_INTEGER;
268948: TYPE t_array_source_46 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_CCID%TYPE INDEX BY BINARY_INTEGER;
268949: TYPE t_array_source_47 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_REVAL_RESERVE_RET_CCID%TYPE INDEX BY BINARY_INTEGER;
268950: TYPE t_array_source_48 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
268951: TYPE t_array_source_49 IS TABLE OF FA_XLA_EXT_LINES_B_GT.TRANSACTION_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
268952: TYPE t_array_source_50 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ADJUSTMENT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
268953: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 268957: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

268953: TYPE t_array_source_51 IS TABLE OF FA_XLA_EXT_LINES_B_GT.DISTRIBUTION_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
268954: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
268955: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
268956: TYPE t_array_source_55 IS TABLE OF FA_XLA_EXT_LINES_B_GT.SOURCE_DEST_CODE%TYPE INDEX BY BINARY_INTEGER;
268957: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
268958: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
268959: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
268960:
268961: l_array_source_1 t_array_source_1;

Line 268958: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

268954: TYPE t_array_source_52 IS TABLE OF FA_XLA_EXT_LINES_B_GT.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
268955: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
268956: TYPE t_array_source_55 IS TABLE OF FA_XLA_EXT_LINES_B_GT.SOURCE_DEST_CODE%TYPE INDEX BY BINARY_INTEGER;
268957: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
268958: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
268959: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
268960:
268961: l_array_source_1 t_array_source_1;
268962: l_array_source_3 t_array_source_3;

Line 268959: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

268955: TYPE t_array_source_53 IS TABLE OF FA_XLA_EXT_LINES_B_GT.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
268956: TYPE t_array_source_55 IS TABLE OF FA_XLA_EXT_LINES_B_GT.SOURCE_DEST_CODE%TYPE INDEX BY BINARY_INTEGER;
268957: TYPE t_array_source_64 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_ADJUSTMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
268958: TYPE t_array_source_65 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
268959: TYPE t_array_source_66 IS TABLE OF IGI_IAC_XLA_LINES_GT.IAC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
268960:
268961: l_array_source_1 t_array_source_1;
268962: l_array_source_3 t_array_source_3;
268963: l_array_source_21 t_array_source_21;

Line 269106: , IGI_IAC_XLA_LINES_GT l3

269102: , l3.IAC_AMOUNT source_65
269103: , l3.IAC_CURRENCY_CODE source_66
269104: FROM xla_events_gt xet
269105: , FA_XLA_EXT_LINES_B_GT l2
269106: , IGI_IAC_XLA_LINES_GT l3
269107: WHERE xet.event_id between x_first_event_id and x_last_event_id
269108: and xet.event_date between p_pad_start_date and p_pad_end_date
269109: and xet.event_class_code = C_EVENT_CLASS_CODE
269110: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id