APPS.FA_XLA_CMP_SOURCES_PKG dependencies on STANDARD

Line 22: | 1) in base R12 standard sources can only be seeded by ORACLE |

18: | as well as the XLA AAD setups for determining addition sources, |
19: | tables, columns to extract. |
20: | |
21: | Primary restrictions: |
22: | 1) in base R12 standard sources can only be seeded by ORACLE |
23: | thus attempts to add additional sources may either be ignored |
24: | or fail (depending on whether FKs for table/column are loaded) |
25: | 2) on a related note, the tables allowed in the seeded setup are |
26: | a small subset and to add a table requires not only the seed |

Line 41: | *** CUSTOMIZATION OF THIS PACKAGE OR STANDARD SOURCES IS NOT SUPPORTED *** |

37: | String comparison in particular looks for spaces and you risk |
38: | breaking the logic. If your editor does this, than use vi!!!!! |
39: | if you do this, then dont !!!! |
40: | |
41: | *** CUSTOMIZATION OF THIS PACKAGE OR STANDARD SOURCES IS NOT SUPPORTED *** |
42: | |
43: | HISTORY |
44: | 25-FEB-2006 BRIDGWAY Created |
45: | |

Line 1181: -- lines standard

1177: AddMember(G_known_deprn_hdr_tables, 'FA_BOOK_CONTROLS');
1178: AddMember(G_known_deprn_hdr_tables, 'FA_DEPRN_PERIODS');
1179: AddMember(G_known_deprn_hdr_tables, 'XLA_EVENTS_GT');
1180:
1181: -- lines standard
1182: AddMember(G_known_deprn_line_tables, 'FA_ADDITIONS_B');
1183: AddMember(G_known_deprn_line_tables, 'FA_ASSET_HISTORY');
1184: AddMember(G_known_deprn_line_tables, 'FA_BOOK_CONTROLS');
1185: AddMember(G_known_deprn_line_tables, 'FA_DISTRIBUTION_HISTORY');

Line 1191: -- lines non-standard

1187: AddMember(G_known_deprn_line_tables, 'FA_DEPRN_PERIODS');
1188: AddMember(G_known_deprn_line_tables, 'GL_LEDGERS');
1189: AddMember(G_known_deprn_line_tables, 'XLA_EVENTS_GT');
1190:
1191: -- lines non-standard
1192: AddMember(G_known_deprn_line_tables, 'FA_ASSET_KEYWORDS');
1193: AddMember(G_known_deprn_line_tables, 'FA_BOOKS');
1194: AddMember(G_known_deprn_line_tables, 'FA_CATEGORIES_B');
1195: AddMember(G_known_deprn_line_tables, 'FA_CATEGORY_BOOKS');

Line 1211: -- standard

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');
1214: AddMember(G_known_def_line_tables, 'FA_BOOK_CONTROLS');
1215: AddMember(G_known_def_line_tables, 'FA_DISTRIBUTION_HISTORY');

Line 1221: -- non-standard

1217: AddMember(G_known_def_line_tables, 'FA_DEPRN_PERIODS');
1218: AddMember(G_known_def_line_tables, 'GL_LEDGERS');
1219: AddMember(G_known_def_line_tables, 'XLA_EVENTS_GT');
1220:
1221: -- non-standard
1222: AddMember(G_known_def_line_tables, 'FA_ASSET_KEYWORDS');
1223: AddMember(G_known_def_line_tables, 'FA_BOOKS');
1224: AddMember(G_known_def_line_tables, 'FA_CATEGORIES_B');
1225: AddMember(G_known_def_line_tables, 'FA_CATEGORY_BOOKS');

Line 1336: -- standard

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');
1339: AddMember(G_known_stg_tables, 'FA_CATEGORY_BOOKS');
1340: AddMember(G_known_stg_tables, 'FA_BOOK_CONTROLS');

Line 1345: -- non-standard

1341: AddMember(G_known_stg_tables, 'FA_TRANSACTION_HEADERS');
1342: AddMember(G_known_stg_tables, 'GL_LEDGERS');
1343: AddMember(G_known_stg_tables, 'XLA_EVENTS_GT');
1344:
1345: -- non-standard
1346: AddMember(G_known_stg_tables, 'FA_ASSET_KEYWORDS');
1347: AddMember(G_known_stg_tables, 'FA_CATEGORIES_B');
1348: AddMember(G_known_stg_tables, 'FA_LEASES');
1349: AddMember(G_known_stg_tables, 'FA_METHODS');

Line 1452: -- standard headers/lines

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',
1454: 'FA_DEPRN_PERIODS' , 'dp',
1455: 'XLA_EVENTS_GT' , 'ctgld',
1456: -- standard lines

Line 1456: -- standard lines

1452: -- standard headers/lines
1453: 'FA_BOOK_CONTROLS' , 'bc',
1454: 'FA_DEPRN_PERIODS' , 'dp',
1455: 'XLA_EVENTS_GT' , 'ctgld',
1456: -- standard lines
1457: 'FA_ADDITIONS_B' , 'ad',
1458: 'FA_ADJUSTMENTS' , 'adj',
1459: 'FA_ASSET_HISTORY' , 'ah',
1460: 'FA_CATEGORY_BOOKS' , 'cb',

Line 1469: -- non-standard

1465: 'FA_TRANSACTION_HEADERS' , 'th',
1466: 'FA_RETIREMENTS' , 'ret',
1467: 'FA_XLA_EXT_LINES_STG_GT' , 'stg',
1468: 'GL_LEDGERS' , 'le',
1469: -- non-standard
1470: 'FA_ADDITIONS_TL' , 'adtl',
1471: 'FA_ASSET_INVOICES' , 'ai',
1472: 'FA_ASSET_KEYWORDS' , 'key',
1473: 'FA_BOOKS' , 'bk',