eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_COLLECTION dependencies on MSC_CL_SETUP_ODS_LOAD

Line 399: /* procedure LINK_SUPPLY_TOP_LINK_IDhas been moved to package MSC_CL_SETUP_ODS_LOAD

395:
396: /* procedure IS_SUPPLIES_LOAD_DONE has been moved to package MSC_CL_SUPPLY_ODS_LOAD
397: through bug5952569 */
398:
399: /* procedure LINK_SUPPLY_TOP_LINK_IDhas been moved to package MSC_CL_SETUP_ODS_LOAD
400: through bug5952569 */
401:
402: /* ds change chaneg end */
403:

Line 792: /* procedure CLEANSE_DATA been moved to package MSC_CL_SETUP_ODS_LOAD

788: through bug5952569 */
789:
790:
791:
792: /* procedure CLEANSE_DATA been moved to package MSC_CL_SETUP_ODS_LOAD
793: through bug5952569 */
794:
795: PROCEDURE TRUNCATE_MSC_TABLE( p_table_name IN VARCHAR2) IS
796:

Line 962: /* procedure TRANSFORM_KEYS has been moved to package MSC_CL_SETUP_ODS_LOAD

958:
959: END INITIALIZE_LOAD_GLOBALS;
960:
961:
962: /* procedure TRANSFORM_KEYS has been moved to package MSC_CL_SETUP_ODS_LOAD
963: through bug5952569 */
964:
965: FUNCTION SET_ST_STATUS( ERRBUF OUT NOCOPY VARCHAR2,
966: RETCODE OUT NOCOPY NUMBER,

Line 1567: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');

1563:
1564: ELSIF pTASKNUM= TASK_CALENDAR_DATE THEN
1565:
1566: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1567: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1569: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
1570:
1571: ELSIF pTASKNUM= TASK_ITEM THEN

Line 1569: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;

1565:
1566: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1567: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1569: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
1570:
1571: ELSIF pTASKNUM= TASK_ITEM THEN
1572:
1573: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1587: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');

1583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1584: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
1585:
1586: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1587: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1589: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT;
1590:
1591: ELSIF pTASKNUM= TASK_ABC_CLASSES THEN

Line 1589: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT;

1585:
1586: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1587: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1589: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT;
1590:
1591: ELSIF pTASKNUM= TASK_ABC_CLASSES THEN
1592:
1593: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1670: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ; */

1666: /* FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1667: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
1668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1669: LOAD_SUPPLIER_CAPACITY;
1670: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ; */
1671:
1672: /* SCE Change starts */
1673: /* ODS load for Customer cross reference Items */
1674: ELSIF pTASKNUM= TASK_ITEM_CUSTOMERS THEN

Line 2366: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;

2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2364: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2365: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2366: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2367: END IF ;
2368:
2369: ELSIF pTASKNUM= PTASK_ITEM THEN
2370:

Line 2382: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;

2378: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2381: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2382: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2383: END IF ;
2384:
2385: ELSIF pTASKNUM= PTASK_ABC_CLASSES THEN
2386:

Line 2402: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');

2398:
2399: ELSIF pTASKNUM= PTASK_TRADING_PARTNER THEN
2400:
2401: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2402: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
2403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2404: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
2405:
2406: ELSIF pTASKNUM= PTASK_BOM_COMPONENTS THEN

Line 2404: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;

2400:
2401: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2402: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
2403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2404: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
2405:
2406: ELSIF pTASKNUM= PTASK_BOM_COMPONENTS THEN
2407:
2408: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2461: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;

2457: -- The call to the procedure LOAD_RESOURCE is being
2458: -- moved inside the procedure LOAD_CALENDAR_DATE.
2459:
2460: if (v_coll_prec.calendar_flag = MSC_UTIL.SYS_NO) then
2461: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
2462: end if;
2463:
2464: ELSIF pTASKNUM= PTASK_OP_RESOURCE_SEQ THEN
2465:

Line 2994: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');

2990:
2991: ELSIF pTASKNUM= PTASK_UOM THEN
2992:
2993: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2994: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2996: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
2997:
2998: ELSIF pTASKNUM= PTASK_ATP_RULES THEN

Line 2996: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;

2992:
2993: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2994: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2996: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
2997:
2998: ELSIF pTASKNUM= PTASK_ATP_RULES THEN
2999:
3000: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');

3011:
3012: ELSIF pTASKNUM= PTASK_CALENDAR_DATE THEN
3013:
3014: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3017: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
3018:
3019: ELSIF pTASKNUM= PTASK_DEMAND_CLASS THEN

Line 3017: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;

3013:
3014: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
3016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3017: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
3018:
3019: ELSIF pTASKNUM= PTASK_DEMAND_CLASS THEN
3020:
3021: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3079: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');

3075:
3076: ELSIF pTASKNUM= PTASK_PARAMETER THEN
3077:
3078: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3079: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
3080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3081: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
3082:
3083: ELSIF pTASKNUM= PTASK_PLANNERS THEN

Line 3081: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;

3077:
3078: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3079: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
3080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3081: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
3082:
3083: ELSIF pTASKNUM= PTASK_PLANNERS THEN
3084:
3085: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3568: /* procedure LOAD_CALENDAR_SET_UP has been moved to package MSC_CL_SETUP_ODS_LOAD

3564:
3565:
3566:
3567:
3568: /* procedure LOAD_CALENDAR_SET_UP has been moved to package MSC_CL_SETUP_ODS_LOAD
3569: through bug5952569 */
3570:
3571: /* procedure LOAD_CALENDAR_DATE has been moved to package MSC_CL_SETUP_ODS_LOAD
3572: through bug5952569 */

Line 3571: /* procedure LOAD_CALENDAR_DATE has been moved to package MSC_CL_SETUP_ODS_LOAD

3567:
3568: /* procedure LOAD_CALENDAR_SET_UP has been moved to package MSC_CL_SETUP_ODS_LOAD
3569: through bug5952569 */
3570:
3571: /* procedure LOAD_CALENDAR_DATE has been moved to package MSC_CL_SETUP_ODS_LOAD
3572: through bug5952569 */
3573:
3574: /*ds change change start */
3575:

Line 3699: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* cursor org requires the org group flag */

3695: v_so_exchange_mode := pSO_EXCHANGE_MODE;
3696:
3697: v_prec_defined := FALSE;
3698:
3699: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* cursor org requires the org group flag */
3700:
3701: -- to initialize common global variables bug#5897346
3702: MSC_UTIL.INITIALIZE_COMMON_GLOBALS( pINSTANCE_ID);
3703:

Line 3774: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID);

