APPS.MSC_CL_COLLECTION dependencies on MSC_COLL_PARAMETERS

Line 214: FROM msc_coll_parameters

210:
211:
212: SELECT nvl(COLLECTIONS_START_TIME,sysdate)
213: INTO lv_collection_start_time
214: FROM msc_coll_parameters
215: where instance_id = pINSTANCE_ID;
216: /* For Bug 6141966 */
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' last asl refresh time is '|| lv_collection_start_time); --ASL
218: END IF;

Line 276: from msc_coll_parameters

272:
273: --============= For Bug 6126924
274:
275: SELECT PULL_WRKR_START_TIME into lv_COLL_PULL_START_TIME
276: from msc_coll_parameters
277: where INSTANCE_ID = pINSTANCE_ID;
278:
279: UPDATE msc_apps_instances
280: SET PULL_WRKR_START_TIME = lv_COLL_PULL_START_TIME,

Line 1139: -- DELETE FROM msc_coll_parameters

1135: WHERE mai.INSTANCE_ID= v_instance_id;
1136:
1137: --- PREPLACE CHANGE START ---
1138:
1139: -- DELETE FROM msc_coll_parameters
1140: -- WHERE instance_id = v_instance_id;
1141:
1142:
1143: --- PREPLACE CHANGE END ---

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

3379: BEGIN
3380: p_TIMEOUT := pTIMEOUT;
3381: msc_util.print_ods_params(pRECALC_SH,pPURGE_SH);
3382: /*5896618*/
3383: Select decode(nra,2,2,1) into lv_pRECALC_NRA_NEW from msc_coll_parameters
3384: where instance_id = pINSTANCE_ID;
3385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Recalculate NRA : '||lv_pRECALC_NRA_NEW);
3386: /*5896618*/
3387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Monitor running in dsMode= '||to_char(v_DSMode));

Line 3419: from msc_coll_parameters

3415:
3416: BEGIN
3417: select po, sales_order
3418: into lv_po_flag, lv_sales_order_flag
3419: from msc_coll_parameters
3420: where instance_id=pINSTANCE_ID;
3421: END;
3422:
3423: v_req_ext_po_so_linking := FALSE;

Line 3543: update msc_coll_parameters

3539: /* added this piece of code for Bug: 2015868, the recalculation of Resource availability and
3540: Sourcing history needs to be set in Planning ODS load only, for Partial Refresh
3541: It will behave same as in complete refresh coll*/
3542:
3543: update msc_coll_parameters
3544: set SOURCING_HISTORY = pRECALC_SH
3545: where instance_id = pINSTANCE_ID;
3546:
3547: --MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* calling above */

Line 4593: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

4589: COMMIT;
4590:
4591: /* SCE Change Ends */
4592:
4593: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
4594: -- by calling the procedure FINAL
4595:
4596: FINAL;
4597:

Line 5611: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

5607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ERRBUF);
5608:
5609: RETCODE := MSC_UTIL.G_ERROR;
5610:
5611: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
5612: -- by calling the procedure FINAL
5613:
5614: FINAL;
5615:

Line 6467: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

6463: COMMIT;
6464:
6465: /* SCE Change Ends */
6466:
6467: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
6468: -- by calling the procedure FINAL
6469:
6470: FINAL;
6471:

Line 6508: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

6504: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
6505: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
6506: END IF;
6507:
6508: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
6509: -- by calling the procedure FINAL
6510:
6511: FINAL;
6512: RETCODE := MSC_UTIL.G_ERROR;

Line 6535: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

6531: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
6532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
6533: END IF;
6534:
6535: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
6536: -- by calling the procedure FINAL
6537:
6538: FINAL;
6539: RETCODE := MSC_UTIL.G_ERROR;

Line 6561: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

6557: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
6558: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
6559: END IF;
6560:
6561: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
6562: -- by calling the procedure FINAL
6563:
6564: FINAL;
6565: RETCODE := MSC_UTIL.G_ERROR;

Line 6586: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS

6582: IF NOT MSC_CL_EXCHANGE_PARTTBL.UNDO_STG_ODS_SWAP THEN
6583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' Exchange partition failed ');
6584: END IF;
6585:
6586: -- DELETE SESSION INFO FROM MSC_COLL_PARAMETERS
6587: -- by calling the procedure FINAL
6588:
6589: FINAL;
6590: ERRBUF := SQLERRM;