APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ATP_RULES

Line 3366: DELETE MSC_ATP_RULES

3362: BEGIN
3363:
3364: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3365:
3366: DELETE MSC_ATP_RULES
3367: WHERE sr_instance_id= MSC_CL_COLLECTION.v_instance_id;
3368:
3369: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ATP_RULES', MSC_CL_COLLECTION.v_instance_id, NULL);
3370:

Line 3369: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ATP_RULES', MSC_CL_COLLECTION.v_instance_id, NULL);

3365:
3366: DELETE MSC_ATP_RULES
3367: WHERE sr_instance_id= MSC_CL_COLLECTION.v_instance_id;
3368:
3369: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ATP_RULES', MSC_CL_COLLECTION.v_instance_id, NULL);
3370:
3371: END IF;
3372:
3373: c_count:= 0;

Line 3379: INSERT INTO MSC_ATP_RULES

3375: FOR c_rec IN c1 LOOP
3376:
3377: BEGIN
3378:
3379: INSERT INTO MSC_ATP_RULES
3380: ( RULE_ID,
3381: RULE_NAME,
3382: DESCRIPTION,
3383: ACCUMULATE_AVAILABLE_FLAG,

Line 3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');

3482:
3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:
3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3490: RAISE;

Line 3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');

3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');