3770: -- agmcont
3771: --EXECUTE_TASK( lv_task_status, lv_task_number);
3772: IF (v_is_partial_refresh or v_is_incremental_refresh or
3773: v_is_cont_refresh or (v_coll_prec.ds_mode = MSC_UTIL.SYS_YES) ) THEN
3774: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID);
3775:
3776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Execute Partial Task for task number: '||lv_task_number);
3777: EXECUTE_PARTIAL_TASK( lv_task_status, lv_task_number,
3778: v_coll_prec);

Line 4009: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* cursor org requires the org group flag */

4005: END IF;
4006:
4007: v_prec_defined := FALSE;
4008:
4009: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* cursor org requires the org group flag */
4010: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Monitor running in DSMODE = '||to_char(v_coll_prec.ds_mode));
4011:
4012: -- to initialize common global variables bug#5897346
4013: MSC_UTIL.INITIALIZE_COMMON_GLOBALS( pINSTANCE_ID);

Line 4148: --MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* calling above */

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 */
4149: END IF;
4150:
4151: /* CP changes start */
4152: /* Find out the MSC:Configuration profile option value. */

Line 4286: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

4282: /* Following step does the data cleanup in staging tables and creates
4283: global Ids for Trading Partner and Items.
4284:
4285: If MSC:Configuration = 'APS' then
4286: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
4287: - TRANSFORM KEYS
4288:
4289: If MSC:Configuration = 'APS+SCE' or 'SCE' then
4290: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

Line 4290: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

4286: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
4287: - TRANSFORM KEYS
4288:
4289: If MSC:Configuration = 'APS+SCE' or 'SCE' then
4290: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
4291: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
4292: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
4293: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
4294: */

Line 4300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');

4296: /* DEBUG */
4297: if v_is_incremental_refresh THEN MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Incremental Refresh'); end if;
4298:
4299: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');
4301: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA
4302: /* SCE CHANGE starts */
4303: /* Data cleanup based on MSC:Configuration profile option */
4304: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,

Line 4301: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA

4297: if v_is_incremental_refresh THEN MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Incremental Refresh'); end if;
4298:
4299: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');
4301: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA
4302: /* SCE CHANGE starts */
4303: /* Data cleanup based on MSC:Configuration profile option */
4304: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
4305: v_my_company_name)

Line 4319: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

4315: v_coll_prec.tp_customer_flag)
4316:
4317: /* SCE CHANGE ends */
4318:
4319: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
4320:
4321: COMMIT;
4322:
4323:

Line 4342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');

4338:
4339: END IF;
4340:
4341: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
4342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');
4343: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
4344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');
4345: COMMIT;
4346: ELSE

Line 4343: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

4339: END IF;
4340:
4341: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
4342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');
4343: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
4344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');
4345: COMMIT;
4346: ELSE
4347: FND_MESSAGE.SET_NAME('MSC','MSC_CL_TRANSFORM_KEY_ERR');

Line 4344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');

4340:
4341: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
4342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');
4343: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
4344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA and MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS ');
4345: COMMIT;
4346: ELSE
4347: FND_MESSAGE.SET_NAME('MSC','MSC_CL_TRANSFORM_KEY_ERR');
4348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, FND_MESSAGE.GET);

Line 4386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');

4382: -- ============ Load Orgnization, Designator, UOM ==============
4383: /* load trading_partner first to provide organization_code information */
4384:
4385: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
4387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4388: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
4389:
4390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');

Line 4388: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;

4384:
4385: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
4387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4388: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
4389:
4390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
4391:
4392: /* SCE Change starts */

Line 4390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');

4386: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
4387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4388: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
4389:
4390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
4391:
4392: /* SCE Change starts */
4393: /* By this time Trading Partners , Organizations are loaded into planning area
4394: as well as collaboration area.

Line 4417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');

4413: /* Load parameters in the Main ODS Load so that this information is available to the function
4414: CALC_RESOURCE_AVAILABILITY called within LOAD_CALENDAR_DATE */
4415:
4416: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
4418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4419: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
4420:
4421: COMMIT;

Line 4419: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;

4415:
4416: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4417: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
4418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4419: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
4420:
4421: COMMIT;
4422:
4423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');

Line 4423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');

4419: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
4420:
4421: COMMIT;
4422:
4423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
4424: /* SCE Change starts */
4425:
4426: /* Populate msc_st_item_suppliers with company_id and company_site_id
4427: This step is required only if MSC:Configuration = 'SCE' or 'APS + SCE'

Line 4480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');

4476:
4477: /* load unit of measure */
4478:
4479: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
4481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4482: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
4483:
4484: COMMIT;

Line 4482: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;

4478:
4479: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
4481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4482: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
4483:
4484: COMMIT;
4485:
4486: /* CP-ACK starts */

Line 4492: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');

4488: -- We will also load Calendar Dates as Set up entity.
4489: -- We need to do these changes since CP code refers to Calendar
4490: -- ============================================================
4491: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4492: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
4493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4494: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
4495:
4496: /* CP-ACK ends */

Line 4494: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;

4490: -- ============================================================
4491: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4492: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
4493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4494: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
4495:
4496: /* CP-ACK ends */
4497:
4498: IF v_is_complete_refresh THEN

Line 4895: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN

4891: END IF;
4892:
4893: /* ds change start */
4894: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
4895: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN
4896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'update of msc_supplies top_transaction_id for eam is successful.....');
4897: ELSE
4898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in update of msc_supplies top_transaction_id......');
4899: RETCODE := MSC_UTIL.G_WARNING;

Line 5212: --MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec

5208: BEGIN
5209: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
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',

Line 5435: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (p_instance_id);

5431: PTASK_DEMAND NUMBER;
5432:
5433: BEGIN
5434:
5435: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (p_instance_id);
5436:
5437: IF (v_coll_prec.app_supp_cap_flag = MSC_UTIL.SYS_YES or v_coll_prec.app_supp_cap_flag = MSC_UTIL.ASL_YES_RETAIN_CP) THEN
5438: IF (p_task_num = PTASK_SUPPLIER_CAPACITY ) THEN
5439: RETURN TRUE;

Line 5914: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID, v_coll_prec);

5910: v_so_exchange_mode:= MSC_UTIL.SYS_NO;
5911:
5912: -- agmcont:
5913: -- move this from below
5914: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID, v_coll_prec);
5915:
5916: if (v_is_cont_refresh) then
5917: -- set so refresh flags
5918: if (v_coll_prec.so_sn_flag = MSC_UTIL.SYS_INCR) then

Line 6042: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

6038: /* Following step does the data cleanup in staging tables and creates
6039: global Ids for Trading Partner and Items.
6040:
6041: If MSC:Configuration = 'APS' then
6042: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
6043: - TRANSFORM KEYS
6044:
6045: If MSC:Configuration = 'APS+SCE' or 'SCE' then
6046: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

Line 6046: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

6042: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
6043: - TRANSFORM KEYS
6044:
6045: If MSC:Configuration = 'APS+SCE' or 'SCE' then
6046: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
6047: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
6048: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
6049: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
6050: */

Line 6054: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA THEN

6050: */
6051:
6052: /* added code to call cleanse Data when Targeted Collections is running */
6053:
6054: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA THEN
6055:
6056: COMMIT;
6057:
6058: ELSE

Line 6103: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

6099: v_coll_prec.tp_customer_flag)
6100:
6101: /* SCE CHANGE ends */
6102:
6103: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
6104:
6105: COMMIT;
6106:
6107: ELSE

Line 6127: IF MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

6123:
6124:
6125: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
6126:
6127: IF MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
6128: -- IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
6129: -- Do we do the CLEANSE of DATA or not for Partial replacement.
6130:
6131: COMMIT;

Line 6128: -- IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

6124:
6125: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
6126:
6127: IF MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
6128: -- IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
6129: -- Do we do the CLEANSE of DATA or not for Partial replacement.
6130:
6131: COMMIT;
6132:

Line 6178: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');

6174: commit;
6175: end if;
6176:
6177: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6178: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
6179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6180: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
6181:
6182: /* SCE Change starts */

Line 6180: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;

6176:
6177: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6178: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
6179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6180: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
6181:
6182: /* SCE Change starts */
6183: /* By this time Trading Partners , Organizations are loaded into planning area as well as collaboration area. Now we can populate the
6184: msc_trading_partner_maps table.

Line 6218: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');

6214:
6215: IF v_coll_prec.parameter_flag = MSC_UTIL.SYS_YES THEN
6216:
6217: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6218: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
6219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6220: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
6221: END IF;
6222:

Line 6220: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;

6216:
6217: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6218: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
6219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6220: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
6221: END IF;
6222:
6223: COMMIT;
6224:

Line 6292: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');

6288: v_is_partial_refresh := FALSE;
6289: end if;
6290:
6291: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6292: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
6293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6294: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
6295:
6296: COMMIT;

Line 6294: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;

6290:
6291: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6292: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
6293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6294: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
6295:
6296: COMMIT;
6297:
6298: END IF;

Line 6313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');

6309: v_is_partial_refresh := FALSE;
6310: end if;
6311:
6312: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
6314: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6315: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
6316:
6317: END IF;

Line 6315: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;

6311:
6312: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6313: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
6314: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6315: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
6316:
6317: END IF;
6318:
6319: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'LAUNCH_MON_PARTIAL: Deleting MSC_NET_RESOURCE_AVAIL...');

Line 6798: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN

6794: END IF; -- partial_refresh
6795:
6796: /* ds change start */
6797: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
6798: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN
6799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'update of msc_supplies top_transaction_id for eam is successful.....');
6800: ELSE
6801: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Error in update of msc_supplies top_transaction_id......');
6802: RETCODE := MSC_UTIL.G_WARNING;

Line 6881: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID, v_coll_prec);

6877: END IF;
6878: END IF;
6879:
6880: IF v_exchange_mode= MSC_UTIL.SYS_YES THEN
6881: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID, v_coll_prec);
6882: IF NOT MSC_CL_EXCHANGE_PARTTBL.Exchange_Partition
6883: (v_coll_prec,
6884: v_is_cont_refresh) THEN
6885: /* Only those tables that have partial

Line 7117: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec

7113: BEGIN
7114:
7115: IF (v_cp_enabled= MSC_UTIL.SYS_YES ) THEN
7116:
7117: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec
7118: IF ( (v_coll_prec.mps_flag = MSC_UTIL.SYS_YES) or
7119: (v_coll_prec.po_flag = MSC_UTIL.SYS_YES) or
7120: (v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) or
7121: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) or

Line 7185: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec

7181: ELSIF v_is_cont_refresh THEN
7182: BEGIN
7183: IF (v_cp_enabled= MSC_UTIL.SYS_YES ) THEN
7184:
7185: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec
7186: IF ( (v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and v_coll_prec.mps_sn_flag=MSC_UTIL.SYS_TGT ) or
7187: (v_coll_prec.po_flag = MSC_UTIL.SYS_YES and v_coll_prec.po_sn_flag=MSC_UTIL.SYS_TGT) or
7188: (v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and v_coll_prec.oh_sn_flag=MSC_UTIL.SYS_TGT) or
7189: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and v_coll_prec.wip_sn_flag=MSC_UTIL.SYS_TGT) or

Line 7575: MSC_CL_SETUP_ODS_LOAD.GENERATE_TRADING_PARTNER_KEYS (ERRBUF,RETCODE,pINSTANCE_ID);

7571: RETCODE OUT NOCOPY NUMBER,
7572: pINSTANCE_ID IN NUMBER) IS
7573: BEGIN
7574:
7575: MSC_CL_SETUP_ODS_LOAD.GENERATE_TRADING_PARTNER_KEYS (ERRBUF,RETCODE,pINSTANCE_ID);
7576:
7577: END GENERATE_TRADING_PARTNER_KEYS;
7578:
7579:

Line 7608: /* procedure CLEAN_LIAB_AGREEMENT has been moved to package MSC_CL_SETUP_ODS_LOAD

7604: MSC_UTIL.SYS_NO);
7605: ERRBUF := lERRBUF;
7606: RETCODE := lRETCODE ;
7607: END LAUNCH_MONITOR_DET_SCH;
7608: /* procedure CLEAN_LIAB_AGREEMENT has been moved to package MSC_CL_SETUP_ODS_LOAD
7609: through bug5952569 */
7610:
7611: PROCEDURE alter_temp_table (ERRBUF OUT NOCOPY VARCHAR2,
7612: RETCODE OUT NOCOPY NUMBER,