APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_PE_INT_CATEGORIES

Line 90: Migrate_AS_PE_INT_CATEGORIES(ERRBUF,

86: p_Debug_Flag);
87: Migrate_AS_PRODWKS_LINES(ERRBUF,
88: RETCODE,
89: p_Debug_Flag);
90: Migrate_AS_PE_INT_CATEGORIES(ERRBUF,
91: RETCODE,
92: p_Debug_Flag);
93:
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration finished successfully');

Line 1239: Migrate product_category_id and product_cat_set_id into AS_PE_INT_CATEGORIES table

1235: END IF ;
1236: END Migrate_AS_PRODWKS_LINES;
1237:
1238: /*
1239: Migrate product_category_id and product_cat_set_id into AS_PE_INT_CATEGORIES table
1240: */
1241: PROCEDURE Migrate_AS_PE_INT_CATEGORIES(
1242: ERRBUF OUT NOCOPY VARCHAR2,
1243: RETCODE OUT NOCOPY VARCHAR2,

Line 1241: PROCEDURE Migrate_AS_PE_INT_CATEGORIES(

1237:
1238: /*
1239: Migrate product_category_id and product_cat_set_id into AS_PE_INT_CATEGORIES table
1240: */
1241: PROCEDURE Migrate_AS_PE_INT_CATEGORIES(
1242: ERRBUF OUT NOCOPY VARCHAR2,
1243: RETCODE OUT NOCOPY VARCHAR2,
1244: p_Debug_Flag IN VARCHAR2 Default 'N'
1245: ) IS

Line 1266: update as_pe_int_categories l

1262: end if;
1263:
1264:
1265: -- Update interest type
1266: update as_pe_int_categories l
1267: set (product_category_id, product_cat_set_id) =
1268: (select int.product_category_id, int.product_cat_set_id
1269: from as_interest_types_b int
1270: where l.interest_type_id = int.interest_type_id)

Line 1276: update as_pe_int_categories l

1272: and nvl(l.pri_interest_code_id,-1) = -1
1273: and nvl(l.sec_interest_code_id,-1) = -1;
1274:
1275: -- Update primary interest code
1276: update as_pe_int_categories l
1277: set (product_category_id, product_cat_set_id) =
1278: (select int.product_category_id, int.product_cat_set_id
1279: from as_interest_codes_b int
1280: where l.pri_interest_code_id = int.interest_code_id)

Line 1285: update as_pe_int_categories l

1281: where nvl(l.pri_interest_code_id,-1) <> -1
1282: and nvl(l.sec_interest_code_id,-1) = -1;
1283:
1284: -- Update secondary interest code
1285: update as_pe_int_categories l
1286: set (product_category_id, product_cat_set_id) =
1287: (select int.product_category_id, int.product_cat_set_id
1288: from as_interest_codes_b int
1289: where l.sec_interest_code_id = int.interest_code_id)

Line 1309: END Migrate_AS_PE_INT_CATEGORIES;

1305: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1306: IF l_status = TRUE THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1308: END IF ;
1309: END Migrate_AS_PE_INT_CATEGORIES;
1310:
1311: /*
1312: Enable the following triggers
1313: a) AS_LEAD_LINES_BIUD