APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_PARAMETERS

Line 2495: ' select 1 from MSC_PARAMETERS '

2491:
2492: lv_exist:= 0;
2493:
2494: OPEN c_org_exist FOR
2495: ' select 1 from MSC_PARAMETERS '
2496: ||' where ORGANIZATION_ID = :sr_tp_id '
2497: ||' and SR_INSTANCE_ID = :instance_id ' USING c_rec.SR_TP_ID, c_rec.SR_INSTANCE_ID;
2498:
2499: FETCH c_org_exist into lv_exist ;

Line 2503: INSERT INTO MSC_PARAMETERS

2499: FETCH c_org_exist into lv_exist ;
2500: CLOSE c_org_exist;
2501:
2502: IF lv_exist = 0 THEN
2503: INSERT INTO MSC_PARAMETERS
2504: ( ORGANIZATION_ID,
2505: SR_INSTANCE_ID,
2506: DEMAND_TIME_FENCE_FLAG,
2507: PLANNING_TIME_FENCE_FLAG,

Line 3037: --DELETE FROM MSC_PARAMETERS

3033: BEGIN
3034:
3035: --IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3036:
3037: --DELETE FROM MSC_PARAMETERS
3038: -- WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
3039: --END IF;
3040:
3041: FOR c_rec IN c1 LOOP

Line 3045: UPDATE MSC_PARAMETERS

3041: FOR c_rec IN c1 LOOP
3042:
3043: BEGIN
3044:
3045: UPDATE MSC_PARAMETERS
3046: SET
3047: DEMAND_TIME_FENCE_FLAG= c_rec.DEMAND_TIME_FENCE_FLAG,
3048: PLANNING_TIME_FENCE_FLAG= c_rec.PLANNING_TIME_FENCE_FLAG,
3049: OPERATION_SCHEDULE_TYPE= c_rec.OPERATION_SCHEDULE_TYPE,

Line 3077: INSERT INTO MSC_PARAMETERS

3073: -- AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
3074:
3075: IF SQL%NOTFOUND THEN
3076:
3077: INSERT INTO MSC_PARAMETERS
3078: ( ORGANIZATION_ID,
3079: DEMAND_TIME_FENCE_FLAG,
3080: PLANNING_TIME_FENCE_FLAG,
3081: OPERATION_SCHEDULE_TYPE,

Line 3149: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARAMETERS');

3145:
3146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3147: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3148: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PARAMETER');
3149: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARAMETERS');
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3151:
3152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3153: RAISE;

Line 3162: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARAMETERS');

3158:
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3160: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3161: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PARAMETER');
3162: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARAMETERS');
3163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3164:
3165: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3166: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');