APPS.XLA_00540_AAD_S_000014_PKG dependencies on OKL_CMN_EXTRACT_HDR_V

Line 15333: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

15329: FROM (
15330: SELECT xet.event_id event_id
15331: , 0 line_number
15332: , CASE r
15333: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

15330: SELECT xet.event_id event_id
15331: , 0 line_number
15332: , CASE r
15333: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

15331: , 0 line_number
15332: , CASE r
15333: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'

Line 15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

15332: , CASE r
15333: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

15333: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
15341: WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

15334: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
15335: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
15341: WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'
15342:

Line 15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

15336: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
15341: WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'
15342:
15343: ELSE null
15344: END object_name

Line 15341: WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'

15337: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
15338: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
15339: WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
15340: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
15341: WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'
15342:
15343: ELSE null
15344: END object_name
15345: , CASE r

Line 15400: , OKL_CMN_EXTRACT_HDR_V h1

15396: ELSE null
15397: END source_value
15398: , null source_meaning
15399: FROM xla_events_gt xet
15400: , OKL_CMN_EXTRACT_HDR_V h1
15401: , OKL_SHR_EXTRACT_HDR_V h3
15402: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
15403: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
15404: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

15660: --
15661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
15662: --
15663:
15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

15661: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
15662: --
15663:
15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

15662: --
15663:
15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

15663:
15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

15664: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

15665: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
15666: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:

Line 15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

15667: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

15668: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
15669: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15670: TYPE t_array_source_14 IS TABLE OF OKL_SHR_EXTRACT_HDR_V.TCN_ACCRUAL_REVERSAL_DATE%TYPE INDEX BY BINARY_INTEGER;
15671: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
15672: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15673:
15674: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
15675: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
15676: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15736: , OKL_CMN_EXTRACT_HDR_V h1

15732: , h3.TCN_ACCRUAL_REVERSAL_DATE source_14
15733: , h1.GL_DATE source_15
15734: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
15735: FROM xla_events_gt xet
15736: , OKL_CMN_EXTRACT_HDR_V h1
15737: , OKL_SHR_EXTRACT_HDR_V h3
15738: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
15739: and xet.event_class_code = C_EVENT_CLASS_CODE
15740: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 16586: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

16582: FROM (
16583: SELECT xet.event_id event_id
16584: , 0 line_number
16585: , CASE r
16586: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

16583: SELECT xet.event_id event_id
16584: , 0 line_number
16585: , CASE r
16586: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

16584: , 0 line_number
16585: , CASE r
16586: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

16585: , CASE r
16586: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
16593: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

16586: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
16593: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
16594:

Line 16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

16587: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
16593: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
16594:
16595: ELSE null

Line 16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

16588: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
16593: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
16594:
16595: ELSE null
16596: END object_name

Line 16593: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

16589: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
16590: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
16591: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
16592: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
16593: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
16594:
16595: ELSE null
16596: END object_name
16597: , CASE r

Line 16648: , OKL_CMN_EXTRACT_HDR_V h1

16644: ELSE null
16645: END source_value
16646: , null source_meaning
16647: FROM xla_events_gt xet
16648: , OKL_CMN_EXTRACT_HDR_V h1
16649: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
16650: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
16651: AND xet.event_class_code = C_EVENT_CLASS_CODE
16652: AND h1.event_id = xet.event_id

Line 16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

16907: --
16908: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
16909: --
16910:
16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

16908: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
16909: --
16910:
16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

16909: --
16910:
16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

16910:
16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

16911: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:

Line 16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

16912: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

16913: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

16914: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
16915: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
16916: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16917: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
16918: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
16919:
16920: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16921: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16922: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 16980: , OKL_CMN_EXTRACT_HDR_V h1

16976: , h1.TCN_CURR_CONVERSION_TYPE source_13
16977: , h1.GL_DATE source_15
16978: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
16979: FROM xla_events_gt xet
16980: , OKL_CMN_EXTRACT_HDR_V h1
16981: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
16982: and xet.event_class_code = C_EVENT_CLASS_CODE
16983: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
16984:

Line 17771: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

17767: FROM (
17768: SELECT xet.event_id event_id
17769: , 0 line_number
17770: , CASE r
17771: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

17768: SELECT xet.event_id event_id
17769: , 0 line_number
17770: , CASE r
17771: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

17769: , 0 line_number
17770: , CASE r
17771: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

17770: , CASE r
17771: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
17778: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

17771: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
17778: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
17779:

Line 17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

17772: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
17778: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
17779:
17780: ELSE null

Line 17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

17773: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
17778: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
17779:
17780: ELSE null
17781: END object_name

Line 17778: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

17774: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
17775: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
17776: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
17777: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
17778: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
17779:
17780: ELSE null
17781: END object_name
17782: , CASE r

Line 17833: , OKL_CMN_EXTRACT_HDR_V h1

17829: ELSE null
17830: END source_value
17831: , null source_meaning
17832: FROM xla_events_gt xet
17833: , OKL_CMN_EXTRACT_HDR_V h1
17834: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
17835: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
17836: AND xet.event_class_code = C_EVENT_CLASS_CODE
17837: AND h1.event_id = xet.event_id

Line 18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

18092: --
18093: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
18094: --
18095:
18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

18093: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
18094: --
18095:
18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

18094: --
18095:
18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

18095:
18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

18096: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:

Line 18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

18097: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

18098: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

18099: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
18100: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
18101: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18102: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
18103: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
18104:
18105: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18106: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18107: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 18165: , OKL_CMN_EXTRACT_HDR_V h1

18161: , h1.TCN_CURR_CONVERSION_TYPE source_13
18162: , h1.GL_DATE source_15
18163: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
18164: FROM xla_events_gt xet
18165: , OKL_CMN_EXTRACT_HDR_V h1
18166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
18167: and xet.event_class_code = C_EVENT_CLASS_CODE
18168: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
18169:

Line 18956: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

18952: FROM (
18953: SELECT xet.event_id event_id
18954: , 0 line_number
18955: , CASE r
18956: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

18953: SELECT xet.event_id event_id
18954: , 0 line_number
18955: , CASE r
18956: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

18954: , 0 line_number
18955: , CASE r
18956: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

18955: , CASE r
18956: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
18963: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

18956: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
18963: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
18964:

Line 18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

18957: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
18963: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
18964:
18965: ELSE null

Line 18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

18958: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
18963: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
18964:
18965: ELSE null
18966: END object_name

Line 18963: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

18959: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
18960: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
18961: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
18962: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
18963: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
18964:
18965: ELSE null
18966: END object_name
18967: , CASE r

Line 19018: , OKL_CMN_EXTRACT_HDR_V h1

19014: ELSE null
19015: END source_value
19016: , null source_meaning
19017: FROM xla_events_gt xet
19018: , OKL_CMN_EXTRACT_HDR_V h1
19019: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
19020: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
19021: AND xet.event_class_code = C_EVENT_CLASS_CODE
19022: AND h1.event_id = xet.event_id

Line 19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

19277: --
19278: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
19279: --
19280:
19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

19278: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
19279: --
19280:
19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

19279: --
19280:
19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

19280:
19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

19281: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:

Line 19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

19282: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

19283: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

19284: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
19285: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
19286: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19287: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
19288: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19289:
19290: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
19291: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19292: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 19350: , OKL_CMN_EXTRACT_HDR_V h1

19346: , h1.TCN_CURR_CONVERSION_TYPE source_13
19347: , h1.GL_DATE source_15
19348: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
19349: FROM xla_events_gt xet
19350: , OKL_CMN_EXTRACT_HDR_V h1
19351: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
19352: and xet.event_class_code = C_EVENT_CLASS_CODE
19353: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
19354:

Line 20141: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

20137: FROM (
20138: SELECT xet.event_id event_id
20139: , 0 line_number
20140: , CASE r
20141: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

20138: SELECT xet.event_id event_id
20139: , 0 line_number
20140: , CASE r
20141: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

20139: , 0 line_number
20140: , CASE r
20141: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

20140: , CASE r
20141: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
20148: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

20141: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
20148: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
20149:

Line 20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

20142: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
20148: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
20149:
20150: ELSE null

Line 20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

20143: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
20148: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
20149:
20150: ELSE null
20151: END object_name

Line 20148: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

20144: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
20145: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
20146: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
20147: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
20148: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
20149:
20150: ELSE null
20151: END object_name
20152: , CASE r

Line 20203: , OKL_CMN_EXTRACT_HDR_V h1

20199: ELSE null
20200: END source_value
20201: , null source_meaning
20202: FROM xla_events_gt xet
20203: , OKL_CMN_EXTRACT_HDR_V h1
20204: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
20205: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20206: AND xet.event_class_code = C_EVENT_CLASS_CODE
20207: AND h1.event_id = xet.event_id

Line 20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

20462: --
20463: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
20464: --
20465:
20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

20463: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
20464: --
20465:
20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

20464: --
20465:
20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

20465:
20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

20466: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:

Line 20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

20467: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

20468: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

20469: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
20470: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
20471: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20472: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
20473: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20474:
20475: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
20476: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20477: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 20535: , OKL_CMN_EXTRACT_HDR_V h1

20531: , h1.TCN_CURR_CONVERSION_TYPE source_13
20532: , h1.GL_DATE source_15
20533: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
20534: FROM xla_events_gt xet
20535: , OKL_CMN_EXTRACT_HDR_V h1
20536: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
20537: and xet.event_class_code = C_EVENT_CLASS_CODE
20538: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
20539:

Line 22511: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

22507: FROM (
22508: SELECT xet.event_id event_id
22509: , 0 line_number
22510: , CASE r
22511: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

22508: SELECT xet.event_id event_id
22509: , 0 line_number
22510: , CASE r
22511: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

22509: , 0 line_number
22510: , CASE r
22511: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

22510: , CASE r
22511: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
22518: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

22511: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
22518: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
22519:

Line 22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

22512: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
22518: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
22519:
22520: ELSE null

Line 22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

22513: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
22518: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
22519:
22520: ELSE null
22521: END object_name

Line 22518: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

22514: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
22515: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
22516: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
22517: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
22518: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
22519:
22520: ELSE null
22521: END object_name
22522: , CASE r

Line 22573: , OKL_CMN_EXTRACT_HDR_V h1

22569: ELSE null
22570: END source_value
22571: , null source_meaning
22572: FROM xla_events_gt xet
22573: , OKL_CMN_EXTRACT_HDR_V h1
22574: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
22575: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
22576: AND xet.event_class_code = C_EVENT_CLASS_CODE
22577: AND h1.event_id = xet.event_id

Line 22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

22832: --
22833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
22834: --
22835:
22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

22833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
22834: --
22835:
22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

22834: --
22835:
22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

22835:
22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

22836: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:

Line 22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

22837: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

22838: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

22839: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
22840: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
22841: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
22842: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
22843: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
22844:
22845: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
22846: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
22847: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 22905: , OKL_CMN_EXTRACT_HDR_V h1

22901: , h1.TCN_CURR_CONVERSION_TYPE source_13
22902: , h1.GL_DATE source_15
22903: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
22904: FROM xla_events_gt xet
22905: , OKL_CMN_EXTRACT_HDR_V h1
22906: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22907: and xet.event_class_code = C_EVENT_CLASS_CODE
22908: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
22909:

Line 23696: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

23692: FROM (
23693: SELECT xet.event_id event_id
23694: , 0 line_number
23695: , CASE r
23696: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

23693: SELECT xet.event_id event_id
23694: , 0 line_number
23695: , CASE r
23696: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

23694: , 0 line_number
23695: , CASE r
23696: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

23695: , CASE r
23696: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
23703: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

23696: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
23703: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
23704:

Line 23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

23697: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
23703: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
23704:
23705: ELSE null

Line 23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

23698: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
23703: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
23704:
23705: ELSE null
23706: END object_name

Line 23703: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

23699: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
23700: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
23701: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
23702: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
23703: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
23704:
23705: ELSE null
23706: END object_name
23707: , CASE r

Line 23758: , OKL_CMN_EXTRACT_HDR_V h1

23754: ELSE null
23755: END source_value
23756: , null source_meaning
23757: FROM xla_events_gt xet
23758: , OKL_CMN_EXTRACT_HDR_V h1
23759: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
23760: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
23761: AND xet.event_class_code = C_EVENT_CLASS_CODE
23762: AND h1.event_id = xet.event_id

Line 24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

24017: --
24018: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
24019: --
24020:
24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

24018: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
24019: --
24020:
24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

24019: --
24020:
24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

24020:
24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

24021: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:

Line 24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

24022: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

24023: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

24024: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
24025: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
24026: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24027: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
24028: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
24029:
24030: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24031: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24032: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 24090: , OKL_CMN_EXTRACT_HDR_V h1

24086: , h1.TCN_CURR_CONVERSION_TYPE source_13
24087: , h1.GL_DATE source_15
24088: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
24089: FROM xla_events_gt xet
24090: , OKL_CMN_EXTRACT_HDR_V h1
24091: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
24092: and xet.event_class_code = C_EVENT_CLASS_CODE
24093: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
24094:

Line 24881: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

24877: FROM (
24878: SELECT xet.event_id event_id
24879: , 0 line_number
24880: , CASE r
24881: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

24878: SELECT xet.event_id event_id
24879: , 0 line_number
24880: , CASE r
24881: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

24879: , 0 line_number
24880: , CASE r
24881: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

24880: , CASE r
24881: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
24888: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

24881: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
24888: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
24889:

Line 24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

24882: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
24888: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
24889:
24890: ELSE null

Line 24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

24883: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
24888: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
24889:
24890: ELSE null
24891: END object_name

Line 24888: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

24884: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
24885: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
24886: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
24887: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
24888: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
24889:
24890: ELSE null
24891: END object_name
24892: , CASE r

Line 24943: , OKL_CMN_EXTRACT_HDR_V h1

24939: ELSE null
24940: END source_value
24941: , null source_meaning
24942: FROM xla_events_gt xet
24943: , OKL_CMN_EXTRACT_HDR_V h1
24944: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
24945: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
24946: AND xet.event_class_code = C_EVENT_CLASS_CODE
24947: AND h1.event_id = xet.event_id

Line 25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

25202: --
25203: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
25204: --
25205:
25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

25203: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
25204: --
25205:
25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

25204: --
25205:
25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

25205:
25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

25206: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:

Line 25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

25207: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

25208: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

25209: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
25210: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
25211: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25212: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
25213: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
25214:
25215: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25216: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25217: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 25275: , OKL_CMN_EXTRACT_HDR_V h1

25271: , h1.TCN_CURR_CONVERSION_TYPE source_13
25272: , h1.GL_DATE source_15
25273: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
25274: FROM xla_events_gt xet
25275: , OKL_CMN_EXTRACT_HDR_V h1
25276: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
25277: and xet.event_class_code = C_EVENT_CLASS_CODE
25278: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
25279:

Line 26066: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

26062: FROM (
26063: SELECT xet.event_id event_id
26064: , 0 line_number
26065: , CASE r
26066: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

26063: SELECT xet.event_id event_id
26064: , 0 line_number
26065: , CASE r
26066: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

26064: , 0 line_number
26065: , CASE r
26066: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

26065: , CASE r
26066: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
26073: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

26066: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
26073: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
26074:

Line 26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

26067: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
26073: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
26074:
26075: ELSE null

Line 26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

26068: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
26073: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
26074:
26075: ELSE null
26076: END object_name

Line 26073: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

26069: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
26070: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
26071: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
26072: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
26073: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
26074:
26075: ELSE null
26076: END object_name
26077: , CASE r

Line 26128: , OKL_CMN_EXTRACT_HDR_V h1

26124: ELSE null
26125: END source_value
26126: , null source_meaning
26127: FROM xla_events_gt xet
26128: , OKL_CMN_EXTRACT_HDR_V h1
26129: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
26130: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
26131: AND xet.event_class_code = C_EVENT_CLASS_CODE
26132: AND h1.event_id = xet.event_id

Line 26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

26387: --
26388: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
26389: --
26390:
26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

26388: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
26389: --
26390:
26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

26389: --
26390:
26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

26390:
26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

26391: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:

Line 26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

26392: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

26393: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

26394: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
26395: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
26396: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26397: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
26398: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26399:
26400: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
26401: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26402: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 26460: , OKL_CMN_EXTRACT_HDR_V h1

26456: , h1.TCN_CURR_CONVERSION_TYPE source_13
26457: , h1.GL_DATE source_15
26458: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
26459: FROM xla_events_gt xet
26460: , OKL_CMN_EXTRACT_HDR_V h1
26461: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
26462: and xet.event_class_code = C_EVENT_CLASS_CODE
26463: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
26464:

Line 27251: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

27247: FROM (
27248: SELECT xet.event_id event_id
27249: , 0 line_number
27250: , CASE r
27251: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

27248: SELECT xet.event_id event_id
27249: , 0 line_number
27250: , CASE r
27251: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

27249: , 0 line_number
27250: , CASE r
27251: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

27250: , CASE r
27251: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
27258: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

27251: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
27258: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
27259:

Line 27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

27252: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
27258: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
27259:
27260: ELSE null

Line 27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

27253: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
27258: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
27259:
27260: ELSE null
27261: END object_name

Line 27258: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

27254: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
27255: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
27256: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
27257: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
27258: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
27259:
27260: ELSE null
27261: END object_name
27262: , CASE r

Line 27313: , OKL_CMN_EXTRACT_HDR_V h1

27309: ELSE null
27310: END source_value
27311: , null source_meaning
27312: FROM xla_events_gt xet
27313: , OKL_CMN_EXTRACT_HDR_V h1
27314: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
27315: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
27316: AND xet.event_class_code = C_EVENT_CLASS_CODE
27317: AND h1.event_id = xet.event_id

Line 27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

27572: --
27573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
27574: --
27575:
27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

27573: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
27574: --
27575:
27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

27574: --
27575:
27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

27575:
27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

27576: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:

Line 27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

27577: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

27578: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

27579: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
27580: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
27581: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
27582: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
27583: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
27584:
27585: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
27586: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
27587: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 27645: , OKL_CMN_EXTRACT_HDR_V h1

27641: , h1.TCN_CURR_CONVERSION_TYPE source_13
27642: , h1.GL_DATE source_15
27643: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
27644: FROM xla_events_gt xet
27645: , OKL_CMN_EXTRACT_HDR_V h1
27646: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
27647: and xet.event_class_code = C_EVENT_CLASS_CODE
27648: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
27649:

Line 28436: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

28432: FROM (
28433: SELECT xet.event_id event_id
28434: , 0 line_number
28435: , CASE r
28436: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

28433: SELECT xet.event_id event_id
28434: , 0 line_number
28435: , CASE r
28436: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

28434: , 0 line_number
28435: , CASE r
28436: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
28442: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

28435: , CASE r
28436: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
28442: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
28443:

Line 28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

28436: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
28442: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
28443:
28444: ELSE null

Line 28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

28437: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
28442: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
28443:
28444: ELSE null
28445: END object_name

Line 28442: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

28438: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
28439: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
28440: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
28441: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
28442: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
28443:
28444: ELSE null
28445: END object_name
28446: , CASE r

Line 28493: , OKL_CMN_EXTRACT_HDR_V h1

28489: ELSE null
28490: END source_value
28491: , null source_meaning
28492: FROM xla_events_gt xet
28493: , OKL_CMN_EXTRACT_HDR_V h1
28494: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
28495: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
28496: AND xet.event_class_code = C_EVENT_CLASS_CODE
28497: AND h1.event_id = xet.event_id

Line 28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

28752: --
28753: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
28754: --
28755:
28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

28753: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
28754: --
28755:
28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

28754: --
28755:
28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

28755:
28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:

Line 28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

28756: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

28757: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

28758: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
28759: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
28760: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
28761: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28762: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
28763:
28764: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
28765: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28766: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 28822: , OKL_CMN_EXTRACT_HDR_V h1

28818: , h1.TCN_CURR_CONVERSION_RATE source_12
28819: , h1.TCN_CURR_CONVERSION_TYPE source_13
28820: , h1.GL_DATE source_15
28821: FROM xla_events_gt xet
28822: , OKL_CMN_EXTRACT_HDR_V h1
28823: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
28824: and xet.event_class_code = C_EVENT_CLASS_CODE
28825: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
28826:

Line 29599: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

29595: FROM (
29596: SELECT xet.event_id event_id
29597: , 0 line_number
29598: , CASE r
29599: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

29596: SELECT xet.event_id event_id
29597: , 0 line_number
29598: , CASE r
29599: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

29597: , 0 line_number
29598: , CASE r
29599: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

29598: , CASE r
29599: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
29606: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

29599: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
29606: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
29607:

Line 29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

29600: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
29606: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
29607:
29608: ELSE null

Line 29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

29601: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
29606: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
29607:
29608: ELSE null
29609: END object_name

Line 29606: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

29602: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
29603: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
29604: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
29605: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
29606: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
29607:
29608: ELSE null
29609: END object_name
29610: , CASE r

Line 29661: , OKL_CMN_EXTRACT_HDR_V h1

29657: ELSE null
29658: END source_value
29659: , null source_meaning
29660: FROM xla_events_gt xet
29661: , OKL_CMN_EXTRACT_HDR_V h1
29662: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
29663: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29664: AND xet.event_class_code = C_EVENT_CLASS_CODE
29665: AND h1.event_id = xet.event_id

Line 29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

29920: --
29921: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
29922: --
29923:
29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

29921: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
29922: --
29923:
29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

29922: --
29923:
29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

29923:
29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

29924: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:

Line 29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

29925: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

29926: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

29927: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29928: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29929: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29930: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
29931: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29932:
29933: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
29934: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29935: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 29993: , OKL_CMN_EXTRACT_HDR_V h1

29989: , h1.TCN_CURR_CONVERSION_TYPE source_13
29990: , h1.GL_DATE source_15
29991: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
29992: FROM xla_events_gt xet
29993: , OKL_CMN_EXTRACT_HDR_V h1
29994: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
29995: and xet.event_class_code = C_EVENT_CLASS_CODE
29996: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
29997:

Line 30784: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'

30780: FROM (
30781: SELECT xet.event_id event_id
30782: , 0 line_number
30783: , CASE r
30784: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'

30781: SELECT xet.event_id event_id
30782: , 0 line_number
30783: , CASE r
30784: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'

30782: , 0 line_number
30783: , CASE r
30784: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'

30783: , CASE r
30784: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
30791: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

Line 30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'

30784: WHEN 1 THEN 'OKL_CMN_EXTRACT_HDR_V'
30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
30791: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
30792:

Line 30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'

30785: WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
30791: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
30792:
30793: ELSE null

Line 30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'

30786: WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
30791: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
30792:
30793: ELSE null
30794: END object_name

Line 30791: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'

30787: WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
30788: WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
30789: WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
30790: WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
30791: WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
30792:
30793: ELSE null
30794: END object_name
30795: , CASE r

Line 30846: , OKL_CMN_EXTRACT_HDR_V h1

30842: ELSE null
30843: END source_value
30844: , null source_meaning
30845: FROM xla_events_gt xet
30846: , OKL_CMN_EXTRACT_HDR_V h1
30847: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
30848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
30849: AND xet.event_class_code = C_EVENT_CLASS_CODE
30850: AND h1.event_id = xet.event_id

Line 31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

31105: --
31106: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
31107: --
31108:
31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;

31106: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
31107: --
31108:
31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

31107: --
31108:
31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

31108:
31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

31109: TYPE t_array_source_1 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TEH_CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:

Line 31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

31110: TYPE t_array_source_2 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CONTRACT_PRODUCT_NAME%TYPE INDEX BY BINARY_INTEGER;
31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

31111: TYPE t_array_source_10 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

31112: TYPE t_array_source_11 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31113: TYPE t_array_source_12 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31114: TYPE t_array_source_13 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_CURR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31115: TYPE t_array_source_15 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
31116: TYPE t_array_source_16 IS TABLE OF OKL_CMN_EXTRACT_HDR_V.TCN_ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
31117:
31118: TYPE t_array_source_5 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
31119: TYPE t_array_source_6 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_AE_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
31120: TYPE t_array_source_7 IS TABLE OF OKL_CMN_EXTRACT_LINE_V.DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31178: , OKL_CMN_EXTRACT_HDR_V h1

31174: , h1.TCN_CURR_CONVERSION_TYPE source_13
31175: , h1.GL_DATE source_15
31176: , h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
31177: FROM xla_events_gt xet
31178: , OKL_CMN_EXTRACT_HDR_V h1
31179: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
31180: and xet.event_class_code = C_EVENT_CLASS_CODE
31181: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
31182: