APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_PARAMETERS

Line 2505: ' select 1 from MSC_PARAMETERS '

2501:
2502: lv_exist:= 0;
2503:
2504: OPEN c_org_exist FOR
2505: ' select 1 from MSC_PARAMETERS '
2506: ||' where ORGANIZATION_ID = :sr_tp_id '
2507: ||' and SR_INSTANCE_ID = :instance_id ' USING c_rec.SR_TP_ID, c_rec.SR_INSTANCE_ID;
2508:
2509: FETCH c_org_exist into lv_exist ;

Line 2513: INSERT INTO MSC_PARAMETERS

2509: FETCH c_org_exist into lv_exist ;
2510: CLOSE c_org_exist;
2511:
2512: IF lv_exist = 0 THEN
2513: INSERT INTO MSC_PARAMETERS
2514: ( ORGANIZATION_ID,
2515: SR_INSTANCE_ID,
2516: DEMAND_TIME_FENCE_FLAG,
2517: PLANNING_TIME_FENCE_FLAG,

Line 3047: --DELETE FROM MSC_PARAMETERS

3043: BEGIN
3044:
3045: --IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3046:
3047: --DELETE FROM MSC_PARAMETERS
3048: -- WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
3049: --END IF;
3050:
3051: FOR c_rec IN c1 LOOP

Line 3055: UPDATE MSC_PARAMETERS

3051: FOR c_rec IN c1 LOOP
3052:
3053: BEGIN
3054:
3055: UPDATE MSC_PARAMETERS
3056: SET
3057: DEMAND_TIME_FENCE_FLAG= c_rec.DEMAND_TIME_FENCE_FLAG,
3058: PLANNING_TIME_FENCE_FLAG= c_rec.PLANNING_TIME_FENCE_FLAG,
3059: OPERATION_SCHEDULE_TYPE= c_rec.OPERATION_SCHEDULE_TYPE,

Line 3087: INSERT INTO MSC_PARAMETERS

3083: -- AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
3084:
3085: IF SQL%NOTFOUND THEN
3086:
3087: INSERT INTO MSC_PARAMETERS
3088: ( ORGANIZATION_ID,
3089: DEMAND_TIME_FENCE_FLAG,
3090: PLANNING_TIME_FENCE_FLAG,
3091: OPERATION_SCHEDULE_TYPE,

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

3155:
3156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3157: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3158: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PARAMETER');
3159: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARAMETERS');
3160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3161:
3162: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3163: RAISE;

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

3168:
3169: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3170: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3171: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PARAMETER');
3172: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PARAMETERS');
3173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3174:
3175: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3176: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');