DBA Data[Home] [Help]

APPS.XLA_00260_AAD_S_000001_PKG dependencies on CE_XLA_EXT_HEADERS_V

Line 10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'

10503: FROM (
10504: SELECT xet.event_id event_id
10505: , 0 line_number
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'

10504: SELECT xet.event_id event_id
10505: , 0 line_number
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'

10505: , 0 line_number
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'

10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'

10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'

10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'

10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'

10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'

10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'

10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'

10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'

10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'

10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'

10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'

10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'

10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'

10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'

10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'

10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'

10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'

10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'

10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'

10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'

Line 10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'

10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:

Line 10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'

10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10535: ELSE null

Line 10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'

10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10535: ELSE null
10536: END object_name

Line 10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'

10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10535: ELSE null
10536: END object_name
10537: , CASE r

Line 10668: , CE_XLA_EXT_HEADERS_V h1

10664:
10665: ELSE null
10666: END source_meaning
10667: FROM xla_events_gt xet
10668: , CE_XLA_EXT_HEADERS_V h1
10669: , fnd_lookup_values fvl22
10670: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
10671: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10672: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;

10807: --
10808: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10809: --
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

10808: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10809: --
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;

10809: --
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;

10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;

10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;

10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;

Line 10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;

10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:

Line 10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10839:

Line 10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10839:
10840: l_array_source_3 t_array_source_3;

Line 10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10839:
10840: l_array_source_3 t_array_source_3;
10841: l_array_source_4 t_array_source_4;

Line 10929: , CE_XLA_EXT_HEADERS_V h1

10925: , h1.CF_EXCHANGE_RATE source_27
10926: , h1.CF_EXCHANGE_RATE_TYPE source_28
10927: , h1.ACCOUNTING_DATE source_29
10928: FROM xla_events_gt xet
10929: , CE_XLA_EXT_HEADERS_V h1
10930: , fnd_lookup_values fvl22
10931: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10932: and xet.event_type_code = C_EVENT_TYPE_CODE
10933: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'

11909: FROM (
11910: SELECT xet.event_id event_id
11911: , 0 line_number
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'

11910: SELECT xet.event_id event_id
11911: , 0 line_number
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'

11911: , 0 line_number
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'

11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'

11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'

11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'

11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'

11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'

11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'

11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'

11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'

11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'

11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'

11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'

11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'

11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'

11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'

11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'

11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'

11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'

11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'

11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'

11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'

Line 11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'

11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:

Line 11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'

11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11941: ELSE null

Line 11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'

11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11941: ELSE null
11942: END object_name

Line 11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'

11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11941: ELSE null
11942: END object_name
11943: , CASE r

Line 12074: , CE_XLA_EXT_HEADERS_V h1

12070:
12071: ELSE null
12072: END source_meaning
12073: FROM xla_events_gt xet
12074: , CE_XLA_EXT_HEADERS_V h1
12075: , fnd_lookup_values fvl22
12076: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
12077: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12078: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;

12213: --
12214: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12215: --
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

12214: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12215: --
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;

12215: --
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;

12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;

12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;

12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;

Line 12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;

12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:

Line 12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12245:

Line 12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12245:
12246: l_array_source_3 t_array_source_3;

Line 12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12245:
12246: l_array_source_3 t_array_source_3;
12247: l_array_source_4 t_array_source_4;

Line 12335: , CE_XLA_EXT_HEADERS_V h1

12331: , h1.CF_EXCHANGE_RATE source_27
12332: , h1.CF_EXCHANGE_RATE_TYPE source_28
12333: , h1.ACCOUNTING_DATE source_29
12334: FROM xla_events_gt xet
12335: , CE_XLA_EXT_HEADERS_V h1
12336: , fnd_lookup_values fvl22
12337: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
12338: and xet.event_type_code = C_EVENT_TYPE_CODE
12339: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'

13315: FROM (
13316: SELECT xet.event_id event_id
13317: , 0 line_number
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'

13316: SELECT xet.event_id event_id
13317: , 0 line_number
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'

13317: , 0 line_number
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'

13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'

13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'

13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'

13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'

13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'

13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'

13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'

13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'

13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'

13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'

13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'

Line 13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'

13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:

Line 13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'

13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13338: ELSE null

Line 13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'

13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13338: ELSE null
13339: END object_name

Line 13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'

13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13338: ELSE null
13339: END object_name
13340: , CASE r

Line 13435: , CE_XLA_EXT_HEADERS_V h1

13431:
13432: ELSE null
13433: END source_meaning
13434: FROM xla_events_gt xet
13435: , CE_XLA_EXT_HEADERS_V h1
13436: , fnd_lookup_values fvl22
13437: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
13438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13439: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;

13575: --
13576: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13577: --
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

13576: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13577: --
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;

13577: --
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;

13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

Line 13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;

13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;

13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;

Line 13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:

Line 13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;

13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13598:

Line 13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13598:
13599: l_array_source_1 t_array_source_1;

Line 13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13598:
13599: l_array_source_1 t_array_source_1;
13600: l_array_source_2 t_array_source_2;

Line 13669: , CE_XLA_EXT_HEADERS_V h1

13665: , fvl22.meaning source_22_meaning
13666: , h1.CF_CLEARED_AMOUNT source_23
13667: , h1.ACCOUNTING_DATE source_29
13668: FROM xla_events_gt xet
13669: , CE_XLA_EXT_HEADERS_V h1
13670: , fnd_lookup_values fvl22
13671: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
13672: and xet.event_class_code = C_EVENT_CLASS_CODE
13673: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id