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.FA_XLA_CMP_SOURCES_PKG dependencies on FA_CHAR30_TBL_TYPE

Line 78: G_deprn_event_class_table fa_char30_tbl_type;

74:
75: G_initialized boolean := FALSE;
76:
77: -- deprn
78: G_deprn_event_class_table fa_char30_tbl_type;
79: G_known_deprn_hdr_tables fa_char30_tbl_type;
80: G_known_deprn_line_tables fa_char30_tbl_type;
81:
82: -- deferred

Line 79: G_known_deprn_hdr_tables fa_char30_tbl_type;

75: G_initialized boolean := FALSE;
76:
77: -- deprn
78: G_deprn_event_class_table fa_char30_tbl_type;
79: G_known_deprn_hdr_tables fa_char30_tbl_type;
80: G_known_deprn_line_tables fa_char30_tbl_type;
81:
82: -- deferred
83: G_def_event_class_table fa_char30_tbl_type;

Line 80: G_known_deprn_line_tables fa_char30_tbl_type;

76:
77: -- deprn
78: G_deprn_event_class_table fa_char30_tbl_type;
79: G_known_deprn_hdr_tables fa_char30_tbl_type;
80: G_known_deprn_line_tables fa_char30_tbl_type;
81:
82: -- deferred
83: G_def_event_class_table fa_char30_tbl_type;
84: G_known_def_hdr_tables fa_char30_tbl_type;

Line 83: G_def_event_class_table fa_char30_tbl_type;

79: G_known_deprn_hdr_tables fa_char30_tbl_type;
80: G_known_deprn_line_tables fa_char30_tbl_type;
81:
82: -- deferred
83: G_def_event_class_table fa_char30_tbl_type;
84: G_known_def_hdr_tables fa_char30_tbl_type;
85: G_known_def_line_tables fa_char30_tbl_type;
86:
87: -- transactions (header and statging)

Line 84: G_known_def_hdr_tables fa_char30_tbl_type;

80: G_known_deprn_line_tables fa_char30_tbl_type;
81:
82: -- deferred
83: G_def_event_class_table fa_char30_tbl_type;
84: G_known_def_hdr_tables fa_char30_tbl_type;
85: G_known_def_line_tables fa_char30_tbl_type;
86:
87: -- transactions (header and statging)
88: G_trx1_hdr_event_class_table fa_char30_tbl_type;

Line 85: G_known_def_line_tables fa_char30_tbl_type;

81:
82: -- deferred
83: G_def_event_class_table fa_char30_tbl_type;
84: G_known_def_hdr_tables fa_char30_tbl_type;
85: G_known_def_line_tables fa_char30_tbl_type;
86:
87: -- transactions (header and statging)
88: G_trx1_hdr_event_class_table fa_char30_tbl_type;
89: G_trx2_hdr_event_class_table fa_char30_tbl_type;

Line 88: G_trx1_hdr_event_class_table fa_char30_tbl_type;

84: G_known_def_hdr_tables fa_char30_tbl_type;
85: G_known_def_line_tables fa_char30_tbl_type;
86:
87: -- transactions (header and statging)
88: G_trx1_hdr_event_class_table fa_char30_tbl_type;
89: G_trx2_hdr_event_class_table fa_char30_tbl_type;
90: G_known_trx_hdr_tables fa_char30_tbl_type;
91: G_known_stg_tables fa_char30_tbl_type;
92:

Line 89: G_trx2_hdr_event_class_table fa_char30_tbl_type;

85: G_known_def_line_tables fa_char30_tbl_type;
86:
87: -- transactions (header and statging)
88: G_trx1_hdr_event_class_table fa_char30_tbl_type;
89: G_trx2_hdr_event_class_table fa_char30_tbl_type;
90: G_known_trx_hdr_tables fa_char30_tbl_type;
91: G_known_stg_tables fa_char30_tbl_type;
92:
93: -- line level event classes

Line 90: G_known_trx_hdr_tables fa_char30_tbl_type;

86:
87: -- transactions (header and statging)
88: G_trx1_hdr_event_class_table fa_char30_tbl_type;
89: G_trx2_hdr_event_class_table fa_char30_tbl_type;
90: G_known_trx_hdr_tables fa_char30_tbl_type;
91: G_known_stg_tables fa_char30_tbl_type;
92:
93: -- line level event classes
94: G_fin1_line_event_class_table fa_char30_tbl_type;

