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 995: -- lines standard

991: AddMember(G_known_deprn_hdr_tables, 'FA_BOOK_CONTROLS');
992: AddMember(G_known_deprn_hdr_tables, 'FA_DEPRN_PERIODS');
993: AddMember(G_known_deprn_hdr_tables, 'XLA_EVENTS_GT');
994:
995: -- lines standard
996: AddMember(G_known_deprn_line_tables, 'FA_ADDITIONS_B');
997: AddMember(G_known_deprn_line_tables, 'FA_ASSET_HISTORY');
998: AddMember(G_known_deprn_line_tables, 'FA_BOOK_CONTROLS');
999: AddMember(G_known_deprn_line_tables, 'FA_DISTRIBUTION_HISTORY');

Line 1005: -- lines non-standard

1001: AddMember(G_known_deprn_line_tables, 'FA_DEPRN_PERIODS');
1002: AddMember(G_known_deprn_line_tables, 'GL_LEDGERS');
1003: AddMember(G_known_deprn_line_tables, 'XLA_EVENTS_GT');
1004:
1005: -- lines non-standard
1006: AddMember(G_known_deprn_line_tables, 'FA_ASSET_KEYWORDS');
1007: AddMember(G_known_deprn_line_tables, 'FA_BOOKS');
1008: AddMember(G_known_deprn_line_tables, 'FA_CATEGORIES_B');
1009: AddMember(G_known_deprn_line_tables, 'FA_CATEGORY_BOOKS');

Line 1025: -- standard

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

Line 1035: -- non-standard

1031: AddMember(G_known_def_line_tables, 'FA_DEPRN_PERIODS');
1032: AddMember(G_known_def_line_tables, 'GL_LEDGERS');
1033: AddMember(G_known_def_line_tables, 'XLA_EVENTS_GT');
1034:
1035: -- non-standard
1036: AddMember(G_known_def_line_tables, 'FA_ASSET_KEYWORDS');
1037: AddMember(G_known_def_line_tables, 'FA_BOOKS');
1038: AddMember(G_known_def_line_tables, 'FA_CATEGORIES_B');
1039: AddMember(G_known_def_line_tables, 'FA_CATEGORY_BOOKS');

Line 1148: -- standard

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

Line 1157: -- non-standard

1153: AddMember(G_known_stg_tables, 'FA_TRANSACTION_HEADERS');
1154: AddMember(G_known_stg_tables, 'GL_LEDGERS');
1155: AddMember(G_known_stg_tables, 'XLA_EVENTS_GT');
1156:
1157: -- non-standard
1158: AddMember(G_known_stg_tables, 'FA_ASSET_KEYWORDS');
1159: AddMember(G_known_stg_tables, 'FA_CATEGORIES_B');
1160: AddMember(G_known_stg_tables, 'FA_LEASES');
1161: AddMember(G_known_stg_tables, 'FA_METHODS');

Line 1266: -- standard headers/lines

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',
1268: 'FA_DEPRN_PERIODS' , 'dp',
1269: 'XLA_EVENTS_GT' , 'ctgld',
1270: -- standard lines

Line 1270: -- standard lines

1266: -- standard headers/lines
1267: 'FA_BOOK_CONTROLS' , 'bc',
1268: 'FA_DEPRN_PERIODS' , 'dp',
1269: 'XLA_EVENTS_GT' , 'ctgld',
1270: -- standard lines
1271: 'FA_ADDITIONS_B' , 'ad',
1272: 'FA_ADJUSTMENTS' , 'adj',
1273: 'FA_ASSET_HISTORY' , 'ah',
1274: 'FA_CATEGORY_BOOKS' , 'cb',

Line 1283: -- non-standard

1279: 'FA_TRANSACTION_HEADERS' , 'th',
1280: 'FA_RETIREMENTS' , 'ret',
1281: 'FA_XLA_EXT_LINES_STG_GT' , 'stg',
1282: 'GL_LEDGERS' , 'le',
1283: -- non-standard
1284: 'FA_ADDITIONS_TL' , 'adtl',
1285: 'FA_ASSET_INVOICES' , 'ai',
1286: 'FA_ASSET_KEYWORDS' , 'key',
1287: 'FA_BOOKS' , 'bk',