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_LINES_V

Line 7937: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'

7933: FROM (
7934: SELECT xet.event_id event_id
7935: , l2.line_number line_number
7936: , CASE r
7937: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'

7934: SELECT xet.event_id event_id
7935: , l2.line_number line_number
7936: , CASE r
7937: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'

7935: , l2.line_number line_number
7936: , CASE r
7937: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'

7936: , CASE r
7937: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

7937: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

7938: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

7939: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'

7940: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'
7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'

7941: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'
7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'
7949: WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'

7942: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'
7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'
7949: WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_V'
7950:

Line 7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'

7943: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'
7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'
7949: WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_V'
7950:
7951: ELSE null

Line 7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'

7944: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'
7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'
7949: WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_V'
7950:
7951: ELSE null
7952: END object_name

Line 7949: WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_V'

7945: WHEN 9 THEN 'IGC_CC_EVENT_JE_LINES_V'
7946: WHEN 10 THEN 'IGC_CC_EVENT_JE_LINES_V'
7947: WHEN 11 THEN 'IGC_CC_EVENT_JE_LINES_V'
7948: WHEN 12 THEN 'IGC_CC_EVENT_JE_LINES_V'
7949: WHEN 13 THEN 'IGC_CC_EVENT_JE_LINES_V'
7950:
7951: ELSE null
7952: END object_name
7953: , CASE r

Line 8024: , IGC_CC_EVENT_JE_LINES_V l2

8020: ELSE null
8021: END source_value
8022: , null source_meaning
8023: FROM xla_events_gt xet
8024: , IGC_CC_EVENT_JE_LINES_V l2
8025: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
8026: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8027: AND xet.event_class_code = C_EVENT_CLASS_CODE
8028: AND l2.event_id = xet.event_id

Line 8166: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 8167: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 8168: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%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;
8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

8169: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

8170: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
8178: TYPE t_array_source_17 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

8171: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
8178: TYPE t_array_source_17 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
8179:

Line 8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

8172: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
8178: TYPE t_array_source_17 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
8179:
8180: l_array_source_2 t_array_source_2;

Line 8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

8173: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
8178: TYPE t_array_source_17 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
8179:
8180: l_array_source_2 t_array_source_2;
8181: l_array_source_3 t_array_source_3;

Line 8178: TYPE t_array_source_17 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

8174: TYPE t_array_source_13 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
8175: TYPE t_array_source_14 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
8176: TYPE t_array_source_15 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
8177: TYPE t_array_source_16 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
8178: TYPE t_array_source_17 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
8179:
8180: l_array_source_2 t_array_source_2;
8181: l_array_source_3 t_array_source_3;
8182: l_array_source_4 t_array_source_4;

Line 8288: , IGC_CC_EVENT_JE_LINES_V l2

8284: , l2.APPLIED_TO_ENTITY_CODE source_15
8285: , l2.APPLIED_TO_DIST_ID_1 source_16
8286: , l2.APPLIED_TO_HEADER_ID_1 source_17
8287: FROM xla_events_gt xet
8288: , IGC_CC_EVENT_JE_LINES_V l2
8289: WHERE xet.event_id between x_first_event_id and x_last_event_id
8290: and xet.event_date between p_pad_start_date and p_pad_end_date
8291: and xet.event_class_code = C_EVENT_CLASS_CODE
8292: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 9195: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'

9191: FROM (
9192: SELECT xet.event_id event_id
9193: , l2.line_number line_number
9194: , CASE r
9195: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'

9192: SELECT xet.event_id event_id
9193: , l2.line_number line_number
9194: , CASE r
9195: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'

9193: , l2.line_number line_number
9194: , CASE r
9195: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'

9194: , CASE r
9195: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
9202: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

9195: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
9202: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
9203:

Line 9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

9196: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
9202: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
9203:
9204: ELSE null

Line 9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

9197: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
9202: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
9203:
9204: ELSE null
9205: END object_name

Line 9202: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'

9198: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
9199: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
9200: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
9201: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
9202: WHEN 8 THEN 'IGC_CC_EVENT_JE_LINES_V'
9203:
9204: ELSE null
9205: END object_name
9206: , CASE r

Line 9257: , IGC_CC_EVENT_JE_LINES_V l2

9253: ELSE null
9254: END source_value
9255: , null source_meaning
9256: FROM xla_events_gt xet
9257: , IGC_CC_EVENT_JE_LINES_V l2
9258: , (select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
9259: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9260: AND xet.event_class_code = C_EVENT_CLASS_CODE
9261: AND l2.event_id = xet.event_id

Line 9399: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 9400: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 9401: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9406: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9406: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
9407:

Line 9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9406: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
9407:
9408: l_array_source_2 t_array_source_2;

Line 9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%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;
9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9406: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
9407:
9408: l_array_source_2 t_array_source_2;
9409: l_array_source_3 t_array_source_3;

Line 9406: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

9402: TYPE t_array_source_7 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.PROJECT_LINE%TYPE INDEX BY BINARY_INTEGER;
9403: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
9404: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
9405: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9406: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
9407:
9408: l_array_source_2 t_array_source_2;
9409: l_array_source_3 t_array_source_3;
9410: l_array_source_4 t_array_source_4;

Line 9506: , IGC_CC_EVENT_JE_LINES_V l2

9502: , l2.CC_FUNC_AMT source_10
9503: , l2.CURRENCY_CODE source_11
9504: , l2.CC_FUNC_DR_AMT source_12
9505: FROM xla_events_gt xet
9506: , IGC_CC_EVENT_JE_LINES_V l2
9507: WHERE xet.event_id between x_first_event_id and x_last_event_id
9508: and xet.event_date between p_pad_start_date and p_pad_end_date
9509: and xet.event_class_code = C_EVENT_CLASS_CODE
9510: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 10403: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'

10399: FROM (
10400: SELECT xet.event_id event_id
10401: , l2.line_number line_number
10402: , CASE r
10403: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'

10400: SELECT xet.event_id event_id
10401: , l2.line_number line_number
10402: , CASE r
10403: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'

10401: , l2.line_number line_number
10402: , CASE r
10403: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
10409: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'

10402: , CASE r
10403: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
10409: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
10410:

Line 10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

10403: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
10409: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
10410:
10411: ELSE null

Line 10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

10404: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
10409: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
10410:
10411: ELSE null
10412: END object_name

Line 10409: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

10405: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
10406: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
10407: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
10408: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
10409: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
10410:
10411: ELSE null
10412: END object_name
10413: , CASE r

Line 10460: , IGC_CC_EVENT_JE_LINES_V l2

10456: ELSE null
10457: END source_value
10458: , null source_meaning
10459: FROM xla_events_gt xet
10460: , IGC_CC_EVENT_JE_LINES_V l2
10461: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
10462: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10463: AND xet.event_class_code = C_EVENT_CLASS_CODE
10464: AND l2.event_id = xet.event_id

Line 10602: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 10603: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 10604: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10608: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10608: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
10609:

Line 10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10608: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
10609:
10610: l_array_source_2 t_array_source_2;

Line 10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10608: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
10609:
10610: l_array_source_2 t_array_source_2;
10611: l_array_source_3 t_array_source_3;

Line 10608: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%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;
10605: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
10606: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
10607: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10608: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
10609:
10610: l_array_source_2 t_array_source_2;
10611: l_array_source_3 t_array_source_3;
10612: l_array_source_4 t_array_source_4;

Line 10706: , IGC_CC_EVENT_JE_LINES_V l2

10702: , l2.CC_FUNC_AMT source_10
10703: , l2.CURRENCY_CODE source_11
10704: , l2.CC_FUNC_DR_AMT source_12
10705: FROM xla_events_gt xet
10706: , IGC_CC_EVENT_JE_LINES_V l2
10707: WHERE xet.event_id between x_first_event_id and x_last_event_id
10708: and xet.event_date between p_pad_start_date and p_pad_end_date
10709: and xet.event_class_code = C_EVENT_CLASS_CODE
10710: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 11548: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'

11544: FROM (
11545: SELECT xet.event_id event_id
11546: , l2.line_number line_number
11547: , CASE r
11548: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'

11545: SELECT xet.event_id event_id
11546: , l2.line_number line_number
11547: , CASE r
11548: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'

11546: , l2.line_number line_number
11547: , CASE r
11548: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
11554: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'

11547: , CASE r
11548: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
11554: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
11555:

Line 11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

11548: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
11554: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
11555:
11556: ELSE null

Line 11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

11549: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
11554: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
11555:
11556: ELSE null
11557: END object_name

Line 11554: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

11550: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
11551: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
11552: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
11553: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
11554: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
11555:
11556: ELSE null
11557: END object_name
11558: , CASE r

Line 11605: , IGC_CC_EVENT_JE_LINES_V l2

11601: ELSE null
11602: END source_value
11603: , null source_meaning
11604: FROM xla_events_gt xet
11605: , IGC_CC_EVENT_JE_LINES_V l2
11606: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
11607: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11608: AND xet.event_class_code = C_EVENT_CLASS_CODE
11609: AND l2.event_id = xet.event_id

Line 11747: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 11748: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 11749: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11753: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11753: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
11754:

Line 11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11753: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
11754:
11755: l_array_source_2 t_array_source_2;

Line 11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11753: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
11754:
11755: l_array_source_2 t_array_source_2;
11756: l_array_source_3 t_array_source_3;

Line 11753: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%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;
11750: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
11751: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
11752: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11753: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
11754:
11755: l_array_source_2 t_array_source_2;
11756: l_array_source_3 t_array_source_3;
11757: l_array_source_4 t_array_source_4;

Line 11851: , IGC_CC_EVENT_JE_LINES_V l2

11847: , l2.CC_FUNC_AMT source_10
11848: , l2.CURRENCY_CODE source_11
11849: , l2.CC_FUNC_DR_AMT source_12
11850: FROM xla_events_gt xet
11851: , IGC_CC_EVENT_JE_LINES_V l2
11852: WHERE xet.event_id between x_first_event_id and x_last_event_id
11853: and xet.event_date between p_pad_start_date and p_pad_end_date
11854: and xet.event_class_code = C_EVENT_CLASS_CODE
11855: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 12693: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'

12689: FROM (
12690: SELECT xet.event_id event_id
12691: , l2.line_number line_number
12692: , CASE r
12693: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'

12690: SELECT xet.event_id event_id
12691: , l2.line_number line_number
12692: , CASE r
12693: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'

12691: , l2.line_number line_number
12692: , CASE r
12693: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
12699: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

Line 12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'

12692: , CASE r
12693: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
12699: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
12700:

Line 12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'

12693: WHEN 1 THEN 'IGC_CC_EVENT_JE_LINES_V'
12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
12699: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
12700:
12701: ELSE null

Line 12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'

12694: WHEN 2 THEN 'IGC_CC_EVENT_JE_LINES_V'
12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
12699: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
12700:
12701: ELSE null
12702: END object_name

Line 12699: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'

12695: WHEN 3 THEN 'IGC_CC_EVENT_JE_LINES_V'
12696: WHEN 4 THEN 'IGC_CC_EVENT_JE_LINES_V'
12697: WHEN 5 THEN 'IGC_CC_EVENT_JE_LINES_V'
12698: WHEN 6 THEN 'IGC_CC_EVENT_JE_LINES_V'
12699: WHEN 7 THEN 'IGC_CC_EVENT_JE_LINES_V'
12700:
12701: ELSE null
12702: END object_name
12703: , CASE r

Line 12750: , IGC_CC_EVENT_JE_LINES_V l2

12746: ELSE null
12747: END source_value
12748: , null source_meaning
12749: FROM xla_events_gt xet
12750: , IGC_CC_EVENT_JE_LINES_V l2
12751: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
12752: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12753: AND xet.event_class_code = C_EVENT_CLASS_CODE
12754: AND l2.event_id = xet.event_id

Line 12892: TYPE t_array_source_1 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.TRANSACTION_DESCRIPTION%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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 12893: TYPE t_array_source_5 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CODE_COMBINATION_ID%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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 12894: TYPE t_array_source_6 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_CR_AMT%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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12898: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12898: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
12899:

Line 12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;

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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12898: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
12899:
12900: l_array_source_2 t_array_source_2;

Line 12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12898: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
12899:
12900: l_array_source_2 t_array_source_2;
12901: l_array_source_3 t_array_source_3;

Line 12898: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%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;
12895: TYPE t_array_source_8 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_ACCT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
12896: TYPE t_array_source_10 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_AMT%TYPE INDEX BY BINARY_INTEGER;
12897: TYPE t_array_source_11 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
12898: TYPE t_array_source_12 IS TABLE OF IGC_CC_EVENT_JE_LINES_V.CC_FUNC_DR_AMT%TYPE INDEX BY BINARY_INTEGER;
12899:
12900: l_array_source_2 t_array_source_2;
12901: l_array_source_3 t_array_source_3;
12902: l_array_source_4 t_array_source_4;

Line 12996: , IGC_CC_EVENT_JE_LINES_V l2

12992: , l2.CC_FUNC_AMT source_10
12993: , l2.CURRENCY_CODE source_11
12994: , l2.CC_FUNC_DR_AMT source_12
12995: FROM xla_events_gt xet
12996: , IGC_CC_EVENT_JE_LINES_V l2
12997: WHERE xet.event_id between x_first_event_id and x_last_event_id
12998: and xet.event_date between p_pad_start_date and p_pad_end_date
12999: and xet.event_class_code = C_EVENT_CLASS_CODE
13000: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id