APPS.MSC_CL_COLLECTION dependencies on MSC_COLL_PARAMETERS

Line 222: FROM msc_coll_parameters

218:
219:
220: SELECT nvl(COLLECTIONS_START_TIME,sysdate)
221: INTO lv_collection_start_time
222: FROM msc_coll_parameters
223: where instance_id = pINSTANCE_ID;
224: /* For Bug 6141966 */
225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' last asl refresh time is '|| lv_collection_start_time); --ASL
226: END IF;

Line 284: from msc_coll_parameters

280:
281: --============= For Bug 6126924
282:
283: SELECT PULL_WRKR_START_TIME into lv_COLL_PULL_START_TIME
284: from msc_coll_parameters
285: where INSTANCE_ID = pINSTANCE_ID;
286:
287: UPDATE msc_apps_instances
288: SET PULL_WRKR_START_TIME = lv_COLL_PULL_START_TIME,

Line 1147: -- DELETE FROM msc_coll_parameters

1143: WHERE mai.INSTANCE_ID= v_instance_id;
1144:
1145: --- PREPLACE CHANGE START ---
1146:
1147: -- DELETE FROM msc_coll_parameters
1148: -- WHERE instance_id = v_instance_id;
1149:
1150:
1151: --- PREPLACE CHANGE END ---

Line 3984: Select decode(nra,2,2,1) into lv_pRECALC_NRA_NEW from msc_coll_parameters

3980: BEGIN
3981: p_TIMEOUT := pTIMEOUT;
3982: msc_util.print_ods_params(pRECALC_SH,pPURGE_SH);
3983: /*5896618*/
3984: Select decode(nra,2,2,1) into lv_pRECALC_NRA_NEW from msc_coll_parameters
3985: where instance_id = pINSTANCE_ID;
3986: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Recalculate NRA : '||lv_pRECALC_NRA_NEW);
3987: /*5896618*/
3988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Monitor running in dsMode= '||to_char(v_DSMode));

Line 4020: from msc_coll_parameters

4016:
4017: BEGIN
4018: select po, sales_order
4019: into lv_po_flag, lv_sales_order_flag
4020: from msc_coll_parameters
4021: where instance_id=pINSTANCE_ID;
4022: END;
4023:
4024: v_req_ext_po_so_linking := FALSE;

Line 4144: update msc_coll_parameters

4140: /* added this piece of code for Bug: 2015868, the recalculation of Resource availability and
4141: Sourcing history needs to be set in Planning ODS load only, for Partial Refresh
4142: It will behave same as in complete refresh coll*/
4143:
4144: update msc_coll_parameters
4145: set SOURCING_HISTORY = pRECALC_SH
4146: where instance_id = pINSTANCE_ID;
4147:
4148: --MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* calling above */

Line 5284: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

5280: -----end of changes for APCC refresh----------
5281:
5282: /* SCE Change Ends */
5283:
5284: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
5285: -- by calling the procedure FINAL
5286:
5287: FINAL;
5288:

Line 6393: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

6389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ERRBUF);
6390:
6391: RETCODE := MSC_UTIL.G_ERROR;
6392:
6393: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
6394: -- by calling the procedure FINAL
6395:
6396: FINAL;
6397:

Line 7304: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

7300: COMMIT;
7301:
7302: /* SCE Change Ends */
7303:
7304: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
7305: -- by calling the procedure FINAL
7306:
7307: -----Code changes for APCC refresh-----------
7308: BEGIN

Line 7383: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

7379: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
7380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
7381: END IF;
7382:
7383: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
7384: -- by calling the procedure FINAL
7385:
7386: FINAL;
7387: RETCODE := MSC_UTIL.G_ERROR;

Line 7410: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

7406: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
7407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
7408: END IF;
7409:
7410: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
7411: -- by calling the procedure FINAL
7412:
7413: FINAL;
7414: RETCODE := MSC_UTIL.G_ERROR;

Line 7436: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

7432: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
7433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
7434: END IF;
7435:
7436: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
7437: -- by calling the procedure FINAL
7438:
7439: FINAL;
7440: RETCODE := MSC_UTIL.G_ERROR;

Line 7461: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

7457: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
7458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
7459: END IF;
7460:
7461: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
7462: -- by calling the procedure FINAL
7463:
7464: FINAL;
7465: ERRBUF := SQLERRM;