[Home] [Help]
2196: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2197: lv_tbl:= 'RESOURCE_INSTANCE_REQS_'||MSC_CL_COLLECTION.v_instance_code;
2198: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2199: ELSE
2200: lv_tbl:= 'MSC_RESOURCE_INSTANCE_REQS';
2201: lv_supplies_tbl:= 'MSC_SUPPLIES';
2202: END IF;
2203:
2204: lv_cursor_stmt:=
2261: ||' CREATION_DATE,'
2262: ||' CREATED_BY)'
2263: ||'VALUES'
2264: ||'( -1,'
2265: ||' MSC_RESOURCE_INSTANCE_REQS_S.NEXTVAL,'
2266: ||' :SR_INSTANCE_ID,'
2267: ||' :ORGANIZATION_ID,'
2268: ||' :DEPARTMENT_ID,'
2269: ||' :SUPPLY_ID,'
2313: ||' CREATION_DATE,'
2314: ||' CREATED_BY)'
2315: ||' SELECT '
2316: ||' -1,'
2317: ||' MSC_RESOURCE_INSTANCE_REQS_S.NEXTVAL,'
2318: ||' msrir.SR_INSTANCE_ID,'
2319: ||' msrir.ORGANIZATION_ID,'
2320: ||' msrir.DEPARTMENT_ID,'
2321: ||' NVL(ms.TRANSACTION_ID,-1) SUPPLY_ID,'
2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2364: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2368: RAISE;
2370: ELSE
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2372: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2376:
2377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2378:
2390:
2391: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2392:
2393: FOR c_rec IN res_inst_req_d LOOP
2394: DELETE MSC_RESOURCE_INSTANCE_REQS
2395: WHERE PLAN_ID = -1
2396: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
2397: AND WIP_ENTITY_ID = c_rec.WIP_ENTITY_ID
2398: AND OPERATION_SEQ_NUM = NVL( c_rec.OPERATION_SEQ_NUM, OPERATION_SEQ_NUM)
2437:
2438: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2439: /* we can get rid of thsi update and just insert as we are puting
2440: record in ad table when instance is updated */
2441: UPDATE MSC_RESOURCE_INSTANCE_REQS mrir
2442: SET
2443: START_DATE = lv_START_DATE,
2444: RESOURCE_INSTANCE_HOURS= lv_OPERATION_HOURS_REQUIRED ,
2445: END_DATE = lv_END_DATE,
2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2506: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2508:
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2510: RAISE;
2515:
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2517: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2518: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2519: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2521:
2522: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2523:
2561:
2562: lv_tbl:= 'RESOURCE_INSTANCE_REQS_'||MSC_CL_COLLECTION.v_instance_code;
2563: lv_sql_stmt:=
2564: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2565: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_RESOURCE_INSTANCE_REQS'
2566: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2567: ||' AND plan_id = -1 '
2568: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2569:
2583:
2584: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2585: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2586: lv_retcode,
2587: 'MSC_RESOURCE_INSTANCE_REQS',
2588: MSC_CL_COLLECTION.v_instance_code,
2589: MSC_UTIL.G_WARNING
2590: );
2591: