[Home] [Help]
117: ELSE
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'Launching CP to alter table - ' || c_rec.table_name);
119:
120: lv_req_id.EXTEND(1);
121: lv_request_id := FND_REQUEST.SUBMIT_REQUEST
122: (lv_msc_schema, -- appln short name
123: 'MSCALTBL', -- short name of conc pgm
124: NULL, -- description
125: NULL, -- start date
328: l_dev_status varchar2(80);
329: l_message varchar2(2048);
330: BEGIN
331:
332: lvs_request_id := FND_REQUEST.SUBMIT_REQUEST(
333: 'MSC',
334: 'MSCPDCP',
335: NULL, -- description
336: NULL, -- start date
4524: IF v_cp_enabled= MSC_UTIL.SYS_YES THEN
4525:
4526: FOR lc_i IN 1..pTotalWorkerNum LOOP
4527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'before launching worker:' || to_char(lc_i));
4528: lvs_request_id(lc_i) := FND_REQUEST.SUBMIT_REQUEST(
4529: 'MSC',
4530: 'MSCPDCW',
4531: NULL, -- description
4532: NULL, -- start date
5159: IF v_is_complete_refresh THEN
5160:
5161: BEGIN
5162: IF (v_cp_enabled= MSC_UTIL.SYS_YES AND v_is_so_complete_refresh ) THEN
5163: lv_atp_request_id := FND_REQUEST.SUBMIT_REQUEST(
5164: 'MSC',
5165: 'MSCCLCNC',
5166: NULL, -- description
5167: NULL, -- start date
5171: MSC_UTIL.SYS_YES, -- Refresh SO Complete
5172: MSC_UTIL.SYS_YES); -- Refresh Supply/Demand
5173: END IF;
5174: IF (v_cp_enabled= MSC_UTIL.SYS_YES AND v_is_so_incremental_refresh ) THEN
5175: lv_atp_request_id := FND_REQUEST.SUBMIT_REQUEST(
5176: 'MSC',
5177: 'MSCCLCNC',
5178: NULL, -- description
5179: NULL, -- start date
5210: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
5211:
5212: --MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec
5213:
5214: lv_sce_pub_req_id := FND_REQUEST.SUBMIT_REQUEST(
5215: 'MSC',
5216: 'MSCXPUBO',
5217: NULL, -- description
5218: NULL, -- start date
5246:
5247:
5248: IF (pAPCC_refresh = MSC_UTIL.SYS_YES) THEN
5249: IF (v_is_partial_refresh) THEN
5250: l_req_id := fnd_request.submit_request(
5251: 'MSC',
5252: 'MSCHUBO',
5253: NULL,
5254: NULL,
5257: 2,
5258: NULL);
5259:
5260: ELSIF (v_is_complete_refresh) THEN
5261: l_req_id := fnd_request.submit_request(
5262: 'MSC',
5263: 'MSCHUBO',
5264: NULL,
5265: NULL,
6344:
6345: IF v_cp_enabled= MSC_UTIL.SYS_YES THEN
6346:
6347: FOR lc_i IN 1..pTotalWorkerNum LOOP
6348: lvs_request_id(lc_i) := FND_REQUEST.SUBMIT_REQUEST(
6349: 'MSC',
6350: 'MSCPDCW',
6351: NULL, -- description
6352: NULL, -- start date
7134: ELSE
7135: lv_refresh_so := MSC_UTIL.SYS_NO;
7136: END IF;
7137:
7138: lv_atp_request_id := FND_REQUEST.SUBMIT_REQUEST(
7139: 'MSC',
7140: 'MSCCLCNC',
7141: NULL, -- description
7142: NULL, -- start date
7159: /* ATP SUMMARY CHANGES CALL THE PROGRAMS MSCCLCNC For Incremental refresh collections */
7160:
7161: BEGIN
7162: IF v_cp_enabled= MSC_UTIL.SYS_YES THEN
7163: lv_atp_request_id := FND_REQUEST.SUBMIT_REQUEST(
7164: 'MSC',
7165: 'MSCCLCNC',
7166: NULL, -- description
7167: NULL, -- start date
7204: END IF;
7205:
7206: IF (lv_refresh_sd = MSC_UTIL.SYS_YES OR lv_refresh_so = MSC_UTIL.SYS_YES ) THEN
7207:
7208: lv_atp_request_id := FND_REQUEST.SUBMIT_REQUEST(
7209: 'MSC',
7210: 'MSCCLCNC',
7211: NULL, -- description
7212: NULL, -- start date
7217: lv_refresh_sd); -- Refresh Supply/Demand
7218:
7219: ELSE
7220:
7221: lv_atp_request_id := FND_REQUEST.SUBMIT_REQUEST(
7222: 'MSC',
7223: 'MSCCLCNC',
7224: NULL, -- description
7225: NULL, -- start date
7263:
7264: -- agmcont
7265: IF (v_cp_enabled= MSC_UTIL.SYS_YES) THEN
7266:
7267: lv_sce_pub_req_id := FND_REQUEST.SUBMIT_REQUEST(
7268: 'MSC',
7269: 'MSCXPUBO',
7270: NULL, -- description
7271: NULL, -- start date
7309:
7310:
7311: IF (pAPCC_refresh = MSC_UTIL.SYS_YES) THEN
7312: IF (v_is_partial_refresh) THEN
7313: l_req_id := fnd_request.submit_request(
7314: 'MSC',
7315: 'MSCHUBO',
7316: NULL,
7317: NULL,
7320: 2,
7321: NULL);
7322:
7323: ELSIF (v_is_complete_refresh) THEN
7324: l_req_id := fnd_request.submit_request(
7325: 'MSC',
7326: 'MSCHUBO',
7327: NULL,
7328: NULL,