29:
30: TYPE LegalEntity_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
31:
32: TYPE History_Rec IS RECORD (
33: SOURCE_TABLE XLE_HISTORIES.SOURCE_TABLE%TYPE,
34: SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
30: TYPE LegalEntity_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
31:
32: TYPE History_Rec IS RECORD (
33: SOURCE_TABLE XLE_HISTORIES.SOURCE_TABLE%TYPE,
34: SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38: EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
31:
32: TYPE History_Rec IS RECORD (
33: SOURCE_TABLE XLE_HISTORIES.SOURCE_TABLE%TYPE,
34: SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38: EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
39: COMMENTS XLE_HISTORIES.COMMENTS%TYPE
32: TYPE History_Rec IS RECORD (
33: SOURCE_TABLE XLE_HISTORIES.SOURCE_TABLE%TYPE,
34: SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38: EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
39: COMMENTS XLE_HISTORIES.COMMENTS%TYPE
40: );
33: SOURCE_TABLE XLE_HISTORIES.SOURCE_TABLE%TYPE,
34: SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38: EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
39: COMMENTS XLE_HISTORIES.COMMENTS%TYPE
40: );
41:
34: SOURCE_ID XLE_HISTORIES.SOURCE_ID%TYPE,
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38: EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
39: COMMENTS XLE_HISTORIES.COMMENTS%TYPE
40: );
41:
42: TYPE History_Tbl_Type IS TABLE OF History_Rec INDEX BY BINARY_INTEGER;
35: SOURCE_COLUMN_NAME XLE_HISTORIES.SOURCE_COLUMN_NAME%TYPE,
36: SOURCE_COLUMN_VALUE XLE_HISTORIES.SOURCE_COLUMN_VALUE%TYPE,
37: EFFECTIVE_FROM XLE_HISTORIES.EFFECTIVE_FROM%TYPE,
38: EFFECTIVE_TO XLE_HISTORIES.EFFECTIVE_TO%TYPE,
39: COMMENTS XLE_HISTORIES.COMMENTS%TYPE
40: );
41:
42: TYPE History_Tbl_Type IS TABLE OF History_Rec INDEX BY BINARY_INTEGER;
43: