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_00201_AAD_S_000004_BC_PKG dependencies on PO_REQ_EXTRACT_DETAIL_V

Line 52659: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52655: FROM (
52656: SELECT xet.event_id event_id
52657: , l2.line_number line_number
52658: , CASE r
52659: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'
52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52658: , CASE r
52659: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'
52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52659: WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'
52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52660: WHEN 2 THEN 'FV_XLA_PO_REF_V'
52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52661: WHEN 3 THEN 'FV_XLA_PO_REF_V'
52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52662: WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52663: WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52664: WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52665: WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52666: WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52667: WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'

Line 52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52668: WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'

Line 52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52669: WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'

Line 52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52670: WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52671: WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52672: WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52673: WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'

Line 52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52674: WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52681: WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52682:

Line 52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52675: WHEN 17 THEN 'PO_REQ_LINES_REF_V'
52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52681: WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52682:
52683: ELSE null

Line 52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52676: WHEN 18 THEN 'PO_REQ_LINES_REF_V'
52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52681: WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52682:
52683: ELSE null
52684: END object_name

Line 52681: WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'

52677: WHEN 19 THEN 'PO_REQ_LINES_REF_V'
52678: WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52679: WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52680: WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52681: WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'
52682:
52683: ELSE null
52684: END object_name
52685: , CASE r

Line 52797: , PO_REQ_EXTRACT_DETAIL_V l2

52793: END source_value
52794: , null source_meaning
52795: FROM xla_events_gt xet
52796: , FV_XLA_PO_REF_V l1
52797: , PO_REQ_EXTRACT_DETAIL_V l2
52798: , PO_REQ_LINES_REF_V l4
52799: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
52800: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52801: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 52940: TYPE t_array_source_3 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

52936: TYPE t_array_source_44 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.REQ_ID%TYPE INDEX BY BINARY_INTEGER;
52937: TYPE t_array_source_48 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52938: TYPE t_array_source_49 IS TABLE OF PO_REQ_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
52939:
52940: TYPE t_array_source_3 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

52939:
52940: TYPE t_array_source_3 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

52940: TYPE t_array_source_3 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

52941: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

52942: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

52943: TYPE t_array_source_9 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

52944: TYPE t_array_source_13 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

52945: TYPE t_array_source_15 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

52946: TYPE t_array_source_17 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

52947: TYPE t_array_source_21 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

Line 52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

52948: TYPE t_array_source_22 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

52949: TYPE t_array_source_23 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

52950: TYPE t_array_source_24 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

52951: TYPE t_array_source_25 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
52952: TYPE t_array_source_26 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
52953: TYPE t_array_source_27 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
52954: TYPE t_array_source_28 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

52955: TYPE t_array_source_31 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52962: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
52963:

Line 52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

52956: TYPE t_array_source_35 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52962: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
52963:
52964: l_array_source_5 t_array_source_5;

Line 52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

52957: TYPE t_array_source_36 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52962: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
52963:
52964: l_array_source_5 t_array_source_5;
52965: l_array_source_6 t_array_source_6;

Line 52962: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;

52958: TYPE t_array_source_37 IS TABLE OF PO_REQ_LINES_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
52959: TYPE t_array_source_43 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
52960: TYPE t_array_source_45 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
52961: TYPE t_array_source_46 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.REQ_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
52962: TYPE t_array_source_47 IS TABLE OF PO_REQ_EXTRACT_DETAIL_V.ADJUSTMENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
52963:
52964: l_array_source_5 t_array_source_5;
52965: l_array_source_6 t_array_source_6;
52966: l_array_source_44 t_array_source_44;

Line 53093: , PO_REQ_EXTRACT_DETAIL_V l2

53089: , l2.REQ_UPG_ENC_TYPE_ID source_46
53090: , l2.ADJUSTMENT_STATUS source_47
53091: FROM xla_events_gt xet
53092: , FV_XLA_PO_REF_V l1
53093: , PO_REQ_EXTRACT_DETAIL_V l2
53094: , PO_REQ_LINES_REF_V l4
53095: WHERE xet.event_id between x_first_event_id and x_last_event_id
53096: and xet.event_date between p_pad_start_date and p_pad_end_date
53097: and xet.event_class_code = C_EVENT_CLASS_CODE