eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_09000_AAD_S_000015_PKG dependencies on DPP_XLA_CLAIM_HEADERS_V

Line 7764: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7760: FROM (
7761: SELECT xet.event_id event_id
7762: , 0 line_number
7763: , CASE r
7764: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7761: SELECT xet.event_id event_id
7762: , 0 line_number
7763: , CASE r
7764: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7762: , 0 line_number
7763: , CASE r
7764: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7770: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7763: , CASE r
7764: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7770: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7771:

Line 7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7764: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7770: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7771:
7772: ELSE null

Line 7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7765: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7770: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7771:
7772: ELSE null
7773: END object_name

Line 7770: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'

7766: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7767: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7768: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7769: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7770: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
7771:
7772: ELSE null
7773: END object_name
7774: , CASE r

Line 7821: , DPP_XLA_CLAIM_HEADERS_V h1

7817: ELSE null
7818: END source_value
7819: , null source_meaning
7820: FROM xla_events_gt xet
7821: , DPP_XLA_CLAIM_HEADERS_V h1
7822: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
7823: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7824: AND xet.event_type_code = C_EVENT_TYPE_CODE
7825: AND h1.event_id = xet.event_id

Line 8081: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

8077: --
8078: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8079: --
8080:
8081: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

8078: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8079: --
8080:
8081: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;

8079: --
8080:
8081: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

8080:
8081: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:

Line 8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

8081: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

8082: TYPE t_array_source_6 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AR_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

8083: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
8084: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 8149: , DPP_XLA_CLAIM_HEADERS_V h1

8145: , h1.PARTY_ID source_14
8146: , h1.PARTY_SITE_ID source_15
8147: , h1.PARTY_TYPE source_16
8148: FROM xla_events_gt xet
8149: , DPP_XLA_CLAIM_HEADERS_V h1
8150: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8151: and xet.event_type_code = C_EVENT_TYPE_CODE
8152: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
8153:

Line 8958: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'

8954: FROM (
8955: SELECT xet.event_id event_id
8956: , 0 line_number
8957: , CASE r
8958: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'

8955: SELECT xet.event_id event_id
8956: , 0 line_number
8957: , CASE r
8958: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8963: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'

8956: , 0 line_number
8957: , CASE r
8958: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8963: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8964:

Line 8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'

8957: , CASE r
8958: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8963: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8964:
8965: ELSE null

Line 8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

8958: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8963: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8964:
8965: ELSE null
8966: END object_name

Line 8963: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

8959: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8960: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8961: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8962: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8963: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
8964:
8965: ELSE null
8966: END object_name
8967: , CASE r

Line 9010: , DPP_XLA_CLAIM_HEADERS_V h1

9006: ELSE null
9007: END source_value
9008: , null source_meaning
9009: FROM xla_events_gt xet
9010: , DPP_XLA_CLAIM_HEADERS_V h1
9011: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
9012: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9013: AND xet.event_type_code = C_EVENT_TYPE_CODE
9014: AND h1.event_id = xet.event_id

Line 9260: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

9256: --
9257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
9258: --
9259:
9260: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;

9257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
9258: --
9259:
9260: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

9258: --
9259:
9260: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:

Line 9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

9259:
9260: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

9260: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

9261: TYPE t_array_source_7 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_CONTRA_LIAB_CCID%TYPE INDEX BY BINARY_INTEGER;
9262: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9269: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 9321: , DPP_XLA_CLAIM_HEADERS_V h1

9317: , h1.PARTY_ID source_14
9318: , h1.PARTY_SITE_ID source_15
9319: , h1.PARTY_TYPE source_16
9320: FROM xla_events_gt xet
9321: , DPP_XLA_CLAIM_HEADERS_V h1
9322: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
9323: and xet.event_type_code = C_EVENT_TYPE_CODE
9324: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
9325:

Line 10121: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10117: FROM (
10118: SELECT xet.event_id event_id
10119: , 0 line_number
10120: , CASE r
10121: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10118: SELECT xet.event_id event_id
10119: , 0 line_number
10120: , CASE r
10121: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10119: , 0 line_number
10120: , CASE r
10121: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10127: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10120: , CASE r
10121: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10127: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10128:

Line 10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10121: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10127: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10128:
10129: ELSE null

Line 10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10122: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10127: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10128:
10129: ELSE null
10130: END object_name

Line 10127: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'

10123: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10124: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10125: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10126: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10127: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
10128:
10129: ELSE null
10130: END object_name
10131: , CASE r

Line 10178: , DPP_XLA_CLAIM_HEADERS_V h1

10174: ELSE null
10175: END source_value
10176: , null source_meaning
10177: FROM xla_events_gt xet
10178: , DPP_XLA_CLAIM_HEADERS_V h1
10179: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
10180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10181: AND xet.event_type_code = C_EVENT_TYPE_CODE
10182: AND h1.event_id = xet.event_id

Line 10438: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

10434: --
10435: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10436: --
10437:
10438: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;

10435: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10436: --
10437:
10438: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

10436: --
10437:
10438: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

10437:
10438: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:

Line 10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

10438: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

10439: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

10440: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
10441: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 10506: , DPP_XLA_CLAIM_HEADERS_V h1

10502: , h1.PARTY_ID source_14
10503: , h1.PARTY_SITE_ID source_15
10504: , h1.PARTY_TYPE source_16
10505: FROM xla_events_gt xet
10506: , DPP_XLA_CLAIM_HEADERS_V h1
10507: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10508: and xet.event_type_code = C_EVENT_TYPE_CODE
10509: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
10510:

Line 11315: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11311: FROM (
11312: SELECT xet.event_id event_id
11313: , 0 line_number
11314: , CASE r
11315: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11312: SELECT xet.event_id event_id
11313: , 0 line_number
11314: , CASE r
11315: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11313: , 0 line_number
11314: , CASE r
11315: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11321: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'

Line 11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11314: , CASE r
11315: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11321: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11322:

Line 11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11315: WHEN 1 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11321: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11322:
11323: ELSE null

Line 11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11316: WHEN 2 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11321: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11322:
11323: ELSE null
11324: END object_name

Line 11321: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'

11317: WHEN 3 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11318: WHEN 4 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11319: WHEN 5 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11320: WHEN 6 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11321: WHEN 7 THEN 'DPP_XLA_CLAIM_HEADERS_V'
11322:
11323: ELSE null
11324: END object_name
11325: , CASE r

Line 11372: , DPP_XLA_CLAIM_HEADERS_V h1

11368: ELSE null
11369: END source_value
11370: , null source_meaning
11371: FROM xla_events_gt xet
11372: , DPP_XLA_CLAIM_HEADERS_V h1
11373: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
11374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11375: AND xet.event_type_code = C_EVENT_TYPE_CODE
11376: AND h1.event_id = xet.event_id

Line 11632: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;

11628: --
11629: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
11630: --
11631:
11632: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

Line 11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;

11629: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
11630: --
11631:
11632: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

11630: --
11631:
11632: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

11631:
11632: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:

Line 11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;

11632: TYPE t_array_source_1 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_TXN_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

11633: TYPE t_array_source_4 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_ACCRUAL_CCID%TYPE INDEX BY BINARY_INTEGER;
11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

11634: TYPE t_array_source_5 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PP_AP_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
11635: TYPE t_array_source_10 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 11700: , DPP_XLA_CLAIM_HEADERS_V h1

11696: , h1.PARTY_ID source_14
11697: , h1.PARTY_SITE_ID source_15
11698: , h1.PARTY_TYPE source_16
11699: FROM xla_events_gt xet
11700: , DPP_XLA_CLAIM_HEADERS_V h1
11701: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
11702: and xet.event_type_code = C_EVENT_TYPE_CODE
11703: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
11704: