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 1045: Procedure AddMember (p_table IN OUT NOCOPY fa_char30_tbl_type,

1041:
1042: -- AddMember
1043: -- Extends and Inserts a value into table
1044:
1045: Procedure AddMember (p_table IN OUT NOCOPY fa_char30_tbl_type,
1046: p_value IN VARCHAR2)IS
1047:
1048: l_procedure_name varchar2(80) := 'AddMember';
1049:

Line 1160: G_known_schemas := fa_char30_tbl_type();

1156: 'Beginning of procedure');
1157: END IF;
1158:
1159: -- schemas
1160: G_known_schemas := fa_char30_tbl_type();
1161: l_schema := get_schema('OFA');
1162: AddMember(G_known_schemas, l_schema);
1163: l_schema := get_schema('GL');
1164: AddMember(G_known_schemas, l_schema);

Line 1170: G_deprn_event_class_table := fa_char30_tbl_type();

1166: AddMember(G_known_schemas, l_schema);
1167:
1168:
1169: -- deprn (used for header and lines)
1170: G_deprn_event_class_table := fa_char30_tbl_type();
1171: AddMember(G_deprn_event_class_table, 'DEPRECIATION');
1172:
1173: G_known_deprn_hdr_tables := fa_char30_tbl_type();
1174: G_known_deprn_line_tables := fa_char30_tbl_type();

Line 1173: G_known_deprn_hdr_tables := fa_char30_tbl_type();

1169: -- deprn (used for header and lines)
1170: G_deprn_event_class_table := fa_char30_tbl_type();
1171: AddMember(G_deprn_event_class_table, 'DEPRECIATION');
1172:
1173: G_known_deprn_hdr_tables := fa_char30_tbl_type();
1174: G_known_deprn_line_tables := fa_char30_tbl_type();
1175:
1176: -- header
1177: AddMember(G_known_deprn_hdr_tables, 'FA_BOOK_CONTROLS');

Line 1174: G_known_deprn_line_tables := fa_char30_tbl_type();

1170: G_deprn_event_class_table := fa_char30_tbl_type();
1171: AddMember(G_deprn_event_class_table, 'DEPRECIATION');
1172:
1173: G_known_deprn_hdr_tables := fa_char30_tbl_type();
1174: G_known_deprn_line_tables := fa_char30_tbl_type();
1175:
1176: -- header
1177: AddMember(G_known_deprn_hdr_tables, 'FA_BOOK_CONTROLS');
1178: AddMember(G_known_deprn_hdr_tables, 'FA_DEPRN_PERIODS');

Line 1203: G_def_event_class_table := fa_char30_tbl_type();

1199: AddMember(G_known_deprn_line_tables, 'FA_METHODS');
1200:
1201:
1202: -- deferred (used for header and lines)
1203: G_def_event_class_table := fa_char30_tbl_type();
1204: AddMember(G_def_event_class_table, 'DEFERRED_DEPRECIATION');
1205:
1206: -- deferred
1207: G_known_def_hdr_tables := fa_char30_tbl_type();

Line 1207: G_known_def_hdr_tables := fa_char30_tbl_type();

1203: G_def_event_class_table := fa_char30_tbl_type();
1204: AddMember(G_def_event_class_table, 'DEFERRED_DEPRECIATION');
1205:
1206: -- deferred
1207: G_known_def_hdr_tables := fa_char30_tbl_type();
1208: G_known_def_hdr_tables := G_known_deprn_hdr_tables;
1209: G_known_def_line_tables := fa_char30_tbl_type();
1210:
1211: -- standard

Line 1209: G_known_def_line_tables := fa_char30_tbl_type();

1205:
1206: -- deferred
1207: G_known_def_hdr_tables := fa_char30_tbl_type();
1208: G_known_def_hdr_tables := G_known_deprn_hdr_tables;
1209: G_known_def_line_tables := fa_char30_tbl_type();
1210:
1211: -- standard
1212: AddMember(G_known_def_line_tables, 'FA_ADDITIONS_B');
1213: AddMember(G_known_def_line_tables, 'FA_ASSET_HISTORY');

Line 1233: G_trx1_hdr_event_class_table := fa_char30_tbl_type();

1229:
1230:
1231: -- headers only
1232: -- transactions
1233: G_trx1_hdr_event_class_table := fa_char30_tbl_type();
1234:
1235: AddMember(G_trx1_hdr_event_class_table, 'ADDITIONS');
1236: AddMember(G_trx1_hdr_event_class_table, 'CIP_ADDITIONS');
1237: AddMember(G_trx1_hdr_event_class_table, 'ADJUSTMENTS');

Line 1258: G_trx2_hdr_event_class_table := fa_char30_tbl_type();

1254: AddMember(G_trx1_hdr_event_class_table, 'IMPAIRMENT');
1255:
1256: -- inter asset trxs
1257: -- used for staging and line
1258: G_trx2_hdr_event_class_table := fa_char30_tbl_type();
1259:
1260: AddMember(G_trx2_hdr_event_class_table, 'SOURCE_LINE_TRANSFERS');
1261: AddMember(G_trx2_hdr_event_class_table, 'CIP_SOURCE_LINE_TRANSFERS');
1262: AddMember(G_trx2_hdr_event_class_table, 'RESERVE_TRANSFERS');

Line 1266: G_fin1_line_event_class_table := fa_char30_tbl_type();

1262: AddMember(G_trx2_hdr_event_class_table, 'RESERVE_TRANSFERS');
1263:
1264:
1265: -- line level event classes
1266: G_fin1_line_event_class_table := fa_char30_tbl_type();
1267: G_fin2_line_event_class_table := fa_char30_tbl_type();
1268: G_xfr_line_event_class_table := fa_char30_tbl_type();
1269: G_dist_line_event_class_table := fa_char30_tbl_type();
1270: G_ret_line_event_class_table := fa_char30_tbl_type();

Line 1267: G_fin2_line_event_class_table := fa_char30_tbl_type();

1263:
1264:
1265: -- line level event classes
1266: G_fin1_line_event_class_table := fa_char30_tbl_type();
1267: G_fin2_line_event_class_table := fa_char30_tbl_type();
1268: G_xfr_line_event_class_table := fa_char30_tbl_type();
1269: G_dist_line_event_class_table := fa_char30_tbl_type();
1270: G_ret_line_event_class_table := fa_char30_tbl_type();
1271:

Line 1268: G_xfr_line_event_class_table := fa_char30_tbl_type();

1264:
1265: -- line level event classes
1266: G_fin1_line_event_class_table := fa_char30_tbl_type();
1267: G_fin2_line_event_class_table := fa_char30_tbl_type();
1268: G_xfr_line_event_class_table := fa_char30_tbl_type();
1269: G_dist_line_event_class_table := fa_char30_tbl_type();
1270: G_ret_line_event_class_table := fa_char30_tbl_type();
1271:
1272: AddMember(G_fin1_line_event_class_table, 'ADDITIONS');

Line 1269: G_dist_line_event_class_table := fa_char30_tbl_type();

1265: -- line level event classes
1266: G_fin1_line_event_class_table := fa_char30_tbl_type();
1267: G_fin2_line_event_class_table := fa_char30_tbl_type();
1268: G_xfr_line_event_class_table := fa_char30_tbl_type();
1269: G_dist_line_event_class_table := fa_char30_tbl_type();
1270: G_ret_line_event_class_table := fa_char30_tbl_type();
1271:
1272: AddMember(G_fin1_line_event_class_table, 'ADDITIONS');
1273: AddMember(G_fin1_line_event_class_table, 'CIP_ADDITIONS');

Line 1270: G_ret_line_event_class_table := fa_char30_tbl_type();

1266: G_fin1_line_event_class_table := fa_char30_tbl_type();
1267: G_fin2_line_event_class_table := fa_char30_tbl_type();
1268: G_xfr_line_event_class_table := fa_char30_tbl_type();
1269: G_dist_line_event_class_table := fa_char30_tbl_type();
1270: G_ret_line_event_class_table := fa_char30_tbl_type();
1271:
1272: AddMember(G_fin1_line_event_class_table, 'ADDITIONS');
1273: AddMember(G_fin1_line_event_class_table, 'CIP_ADDITIONS');
1274: AddMember(G_fin1_line_event_class_table, 'ADJUSTMENTS');

Line 1300: G_known_trx_hdr_tables := fa_char30_tbl_type();

1296:
1297: AddMember(G_ret_line_event_class_table, 'RETIREMENTS');
1298: AddMember(G_ret_line_event_class_table, 'CIP_RETIREMENTS');
1299:
1300: G_known_trx_hdr_tables := fa_char30_tbl_type();
1301: G_known_trx_hdr_tables := G_known_deprn_hdr_tables;
1302:
1303: -- line level tables
1304: G_known_fin1_line_tables := fa_char30_tbl_type();

Line 1304: G_known_fin1_line_tables := fa_char30_tbl_type();

1300: G_known_trx_hdr_tables := fa_char30_tbl_type();
1301: G_known_trx_hdr_tables := G_known_deprn_hdr_tables;
1302:
1303: -- line level tables
1304: G_known_fin1_line_tables := fa_char30_tbl_type();
1305: G_known_fin2_line_tables := fa_char30_tbl_type();
1306: G_known_xfr_line_tables := fa_char30_tbl_type();
1307: G_known_dist1_line_tables := fa_char30_tbl_type();
1308: G_known_dist2_line_tables := fa_char30_tbl_type();

Line 1305: G_known_fin2_line_tables := fa_char30_tbl_type();

1301: G_known_trx_hdr_tables := G_known_deprn_hdr_tables;
1302:
1303: -- line level tables
1304: G_known_fin1_line_tables := fa_char30_tbl_type();
1305: G_known_fin2_line_tables := fa_char30_tbl_type();
1306: G_known_xfr_line_tables := fa_char30_tbl_type();
1307: G_known_dist1_line_tables := fa_char30_tbl_type();
1308: G_known_dist2_line_tables := fa_char30_tbl_type();
1309: G_known_ret_line_tables := fa_char30_tbl_type();

Line 1306: G_known_xfr_line_tables := fa_char30_tbl_type();

1302:
1303: -- line level tables
1304: G_known_fin1_line_tables := fa_char30_tbl_type();
1305: G_known_fin2_line_tables := fa_char30_tbl_type();
1306: G_known_xfr_line_tables := fa_char30_tbl_type();
1307: G_known_dist1_line_tables := fa_char30_tbl_type();
1308: G_known_dist2_line_tables := fa_char30_tbl_type();
1309: G_known_ret_line_tables := fa_char30_tbl_type();
1310:

Line 1307: G_known_dist1_line_tables := fa_char30_tbl_type();

1303: -- line level tables
1304: G_known_fin1_line_tables := fa_char30_tbl_type();
1305: G_known_fin2_line_tables := fa_char30_tbl_type();
1306: G_known_xfr_line_tables := fa_char30_tbl_type();
1307: G_known_dist1_line_tables := fa_char30_tbl_type();
1308: G_known_dist2_line_tables := fa_char30_tbl_type();
1309: G_known_ret_line_tables := fa_char30_tbl_type();
1310:
1311: AddMember(G_known_fin1_line_tables, 'FA_XLA_EXT_LINES_STG_GT');

Line 1308: G_known_dist2_line_tables := fa_char30_tbl_type();

1304: G_known_fin1_line_tables := fa_char30_tbl_type();
1305: G_known_fin2_line_tables := fa_char30_tbl_type();
1306: G_known_xfr_line_tables := fa_char30_tbl_type();
1307: G_known_dist1_line_tables := fa_char30_tbl_type();
1308: G_known_dist2_line_tables := fa_char30_tbl_type();
1309: G_known_ret_line_tables := fa_char30_tbl_type();
1310:
1311: AddMember(G_known_fin1_line_tables, 'FA_XLA_EXT_LINES_STG_GT');
1312: AddMember(G_known_fin1_line_tables, 'FA_ADJUSTMENTS');

Line 1309: G_known_ret_line_tables := fa_char30_tbl_type();

1305: G_known_fin2_line_tables := fa_char30_tbl_type();
1306: G_known_xfr_line_tables := fa_char30_tbl_type();
1307: G_known_dist1_line_tables := fa_char30_tbl_type();
1308: G_known_dist2_line_tables := fa_char30_tbl_type();
1309: G_known_ret_line_tables := fa_char30_tbl_type();
1310:
1311: AddMember(G_known_fin1_line_tables, 'FA_XLA_EXT_LINES_STG_GT');
1312: AddMember(G_known_fin1_line_tables, 'FA_ADJUSTMENTS');
1313: AddMember(G_known_fin1_line_tables, 'FA_DISTRIBUTION_HISTORY');

Line 1334: G_known_stg_tables := fa_char30_tbl_type();

1330: AddMember(G_known_ret_line_tables, 'FA_RETIREMENTS');
1331:
1332:
1333: -- staging
1334: G_known_stg_tables := fa_char30_tbl_type();
1335:
1336: -- standard
1337: AddMember(G_known_stg_tables, 'FA_ADDITIONS_B');
1338: AddMember(G_known_stg_tables, 'FA_ASSET_HISTORY');

Line 1353: G_trx_mls_event_class_table := fa_char30_tbl_type();

1349: AddMember(G_known_stg_tables, 'FA_METHODS');
1350: AddMember(G_known_stg_tables, 'FA_BOOKS');
1351:
1352: -- mls
1353: G_trx_mls_event_class_table := fa_char30_tbl_type();
1354: AddMember(G_trx_mls_event_class_table, 'ADDITIONS');
1355: AddMember(G_trx_mls_event_class_table, 'CIP_ADDITIONS');
1356: AddMember(G_trx_mls_event_class_table, 'ADJUSTMENTS');
1357: AddMember(G_trx_mls_event_class_table, 'CIP_ADJUSTMENTS');

Line 1380: G_known_mls_tables := fa_char30_tbl_type();

1376: AddMember(G_trx_mls_event_class_table, 'DEPRECIATION');
1377: AddMember(G_trx_mls_event_class_table, 'DEFERRED_DEPRECIATION');
1378: AddMember(G_trx_mls_event_class_table, 'IMPAIRMENT');
1379:
1380: G_known_mls_tables := fa_char30_tbl_type();
1381: AddMember(G_known_mls_tables, 'FA_ADDITIONS_TL');
1382: AddMember(G_known_mls_tables, 'FA_CATEGORIES_TL');
1383:
1384: G_initialized := TRUE;

Line 1448: cursor c_tables (p_tables fa_char30_tbl_type,

1444: p_level IN VARCHAR2, -- header/line/stg
1445: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
1446:
1447:
1448: cursor c_tables (p_tables fa_char30_tbl_type,
1449: p_schemas fa_char30_tbl_type) is
1450: select distinct table_name,
1451: decode(table_name,
1452: -- standard headers/lines

Line 1449: p_schemas fa_char30_tbl_type) is

1445: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
1446:
1447:
1448: cursor c_tables (p_tables fa_char30_tbl_type,
1449: p_schemas fa_char30_tbl_type) is
1450: select distinct table_name,
1451: decode(table_name,
1452: -- standard headers/lines
1453: 'FA_BOOK_CONTROLS' , 'bc',

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

1478: 'FA_LOCATIONS' , 'loc',
1479: 'FA_METHODS' , 'mt',
1480: 'INVALID')
1481: from all_tables tab,
1482: TABLE(CAST(p_tables AS fa_char30_tbl_type)) fatab,
1483: TABLE(CAST(p_schemas AS fa_char30_tbl_type)) stab
1484: where tab.table_name = fatab.column_value
1485: and tab.owner = stab.column_value;
1486:

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

1479: 'FA_METHODS' , 'mt',
1480: 'INVALID')
1481: from all_tables tab,
1482: TABLE(CAST(p_tables AS fa_char30_tbl_type)) fatab,
1483: TABLE(CAST(p_schemas AS fa_char30_tbl_type)) stab
1484: where tab.table_name = fatab.column_value
1485: and tab.owner = stab.column_value;
1486:
1487:

Line 1501: p_event_class_table fa_char30_tbl_type) is

1497: -- values selected to use one of the two known MLS tables
1498:
1499: cursor c_sources (p_entity_code VARCHAR2,
1500: p_source_level_code VARCHAR2,
1501: p_event_class_table fa_char30_tbl_type) is
1502: select distinct
1503: sources.source_code,
1504: sources.source_table_name,
1505: sources.source_column_name

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

1504: sources.source_table_name,
1505: sources.source_column_name
1506: from xla_aad_sources aad,
1507: xla_sources_b sources,
1508: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1509: where aad.application_id = 140
1510: and sources.application_id = 140
1511: and aad.entity_code = p_entity_code
1512: and aad.source_level_code = p_source_level_code

Line 1521: p_event_class_table fa_char30_tbl_type,

1517: order by 2,1;
1518:
1519: cursor c_sources_stg (p_entity_code VARCHAR2,
1520: p_source_level_code VARCHAR2,
1521: p_event_class_table fa_char30_tbl_type,
1522: p_known_tables fa_char30_tbl_type) is
1523: select distinct
1524: sources.source_code,
1525: sources.source_table_name,

Line 1522: p_known_tables fa_char30_tbl_type) is

1518:
1519: cursor c_sources_stg (p_entity_code VARCHAR2,
1520: p_source_level_code VARCHAR2,
1521: p_event_class_table fa_char30_tbl_type,
1522: p_known_tables fa_char30_tbl_type) is
1523: select distinct
1524: sources.source_code,
1525: sources.source_table_name,
1526: sources.source_column_name

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

1525: sources.source_table_name,
1526: sources.source_column_name
1527: from xla_aad_sources aad,
1528: xla_sources_b sources,
1529: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1530: where aad.application_id = 140
1531: and sources.application_id = 140
1532: and aad.entity_code = p_entity_code
1533: and aad.source_level_code = p_source_level_code

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

1535: and aad.source_code = sources.source_code
1536: and sources.source_table_name is not null
1537: and sources.source_table_name in
1538: (select fatab2.column_value
1539: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)
1540: order by 2,1;
1541:
1542: cursor c_sources_trx (p_entity_code VARCHAR2,
1543: p_source_level_code VARCHAR2,

Line 1544: p_event_class_table fa_char30_tbl_type,

1540: order by 2,1;
1541:
1542: cursor c_sources_trx (p_entity_code VARCHAR2,
1543: p_source_level_code VARCHAR2,
1544: p_event_class_table fa_char30_tbl_type,
1545: p_known_tables fa_char30_tbl_type) is
1546: select distinct
1547: sources.source_code,
1548: 'FA_XLA_EXT_LINES_STG_GT',

Line 1545: p_known_tables fa_char30_tbl_type) is

1541:
1542: cursor c_sources_trx (p_entity_code VARCHAR2,
1543: p_source_level_code VARCHAR2,
1544: p_event_class_table fa_char30_tbl_type,
1545: p_known_tables fa_char30_tbl_type) is
1546: select distinct
1547: sources.source_code,
1548: 'FA_XLA_EXT_LINES_STG_GT',
1549: sources.source_code

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

1548: 'FA_XLA_EXT_LINES_STG_GT',
1549: sources.source_code
1550: from xla_aad_sources aad,
1551: xla_sources_b sources,
1552: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1553: where aad.application_id = 140
1554: and sources.application_id = 140
1555: and aad.entity_code = p_entity_code
1556: and aad.source_level_code = p_source_level_code

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

1558: and aad.source_code = sources.source_code
1559: and sources.source_table_name is not null
1560: and sources.source_table_name not in
1561: (select fatab2.column_value
1562: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)
1563: union
1564: select distinct
1565: sources.source_code,
1566: sources.source_table_name,

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

1566: sources.source_table_name,
1567: sources.source_column_name
1568: from xla_aad_sources aad,
1569: xla_sources_b sources,
1570: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1571: where aad.application_id = 140
1572: and sources.application_id = 140
1573: and aad.entity_code = p_entity_code
1574: and aad.source_level_code = p_source_level_code

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

1576: and aad.source_code = sources.source_code
1577: and sources.source_table_name is not null
1578: and sources.source_table_name in
1579: (select fatab2.column_value
1580: from TABLE(CAST(p_known_tables AS fa_char30_tbl_type)) fatab2)
1581: order by 2,1;
1582:
1583:
1584: cursor c_sources_mls (p_entity_code VARCHAR2,

Line 1586: p_event_class_table fa_char30_tbl_type) is

1582:
1583:
1584: cursor c_sources_mls (p_entity_code VARCHAR2,
1585: p_source_level_code VARCHAR2,
1586: p_event_class_table fa_char30_tbl_type) is
1587: select distinct
1588: sources.source_code,
1589: sources.source_table_name,
1590: sources.source_column_name

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

1589: sources.source_table_name,
1590: sources.source_column_name
1591: from xla_aad_sources aad,
1592: xla_sources_b sources,
1593: TABLE(CAST(p_event_class_table AS fa_char30_tbl_type)) fatab
1594: where aad.application_id = 140
1595: and sources.application_id = 140
1596: and aad.entity_code = p_entity_code
1597: and aad.source_level_code = p_source_level_code

Line 1622: l_known_tables fa_char30_tbl_type;

1618: l_table_known v30_tbl;
1619: l_alias_known v30_tbl;
1620:
1621: -- used to set to the global constants from initialization
1622: l_known_tables fa_char30_tbl_type;
1623: l_entity_code varchar2(30);
1624: l_event_class_table fa_char30_tbl_type;
1625:
1626: l_level varchar2(30);

Line 1624: l_event_class_table fa_char30_tbl_type;

1620:
1621: -- used to set to the global constants from initialization
1622: l_known_tables fa_char30_tbl_type;
1623: l_entity_code varchar2(30);
1624: l_event_class_table fa_char30_tbl_type;
1625:
1626: l_level varchar2(30);
1627: l_found boolean := false;
1628: l_loop_total number := 1;

Line 1655: l_known_tables := fa_char30_tbl_type();

1651:
1652: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
1653: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
1654:
1655: l_known_tables := fa_char30_tbl_type();
1656: l_event_class_table := fa_char30_tbl_type();
1657:
1658:
1659: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1656: l_event_class_table := fa_char30_tbl_type();

1652: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
1653: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
1654:
1655: l_known_tables := fa_char30_tbl_type();
1656: l_event_class_table := fa_char30_tbl_type();
1657:
1658:
1659: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1660: fnd_log.string(G_LEVEL_STATEMENT,