Line 91: G_known_stg_tables fa_char30_tbl_type;

87: -- transactions (header and statging)
88: G_trx1_hdr_event_class_table fa_char30_tbl_type;
89: G_trx2_hdr_event_class_table fa_char30_tbl_type;
90: G_known_trx_hdr_tables fa_char30_tbl_type;
91: G_known_stg_tables fa_char30_tbl_type;
92:
93: -- line level event classes
94: G_fin1_line_event_class_table fa_char30_tbl_type;
95: G_fin2_line_event_class_table fa_char30_tbl_type;

Line 94: G_fin1_line_event_class_table fa_char30_tbl_type;

90: G_known_trx_hdr_tables fa_char30_tbl_type;
91: G_known_stg_tables fa_char30_tbl_type;
92:
93: -- line level event classes
94: G_fin1_line_event_class_table fa_char30_tbl_type;
95: G_fin2_line_event_class_table fa_char30_tbl_type;
96: G_xfr_line_event_class_table fa_char30_tbl_type;
97: G_dist_line_event_class_table fa_char30_tbl_type;
98: G_ret_line_event_class_table fa_char30_tbl_type;

Line 95: G_fin2_line_event_class_table fa_char30_tbl_type;

91: G_known_stg_tables fa_char30_tbl_type;
92:
93: -- line level event classes
94: G_fin1_line_event_class_table fa_char30_tbl_type;
95: G_fin2_line_event_class_table fa_char30_tbl_type;
96: G_xfr_line_event_class_table fa_char30_tbl_type;
97: G_dist_line_event_class_table fa_char30_tbl_type;
98: G_ret_line_event_class_table fa_char30_tbl_type;
99:

Line 96: G_xfr_line_event_class_table fa_char30_tbl_type;

92:
93: -- line level event classes
94: G_fin1_line_event_class_table fa_char30_tbl_type;
95: G_fin2_line_event_class_table fa_char30_tbl_type;
96: G_xfr_line_event_class_table fa_char30_tbl_type;
97: G_dist_line_event_class_table fa_char30_tbl_type;
98: G_ret_line_event_class_table fa_char30_tbl_type;
99:
100: -- line level tables

Line 97: G_dist_line_event_class_table fa_char30_tbl_type;

93: -- line level event classes
94: G_fin1_line_event_class_table fa_char30_tbl_type;
95: G_fin2_line_event_class_table fa_char30_tbl_type;
96: G_xfr_line_event_class_table fa_char30_tbl_type;
97: G_dist_line_event_class_table fa_char30_tbl_type;
98: G_ret_line_event_class_table fa_char30_tbl_type;
99:
100: -- line level tables
101: G_known_fin1_line_tables fa_char30_tbl_type;

Line 98: G_ret_line_event_class_table fa_char30_tbl_type;

94: G_fin1_line_event_class_table fa_char30_tbl_type;
95: G_fin2_line_event_class_table fa_char30_tbl_type;
96: G_xfr_line_event_class_table fa_char30_tbl_type;
97: G_dist_line_event_class_table fa_char30_tbl_type;
98: G_ret_line_event_class_table fa_char30_tbl_type;
99:
100: -- line level tables
101: G_known_fin1_line_tables fa_char30_tbl_type;
102: G_known_fin2_line_tables fa_char30_tbl_type;

Line 101: G_known_fin1_line_tables fa_char30_tbl_type;

97: G_dist_line_event_class_table fa_char30_tbl_type;
98: G_ret_line_event_class_table fa_char30_tbl_type;
99:
100: -- line level tables
101: G_known_fin1_line_tables fa_char30_tbl_type;
102: G_known_fin2_line_tables fa_char30_tbl_type;
103: G_known_xfr_line_tables fa_char30_tbl_type;
104: G_known_dist1_line_tables fa_char30_tbl_type;
105: G_known_dist2_line_tables fa_char30_tbl_type;

Line 102: G_known_fin2_line_tables fa_char30_tbl_type;

98: G_ret_line_event_class_table fa_char30_tbl_type;
99:
100: -- line level tables
101: G_known_fin1_line_tables fa_char30_tbl_type;
102: G_known_fin2_line_tables fa_char30_tbl_type;
103: G_known_xfr_line_tables fa_char30_tbl_type;
104: G_known_dist1_line_tables fa_char30_tbl_type;
105: G_known_dist2_line_tables fa_char30_tbl_type;
106: G_known_ret_line_tables fa_char30_tbl_type;

Line 103: G_known_xfr_line_tables fa_char30_tbl_type;

99:
100: -- line level tables
101: G_known_fin1_line_tables fa_char30_tbl_type;
102: G_known_fin2_line_tables fa_char30_tbl_type;
103: G_known_xfr_line_tables fa_char30_tbl_type;
104: G_known_dist1_line_tables fa_char30_tbl_type;
105: G_known_dist2_line_tables fa_char30_tbl_type;
106: G_known_ret_line_tables fa_char30_tbl_type;
107:

Line 104: G_known_dist1_line_tables fa_char30_tbl_type;

100: -- line level tables
101: G_known_fin1_line_tables fa_char30_tbl_type;
102: G_known_fin2_line_tables fa_char30_tbl_type;
103: G_known_xfr_line_tables fa_char30_tbl_type;
104: G_known_dist1_line_tables fa_char30_tbl_type;
105: G_known_dist2_line_tables fa_char30_tbl_type;
106: G_known_ret_line_tables fa_char30_tbl_type;
107:
108: -- mls level tables

Line 105: G_known_dist2_line_tables fa_char30_tbl_type;

101: G_known_fin1_line_tables fa_char30_tbl_type;
102: G_known_fin2_line_tables fa_char30_tbl_type;
103: G_known_xfr_line_tables fa_char30_tbl_type;
104: G_known_dist1_line_tables fa_char30_tbl_type;
105: G_known_dist2_line_tables fa_char30_tbl_type;
106: G_known_ret_line_tables fa_char30_tbl_type;
107:
108: -- mls level tables
109: G_trx_mls_event_class_table fa_char30_tbl_type;

Line 106: G_known_ret_line_tables fa_char30_tbl_type;

102: G_known_fin2_line_tables fa_char30_tbl_type;
103: G_known_xfr_line_tables fa_char30_tbl_type;
104: G_known_dist1_line_tables fa_char30_tbl_type;
105: G_known_dist2_line_tables fa_char30_tbl_type;
106: G_known_ret_line_tables fa_char30_tbl_type;
107:
108: -- mls level tables
109: G_trx_mls_event_class_table fa_char30_tbl_type;
110: G_known_mls_tables fa_char30_tbl_type;

Line 109: G_trx_mls_event_class_table fa_char30_tbl_type;

105: G_known_dist2_line_tables fa_char30_tbl_type;
106: G_known_ret_line_tables fa_char30_tbl_type;
107:
108: -- mls level tables
109: G_trx_mls_event_class_table fa_char30_tbl_type;
110: G_known_mls_tables fa_char30_tbl_type;
111:
112: G_known_schemas fa_char30_tbl_type;
113:

Line 110: G_known_mls_tables fa_char30_tbl_type;

106: G_known_ret_line_tables fa_char30_tbl_type;
107:
108: -- mls level tables
109: G_trx_mls_event_class_table fa_char30_tbl_type;
110: G_known_mls_tables fa_char30_tbl_type;
111:
112: G_known_schemas fa_char30_tbl_type;
113:
114: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 112: G_known_schemas fa_char30_tbl_type;

108: -- mls level tables
109: G_trx_mls_event_class_table fa_char30_tbl_type;
110: G_known_mls_tables fa_char30_tbl_type;
111:
112: G_known_schemas fa_char30_tbl_type;
113:
114: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
115: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
116: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 900: Procedure AddMember (p_table IN OUT NOCOPY fa_char30_tbl_type,

896:
897: -- AddMember
898: -- Extends and Inserts a value into table
899:
900: Procedure AddMember (p_table IN OUT NOCOPY fa_char30_tbl_type,
901: p_value IN VARCHAR2)IS
902:
903: l_procedure_name varchar2(80) := 'AddMember';
904:

Line 977: G_known_schemas := fa_char30_tbl_type();

973: 'Beginning of procedure');
974: END IF;
975:
976: -- schemas
977: G_known_schemas := fa_char30_tbl_type();
978: AddMember(G_known_schemas, 'FA');
979: AddMember(G_known_schemas, 'GL');
980: AddMember(G_known_schemas, 'XLA');
981:

Line 984: G_deprn_event_class_table := fa_char30_tbl_type();

980: AddMember(G_known_schemas, 'XLA');
981:
982:
983: -- deprn (used for header and lines)
984: G_deprn_event_class_table := fa_char30_tbl_type();
985: AddMember(G_deprn_event_class_table, 'DEPRECIATION');
986:
987: G_known_deprn_hdr_tables := fa_char30_tbl_type();
988: G_known_deprn_line_tables := fa_char30_tbl_type();

Line 987: G_known_deprn_hdr_tables := fa_char30_tbl_type();

983: -- deprn (used for header and lines)
984: G_deprn_event_class_table := fa_char30_tbl_type();
985: AddMember(G_deprn_event_class_table, 'DEPRECIATION');
986:
987: G_known_deprn_hdr_tables := fa_char30_tbl_type();
988: G_known_deprn_line_tables := fa_char30_tbl_type();
989:
990: -- header
991: AddMember(G_known_deprn_hdr_tables, 'FA_BOOK_CONTROLS');

Line 988: G_known_deprn_line_tables := fa_char30_tbl_type();

984: G_deprn_event_class_table := fa_char30_tbl_type();
985: AddMember(G_deprn_event_class_table, 'DEPRECIATION');
986:
987: G_known_deprn_hdr_tables := fa_char30_tbl_type();
988: G_known_deprn_line_tables := fa_char30_tbl_type();
989:
990: -- header
991: AddMember(G_known_deprn_hdr_tables, 'FA_BOOK_CONTROLS');
992: AddMember(G_known_deprn_hdr_tables, 'FA_DEPRN_PERIODS');

Line 1017: G_def_event_class_table := fa_char30_tbl_type();

1013: AddMember(G_known_deprn_line_tables, 'FA_METHODS');
1014:
1015:
1016: -- deferred (used for header and lines)
1017: G_def_event_class_table := fa_char30_tbl_type();
1018: AddMember(G_def_event_class_table, 'DEFERRED_DEPRECIATION');
1019:
1020: -- deferred
1021: G_known_def_hdr_tables := fa_char30_tbl_type();

Line 1021: G_known_def_hdr_tables := fa_char30_tbl_type();

1017: G_def_event_class_table := fa_char30_tbl_type();
1018: AddMember(G_def_event_class_table, 'DEFERRED_DEPRECIATION');
1019:
1020: -- deferred
1021: G_known_def_hdr_tables := fa_char30_tbl_type();
1022: G_known_def_hdr_tables := G_known_deprn_hdr_tables;
1023: G_known_def_line_tables := fa_char30_tbl_type();
1024:
1025: -- standard

Line 1023: G_known_def_line_tables := fa_char30_tbl_type();

1019:
1020: -- deferred
1021: G_known_def_hdr_tables := fa_char30_tbl_type();
1022: G_known_def_hdr_tables := G_known_deprn_hdr_tables;
1023: G_known_def_line_tables := fa_char30_tbl_type();
1024:
1025: -- standard
1026: AddMember(G_known_def_line_tables, 'FA_ADDITIONS_B');
1027: AddMember(G_known_def_line_tables, 'FA_ASSET_HISTORY');

Line 1047: G_trx1_hdr_event_class_table := fa_char30_tbl_type();

1043:
1044:
1045: -- headers only
1046: -- transactions
1047: G_trx1_hdr_event_class_table := fa_char30_tbl_type();
1048:
1049: AddMember(G_trx1_hdr_event_class_table, 'ADDITIONS');
1050: AddMember(G_trx1_hdr_event_class_table, 'CIP_ADDITIONS');
1051: AddMember(G_trx1_hdr_event_class_table, 'ADJUSTMENTS');

Line 1071: G_trx2_hdr_event_class_table := fa_char30_tbl_type();

1067: AddMember(G_trx1_hdr_event_class_table, 'RETIREMENT_ADJUSTMENT');
1068:
1069: -- inter asset trxs
1070: -- used for staging and line
1071: G_trx2_hdr_event_class_table := fa_char30_tbl_type();
1072:
1073: AddMember(G_trx2_hdr_event_class_table, 'SOURCE_LINE_TRANSFERS');
1074: AddMember(G_trx2_hdr_event_class_table, 'CIP_SOURCE_LINE_TRANSFERS');
1075: AddMember(G_trx2_hdr_event_class_table, 'RESERVE_TRANSFERS');

Line 1079: G_fin1_line_event_class_table := fa_char30_tbl_type();

1075: AddMember(G_trx2_hdr_event_class_table, 'RESERVE_TRANSFERS');
1076:
1077:
1078: -- line level event classes
1079: G_fin1_line_event_class_table := fa_char30_tbl_type();
1080: G_fin2_line_event_class_table := fa_char30_tbl_type();
1081: G_xfr_line_event_class_table := fa_char30_tbl_type();
1082: G_dist_line_event_class_table := fa_char30_tbl_type();
1083: G_ret_line_event_class_table := fa_char30_tbl_type();

Line 1080: G_fin2_line_event_class_table := fa_char30_tbl_type();

1076:
1077:
1078: -- line level event classes
1079: G_fin1_line_event_class_table := fa_char30_tbl_type();
1080: G_fin2_line_event_class_table := fa_char30_tbl_type();
1081: G_xfr_line_event_class_table := fa_char30_tbl_type();
1082: G_dist_line_event_class_table := fa_char30_tbl_type();
1083: G_ret_line_event_class_table := fa_char30_tbl_type();
1084:

Line 1081: G_xfr_line_event_class_table := fa_char30_tbl_type();

1077:
1078: -- line level event classes
1079: G_fin1_line_event_class_table := fa_char30_tbl_type();
1080: G_fin2_line_event_class_table := fa_char30_tbl_type();
1081: G_xfr_line_event_class_table := fa_char30_tbl_type();
1082: G_dist_line_event_class_table := fa_char30_tbl_type();
1083: G_ret_line_event_class_table := fa_char30_tbl_type();
1084:
1085: AddMember(G_fin1_line_event_class_table, 'ADDITIONS');

Line 1082: G_dist_line_event_class_table := fa_char30_tbl_type();

1078: -- line level event classes
1079: G_fin1_line_event_class_table := fa_char30_tbl_type();
1080: G_fin2_line_event_class_table := fa_char30_tbl_type();
1081: G_xfr_line_event_class_table := fa_char30_tbl_type();
1082: G_dist_line_event_class_table := fa_char30_tbl_type();
1083: G_ret_line_event_class_table := fa_char30_tbl_type();
1084:
1085: AddMember(G_fin1_line_event_class_table, 'ADDITIONS');
1086: AddMember(G_fin1_line_event_class_table, 'CIP_ADDITIONS');

Line 1083: G_ret_line_event_class_table := fa_char30_tbl_type();

1079: G_fin1_line_event_class_table := fa_char30_tbl_type();
1080: G_fin2_line_event_class_table := fa_char30_tbl_type();
1081: G_xfr_line_event_class_table := fa_char30_tbl_type();
1082: G_dist_line_event_class_table := fa_char30_tbl_type();
1083: G_ret_line_event_class_table := fa_char30_tbl_type();
1084:
1085: AddMember(G_fin1_line_event_class_table, 'ADDITIONS');
1086: AddMember(G_fin1_line_event_class_table, 'CIP_ADDITIONS');
1087: AddMember(G_fin1_line_event_class_table, 'ADJUSTMENTS');

Line 1112: G_known_trx_hdr_tables := fa_char30_tbl_type();

1108:
1109: AddMember(G_ret_line_event_class_table, 'RETIREMENTS');
1110: AddMember(G_ret_line_event_class_table, 'CIP_RETIREMENTS');
1111:
1112: G_known_trx_hdr_tables := fa_char30_tbl_type();
1113: G_known_trx_hdr_tables := G_known_deprn_hdr_tables;
1114:
1115: -- line level tables
1116: G_known_fin1_line_tables := fa_char30_tbl_type();

Line 1116: G_known_fin1_line_tables := fa_char30_tbl_type();

1112: G_known_trx_hdr_tables := fa_char30_tbl_type();
1113: G_known_trx_hdr_tables := G_known_deprn_hdr_tables;
1114:
1115: -- line level tables
1116: G_known_fin1_line_tables := fa_char30_tbl_type();
1117: G_known_fin2_line_tables := fa_char30_tbl_type();
1118: G_known_xfr_line_tables := fa_char30_tbl_type();
1119: G_known_dist1_line_tables := fa_char30_tbl_type();
1120: G_known_dist2_line_tables := fa_char30_tbl_type();

Line 1117: G_known_fin2_line_tables := fa_char30_tbl_type();

1113: G_known_trx_hdr_tables := G_known_deprn_hdr_tables;
1114:
1115: -- line level tables
1116: G_known_fin1_line_tables := fa_char30_tbl_type();
1117: G_known_fin2_line_tables := fa_char30_tbl_type();
1118: G_known_xfr_line_tables := fa_char30_tbl_type();
1119: G_known_dist1_line_tables := fa_char30_tbl_type();
1120: G_known_dist2_line_tables := fa_char30_tbl_type();
1121: G_known_ret_line_tables := fa_char30_tbl_type();

Line 1118: G_known_xfr_line_tables := fa_char30_tbl_type();

1114:
1115: -- line level tables
1116: G_known_fin1_line_tables := fa_char30_tbl_type();
1117: G_known_fin2_line_tables := fa_char30_tbl_type();
1118: G_known_xfr_line_tables := fa_char30_tbl_type();
1119: G_known_dist1_line_tables := fa_char30_tbl_type();
1120: G_known_dist2_line_tables := fa_char30_tbl_type();
1121: G_known_ret_line_tables := fa_char30_tbl_type();
1122:

Line 1119: G_known_dist1_line_tables := fa_char30_tbl_type();

1115: -- line level tables
1116: G_known_fin1_line_tables := fa_char30_tbl_type();
1117: G_known_fin2_line_tables := fa_char30_tbl_type();
1118: G_known_xfr_line_tables := fa_char30_tbl_type();
1119: G_known_dist1_line_tables := fa_char30_tbl_type();
1120: G_known_dist2_line_tables := fa_char30_tbl_type();
1121: G_known_ret_line_tables := fa_char30_tbl_type();
1122:
1123: AddMember(G_known_fin1_line_tables, 'FA_XLA_EXT_LINES_STG_GT');

Line 1120: G_known_dist2_line_tables := fa_char30_tbl_type();

1116: G_known_fin1_line_tables := fa_char30_tbl_type();
1117: G_known_fin2_line_tables := fa_char30_tbl_type();
1118: G_known_xfr_line_tables := fa_char30_tbl_type();
1119: G_known_dist1_line_tables := fa_char30_tbl_type();
1120: G_known_dist2_line_tables := fa_char30_tbl_type();
1121: G_known_ret_line_tables := fa_char30_tbl_type();
1122:
1123: AddMember(G_known_fin1_line_tables, 'FA_XLA_EXT_LINES_STG_GT');
1124: AddMember(G_known_fin1_line_tables, 'FA_ADJUSTMENTS');

Line 1121: G_known_ret_line_tables := fa_char30_tbl_type();

1117: G_known_fin2_line_tables := fa_char30_tbl_type();
1118: G_known_xfr_line_tables := fa_char30_tbl_type();
1119: G_known_dist1_line_tables := fa_char30_tbl_type();
1120: G_known_dist2_line_tables := fa_char30_tbl_type();
1121: G_known_ret_line_tables := fa_char30_tbl_type();
1122:
1123: AddMember(G_known_fin1_line_tables, 'FA_XLA_EXT_LINES_STG_GT');
1124: AddMember(G_known_fin1_line_tables, 'FA_ADJUSTMENTS');
1125: AddMember(G_known_fin1_line_tables, 'FA_DISTRIBUTION_HISTORY');

Line 1146: G_known_stg_tables := fa_char30_tbl_type();

1142: AddMember(G_known_ret_line_tables, 'FA_RETIREMENTS');
1143:
1144:
1145: -- staging
1146: G_known_stg_tables := fa_char30_tbl_type();
1147:
1148: -- standard
1149: AddMember(G_known_stg_tables, 'FA_ADDITIONS_B');
1150: AddMember(G_known_stg_tables, 'FA_ASSET_HISTORY');

Line 1164: G_trx_mls_event_class_table := fa_char30_tbl_type();

1160: AddMember(G_known_stg_tables, 'FA_LEASES');
1161: AddMember(G_known_stg_tables, 'FA_METHODS');
1162:
1163: -- mls
1164: G_trx_mls_event_class_table := fa_char30_tbl_type();
1165: AddMember(G_trx_mls_event_class_table, 'ADDITIONS');
1166: AddMember(G_trx_mls_event_class_table, 'CIP_ADDITIONS');
1167: AddMember(G_trx_mls_event_class_table, 'ADJUSTMENTS');
1168: AddMember(G_trx_mls_event_class_table, 'CIP_ADJUSTMENTS');

Line 1191: G_known_mls_tables := fa_char30_tbl_type();

1187: AddMember(G_trx_mls_event_class_table, 'DEPRECIATION');
1188: AddMember(G_trx_mls_event_class_table, 'DEFERRED_DEPRECIATION');
1189:
1190:
1191: G_known_mls_tables := fa_char30_tbl_type();
1192: AddMember(G_known_mls_tables, 'FA_ADDITIONS_TL');
1193: AddMember(G_known_mls_tables, 'FA_CATEGORIES_TL');
1194:
1195:

Line 1262: cursor c_tables (p_tables fa_char30_tbl_type,

1258: p_level IN VARCHAR2, -- header/line/stg
1259: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
1260:
1261:
1262: cursor c_tables (p_tables fa_char30_tbl_type,
1263: p_schemas fa_char30_tbl_type) is
1264: select distinct table_name,
1265: decode(table_name,
1266: -- standard headers/lines

Line 1263: p_schemas fa_char30_tbl_type) is

1259: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
1260:
1261:
1262: cursor c_tables (p_tables fa_char30_tbl_type,
1263: p_schemas fa_char30_tbl_type) is
1264: select distinct table_name,
1265: decode(table_name,
1266: -- standard headers/lines
1267: 'FA_BOOK_CONTROLS' , 'bc',

Line 1296: TABLE(CAST(p_tables AS fa_char30_tbl_type)) fatab,

1292: 'FA_LOCATIONS' , 'loc',
1293: 'FA_METHODS' , 'mt',
1294: 'INVALID')
1295: from all_tables tab,
1296: TABLE(CAST(p_tables AS fa_char30_tbl_type)) fatab,
1297: TABLE(CAST(p_schemas AS fa_char30_tbl_type)) stab
1298: where tab.table_name = fatab.column_value
1299: and tab.owner = stab.column_value;
1300:

Line 1297: TABLE(CAST(p_schemas AS fa_char30_tbl_type)) stab

1293: 'FA_METHODS' , 'mt',
1294: 'INVALID')
1295: from all_tables tab,
1296: TABLE(CAST(p_tables AS fa_char30_tbl_type)) fatab,
1297: TABLE(CAST(p_schemas AS fa_char30_tbl_type)) stab
1298: where tab.table_name = fatab.column_value
1299: and tab.owner = stab.column_value;
1300:
1301:

Line 1315: p_event_class_table fa_char30_tbl_type) is

1311: -- values selected to use one of the two known MLS tables
1312:
1313: cursor c_sources (p_entity_code VARCHAR2,
1314: p_source_level_code VARCHAR2,
1315: p_event_class_table fa_char30_tbl_type) is
1316: select distinct
1317: sources.source_code,
1318: sources.source_table_name,
1319: sources.source_column_name

Line 1322: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab

1318: sources.source_table_name,
1319: sources.source_column_name
1320: from xla_aad_sources aad,
1321: xla_sources_b sources,
1322: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1323: where aad.application_id = 140
1324: and sources.application_id = 140
1325: and aad.entity_code = p_entity_code
1326: and aad.source_level_code = p_source_level_code

Line 1335: p_event_class_table fa_char30_tbl_type,

1331: order by 2,1;
1332:
1333: cursor c_sources_stg (p_entity_code VARCHAR2,
1334: p_source_level_code VARCHAR2,
1335: p_event_class_table fa_char30_tbl_type,
1336: p_known_tables fa_char30_tbl_type) is
1337: select distinct
1338: sources.source_code,
1339: sources.source_table_name,

Line 1336: p_known_tables fa_char30_tbl_type) is

1332:
1333: cursor c_sources_stg (p_entity_code VARCHAR2,
1334: p_source_level_code VARCHAR2,
1335: p_event_class_table fa_char30_tbl_type,
1336: p_known_tables fa_char30_tbl_type) is
1337: select distinct
1338: sources.source_code,
1339: sources.source_table_name,
1340: sources.source_column_name

Line 1343: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab

1339: sources.source_table_name,
1340: sources.source_column_name
1341: from xla_aad_sources aad,
1342: xla_sources_b sources,
1343: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1344: where aad.application_id = 140
1345: and sources.application_id = 140
1346: and aad.entity_code = p_entity_code
1347: and aad.source_level_code = p_source_level_code

Line 1353: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)

1349: and aad.source_code = sources.source_code
1350: and sources.source_table_name is not null
1351: and sources.source_table_name in
1352: (select fatab2.column_value
1353: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)
1354: order by 2,1;
1355:
1356: cursor c_sources_trx (p_entity_code VARCHAR2,
1357: p_source_level_code VARCHAR2,

Line 1358: p_event_class_table fa_char30_tbl_type,

1354: order by 2,1;
1355:
1356: cursor c_sources_trx (p_entity_code VARCHAR2,
1357: p_source_level_code VARCHAR2,
1358: p_event_class_table fa_char30_tbl_type,
1359: p_known_tables fa_char30_tbl_type) is
1360: select distinct
1361: sources.source_code,
1362: 'FA_XLA_EXT_LINES_STG_GT',

Line 1359: p_known_tables fa_char30_tbl_type) is

1355:
1356: cursor c_sources_trx (p_entity_code VARCHAR2,
1357: p_source_level_code VARCHAR2,
1358: p_event_class_table fa_char30_tbl_type,
1359: p_known_tables fa_char30_tbl_type) is
1360: select distinct
1361: sources.source_code,
1362: 'FA_XLA_EXT_LINES_STG_GT',
1363: sources.source_code

Line 1366: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab

1362: 'FA_XLA_EXT_LINES_STG_GT',
1363: sources.source_code
1364: from xla_aad_sources aad,
1365: xla_sources_b sources,
1366: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1367: where aad.application_id = 140
1368: and sources.application_id = 140
1369: and aad.entity_code = p_entity_code
1370: and aad.source_level_code = p_source_level_code

Line 1376: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)

1372: and aad.source_code = sources.source_code
1373: and sources.source_table_name is not null
1374: and sources.source_table_name not in
1375: (select fatab2.column_value
1376: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)
1377: union
1378: select distinct
1379: sources.source_code,
1380: sources.source_table_name,

Line 1384: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab

1380: sources.source_table_name,
1381: sources.source_column_name
1382: from xla_aad_sources aad,
1383: xla_sources_b sources,
1384: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1385: where aad.application_id = 140
1386: and sources.application_id = 140
1387: and aad.entity_code = p_entity_code
1388: and aad.source_level_code = p_source_level_code

Line 1394: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)

1390: and aad.source_code = sources.source_code
1391: and sources.source_table_name is not null
1392: and sources.source_table_name in
1393: (select fatab2.column_value
1394: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)
1395: order by 2,1;
1396:
1397:
1398: cursor c_sources_mls (p_entity_code VARCHAR2,

Line 1400: p_event_class_table fa_char30_tbl_type) is

1396:
1397:
1398: cursor c_sources_mls (p_entity_code VARCHAR2,
1399: p_source_level_code VARCHAR2,
1400: p_event_class_table fa_char30_tbl_type) is
1401: select distinct
1402: sources.source_code,
1403: sources.source_table_name,
1404: sources.source_column_name

Line 1407: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab

1403: sources.source_table_name,
1404: sources.source_column_name
1405: from xla_aad_sources aad,
1406: xla_sources_b sources,
1407: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1408: where aad.application_id = 140
1409: and sources.application_id = 140
1410: and aad.entity_code = p_entity_code
1411: and aad.source_level_code = p_source_level_code

Line 1433: l_known_tables fa_char30_tbl_type;

1429: l_table_known v30_tbl;
1430: l_alias_known v30_tbl;
1431:
1432: -- used to set to the global constants from initialization
1433: l_known_tables fa_char30_tbl_type;
1434: l_entity_code varchar2(30);
1435: l_event_class_table fa_char30_tbl_type;
1436:
1437: l_level varchar2(30);

Line 1435: l_event_class_table fa_char30_tbl_type;

1431:
1432: -- used to set to the global constants from initialization
1433: l_known_tables fa_char30_tbl_type;
1434: l_entity_code varchar2(30);
1435: l_event_class_table fa_char30_tbl_type;
1436:
1437: l_level varchar2(30);
1438: l_found boolean := false;
1439: l_loop_total number := 1;

Line 1466: l_known_tables := fa_char30_tbl_type();

1462:
1463: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
1464: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
1465:
1466: l_known_tables := fa_char30_tbl_type();
1467: l_event_class_table := fa_char30_tbl_type();
1468:
1469:
1470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1467: l_event_class_table := fa_char30_tbl_type();

1463: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
1464: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
1465:
1466: l_known_tables := fa_char30_tbl_type();
1467: l_event_class_table := fa_char30_tbl_type();
1468:
1469:
1470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1471: fnd_log.string(G_LEVEL_STATEMENT,