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_08407_AAD_S_000013_BC_PKG dependencies on IGC_CC_EVENT_JE_HEADER_V

Line 7819: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'

7815: FROM (
7816: SELECT xet.event_id event_id
7817: , 0 line_number
7818: , CASE r
7819: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7820: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7821: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7822: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7823: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

Line 7820: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'

7816: SELECT xet.event_id event_id
7817: , 0 line_number
7818: , CASE r
7819: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7820: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7821: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7822: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7823: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7824:

Line 7821: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'

7817: , 0 line_number
7818: , CASE r
7819: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7820: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7821: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7822: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7823: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7824:
7825: ELSE null

Line 7822: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'

7818: , CASE r
7819: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7820: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7821: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7822: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7823: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7824:
7825: ELSE null
7826: END object_name

Line 7823: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

7819: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7820: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7821: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7822: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7823: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
7824:
7825: ELSE null
7826: END object_name
7827: , CASE r

Line 7866: , IGC_CC_EVENT_JE_HEADER_V h1

7862: ELSE null
7863: END source_value
7864: , null source_meaning
7865: FROM xla_events_gt xet
7866: , IGC_CC_EVENT_JE_HEADER_V h1
7867: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
7868: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7869: AND xet.event_class_code = C_EVENT_CLASS_CODE
7870: AND h1.event_id = xet.event_id

Line 8160: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;

8156: --
8157: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8158: --
8159:
8160: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
8161: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
8162: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
8163: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
8164: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 8161: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;

8157: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8158: --
8159:
8160: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
8161: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
8162: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
8163: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
8164: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
8165:

Line 8162: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;

8158: --
8159:
8160: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
8161: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
8162: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
8163: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
8164: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
8165:
8166: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 8163: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

8159:
8160: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
8161: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
8162: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
8163: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
8164: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
8165:
8166: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
8167: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 8164: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

8160: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
8161: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
8162: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
8163: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
8164: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
8165:
8166: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
8167: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
8168: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 8235: , IGC_CC_EVENT_JE_HEADER_V h1

8231: , h1.REFERENCE_3 source_4
8232: , h1.DOCUMENT_TYPE source_9
8233: , h1.ACCOUNTING_DATE source_18
8234: FROM xla_events_gt xet
8235: , IGC_CC_EVENT_JE_HEADER_V h1
8236: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8237: and xet.event_class_code = C_EVENT_CLASS_CODE
8238: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
8239:

Line 9077: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'

9073: FROM (
9074: SELECT xet.event_id event_id
9075: , 0 line_number
9076: , CASE r
9077: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9078: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9079: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9080: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9081: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

Line 9078: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'

9074: SELECT xet.event_id event_id
9075: , 0 line_number
9076: , CASE r
9077: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9078: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9079: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9080: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9081: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9082:

Line 9079: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'

9075: , 0 line_number
9076: , CASE r
9077: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9078: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9079: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9080: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9081: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9082:
9083: ELSE null

Line 9080: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'

9076: , CASE r
9077: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9078: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9079: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9080: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9081: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9082:
9083: ELSE null
9084: END object_name

Line 9081: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

9077: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9078: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9079: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9080: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9081: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
9082:
9083: ELSE null
9084: END object_name
9085: , CASE r

Line 9124: , IGC_CC_EVENT_JE_HEADER_V h1

9120: ELSE null
9121: END source_value
9122: , null source_meaning
9123: FROM xla_events_gt xet
9124: , IGC_CC_EVENT_JE_HEADER_V h1
9125: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
9126: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9127: AND xet.event_class_code = C_EVENT_CLASS_CODE
9128: AND h1.event_id = xet.event_id

Line 9393: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;

9389: --
9390: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
9391: --
9392:
9393: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
9394: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
9395: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
9396: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
9397: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 9394: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;

9390: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
9391: --
9392:
9393: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
9394: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
9395: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
9396: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
9397: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
9398:

Line 9395: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;

9391: --
9392:
9393: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
9394: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
9395: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
9396: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
9397: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
9398:
9399: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 9396: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

9392:
9393: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
9394: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
9395: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
9396: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
9397: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
9398:
9399: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
9400: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 9397: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

9393: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
9394: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
9395: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
9396: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
9397: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
9398:
9399: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
9400: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
9401: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 9458: , IGC_CC_EVENT_JE_HEADER_V h1

9454: , h1.REFERENCE_3 source_4
9455: , h1.DOCUMENT_TYPE source_9
9456: , h1.ACCOUNTING_DATE source_18
9457: FROM xla_events_gt xet
9458: , IGC_CC_EVENT_JE_HEADER_V h1
9459: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
9460: and xet.event_class_code = C_EVENT_CLASS_CODE
9461: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
9462:

Line 10285: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'

10281: FROM (
10282: SELECT xet.event_id event_id
10283: , 0 line_number
10284: , CASE r
10285: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10286: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10287: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10288: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10289: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

Line 10286: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'

10282: SELECT xet.event_id event_id
10283: , 0 line_number
10284: , CASE r
10285: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10286: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10287: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10288: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10289: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10290:

Line 10287: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'

10283: , 0 line_number
10284: , CASE r
10285: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10286: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10287: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10288: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10289: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10290:
10291: ELSE null

Line 10288: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'

10284: , CASE r
10285: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10286: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10287: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10288: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10289: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10290:
10291: ELSE null
10292: END object_name

Line 10289: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

10285: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10286: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10287: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10288: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10289: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
10290:
10291: ELSE null
10292: END object_name
10293: , CASE r

Line 10332: , IGC_CC_EVENT_JE_HEADER_V h1

10328: ELSE null
10329: END source_value
10330: , null source_meaning
10331: FROM xla_events_gt xet
10332: , IGC_CC_EVENT_JE_HEADER_V h1
10333: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
10334: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10335: AND xet.event_class_code = C_EVENT_CLASS_CODE
10336: AND h1.event_id = xet.event_id

Line 10596: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;

10592: --
10593: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10594: --
10595:
10596: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
10597: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 10597: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;

10593: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10594: --
10595:
10596: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
10597: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10601:

Line 10598: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;

10594: --
10595:
10596: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
10597: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10601:
10602: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 10599: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

10595:
10596: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
10597: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10601:
10602: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
10603: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 10600: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

10596: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
10597: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
10598: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
10599: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
10600: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10601:
10602: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
10603: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
10604: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 10659: , IGC_CC_EVENT_JE_HEADER_V h1

10655: , h1.REFERENCE_3 source_4
10656: , h1.DOCUMENT_TYPE source_9
10657: , h1.ACCOUNTING_DATE source_18
10658: FROM xla_events_gt xet
10659: , IGC_CC_EVENT_JE_HEADER_V h1
10660: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10661: and xet.event_class_code = C_EVENT_CLASS_CODE
10662: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
10663:

Line 11430: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'

11426: FROM (
11427: SELECT xet.event_id event_id
11428: , 0 line_number
11429: , CASE r
11430: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11431: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11432: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11433: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11434: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

Line 11431: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'

11427: SELECT xet.event_id event_id
11428: , 0 line_number
11429: , CASE r
11430: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11431: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11432: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11433: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11434: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11435:

Line 11432: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'

11428: , 0 line_number
11429: , CASE r
11430: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11431: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11432: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11433: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11434: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11435:
11436: ELSE null

Line 11433: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'

11429: , CASE r
11430: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11431: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11432: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11433: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11434: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11435:
11436: ELSE null
11437: END object_name

Line 11434: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

11430: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11431: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11432: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11433: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11434: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
11435:
11436: ELSE null
11437: END object_name
11438: , CASE r

Line 11477: , IGC_CC_EVENT_JE_HEADER_V h1

11473: ELSE null
11474: END source_value
11475: , null source_meaning
11476: FROM xla_events_gt xet
11477: , IGC_CC_EVENT_JE_HEADER_V h1
11478: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
11479: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11480: AND xet.event_class_code = C_EVENT_CLASS_CODE
11481: AND h1.event_id = xet.event_id

Line 11741: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;

11737: --
11738: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
11739: --
11740:
11741: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
11742: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
11743: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
11744: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
11745: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 11742: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;

11738: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
11739: --
11740:
11741: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
11742: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
11743: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
11744: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
11745: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
11746:

Line 11743: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;

11739: --
11740:
11741: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
11742: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
11743: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
11744: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
11745: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
11746:
11747: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 11744: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

11740:
11741: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
11742: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
11743: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
11744: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
11745: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
11746:
11747: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
11748: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 11745: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

11741: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
11742: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
11743: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
11744: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
11745: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
11746:
11747: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
11748: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
11749: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 11804: , IGC_CC_EVENT_JE_HEADER_V h1

11800: , h1.REFERENCE_3 source_4
11801: , h1.DOCUMENT_TYPE source_9
11802: , h1.ACCOUNTING_DATE source_18
11803: FROM xla_events_gt xet
11804: , IGC_CC_EVENT_JE_HEADER_V h1
11805: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
11806: and xet.event_class_code = C_EVENT_CLASS_CODE
11807: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
11808:

Line 12575: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'

12571: FROM (
12572: SELECT xet.event_id event_id
12573: , 0 line_number
12574: , CASE r
12575: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12576: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12577: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12578: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12579: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

Line 12576: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'

12572: SELECT xet.event_id event_id
12573: , 0 line_number
12574: , CASE r
12575: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12576: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12577: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12578: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12579: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12580:

Line 12577: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'

12573: , 0 line_number
12574: , CASE r
12575: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12576: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12577: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12578: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12579: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12580:
12581: ELSE null

Line 12578: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'

12574: , CASE r
12575: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12576: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12577: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12578: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12579: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12580:
12581: ELSE null
12582: END object_name

Line 12579: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'

12575: WHEN 1 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12576: WHEN 2 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12577: WHEN 3 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12578: WHEN 4 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12579: WHEN 5 THEN 'IGC_CC_EVENT_JE_HEADER_V'
12580:
12581: ELSE null
12582: END object_name
12583: , CASE r

Line 12622: , IGC_CC_EVENT_JE_HEADER_V h1

12618: ELSE null
12619: END source_value
12620: , null source_meaning
12621: FROM xla_events_gt xet
12622: , IGC_CC_EVENT_JE_HEADER_V h1
12623: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
12624: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12625: AND xet.event_class_code = C_EVENT_CLASS_CODE
12626: AND h1.event_id = xet.event_id

Line 12886: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;

12882: --
12883: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12884: --
12885:
12886: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
12887: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
12888: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
12889: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
12890: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 12887: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;

12883: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12884: --
12885:
12886: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
12887: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
12888: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
12889: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
12890: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12891:

Line 12888: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;

12884: --
12885:
12886: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
12887: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
12888: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
12889: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
12890: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12891:
12892: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 12889: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

12885:
12886: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
12887: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
12888: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
12889: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
12890: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12891:
12892: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
12893: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12890: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

12886: TYPE t_array_source_2 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.HEADER_DESC%TYPE INDEX BY BINARY_INTEGER;
12887: TYPE t_array_source_3 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_4%TYPE INDEX BY BINARY_INTEGER;
12888: TYPE t_array_source_4 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.REFERENCE_3%TYPE INDEX BY BINARY_INTEGER;
12889: TYPE t_array_source_9 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.DOCUMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
12890: TYPE t_array_source_18 IS TABLE OF IGC_CC_EVENT_JE_HEADER_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12891:
12892: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
12893: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
12894: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 12949: , IGC_CC_EVENT_JE_HEADER_V h1

12945: , h1.REFERENCE_3 source_4
12946: , h1.DOCUMENT_TYPE source_9
12947: , h1.ACCOUNTING_DATE source_18
12948: FROM xla_events_gt xet
12949: , IGC_CC_EVENT_JE_HEADER_V h1
12950: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
12951: and xet.event_class_code = C_EVENT_CLASS_CODE
12952: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
12953: