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 391: /* procedure LINK_SUPPLY_TOP_LINK_IDhas been moved to package MSC_CL_SETUP_ODS_LOAD

387:
388: /* procedure IS_SUPPLIES_LOAD_DONE has been moved to package MSC_CL_SUPPLY_ODS_LOAD
389: through bug5952569 */
390:
391: /* procedure LINK_SUPPLY_TOP_LINK_IDhas been moved to package MSC_CL_SETUP_ODS_LOAD
392: through bug5952569 */
393:
394: /* ds change chaneg end */
395:

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

780: through bug5952569 */
781:
782:
783:
784: /* procedure CLEANSE_DATA been moved to package MSC_CL_SETUP_ODS_LOAD
785: through bug5952569 */
786:
787: PROCEDURE TRUNCATE_MSC_TABLE( p_table_name IN VARCHAR2) IS
788:

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

950:
951: END INITIALIZE_LOAD_GLOBALS;
952:
953:
954: /* procedure TRANSFORM_KEYS has been moved to package MSC_CL_SETUP_ODS_LOAD
955: through bug5952569 */
956:
957: FUNCTION SET_ST_STATUS( ERRBUF OUT NOCOPY VARCHAR2,
958: RETCODE OUT NOCOPY NUMBER,

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

1522:
1523: ELSIF pTASKNUM= TASK_CALENDAR_DATE THEN
1524:
1525: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1528: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
1529:
1530: ELSIF pTASKNUM= TASK_ITEM THEN

Line 1528: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;

1524:
1525: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1528: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
1529:
1530: ELSIF pTASKNUM= TASK_ITEM THEN
1531:
1532: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

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

1542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1543: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
1544:
1545: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1546: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1548: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT;
1549:
1550: ELSIF pTASKNUM= TASK_ABC_CLASSES THEN

Line 1548: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT;

1544:
1545: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1546: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1548: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT;
1549:
1550: ELSIF pTASKNUM= TASK_ABC_CLASSES THEN
1551:
1552: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1629: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ; */

1625: /* FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1626: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1628: LOAD_SUPPLIER_CAPACITY;
1629: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ; */
1630:
1631: /* SCE Change starts */
1632: /* ODS load for Customer cross reference Items */
1633: ELSIF pTASKNUM= TASK_ITEM_CUSTOMERS THEN

Line 2069: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;

2065: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2068: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2069: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2070: END IF ;
2071:
2072: ELSIF pTASKNUM= PTASK_ITEM THEN
2073:

Line 2085: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;

2081: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2084: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2085: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2086: END IF ;
2087:
2088: ELSIF pTASKNUM= PTASK_ABC_CLASSES THEN
2089:

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

2101:
2102: ELSIF pTASKNUM= PTASK_TRADING_PARTNER THEN
2103:
2104: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2107: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
2108:
2109: ELSIF pTASKNUM= PTASK_BOM_COMPONENTS THEN

Line 2107: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;

2103:
2104: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2107: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
2108:
2109: ELSIF pTASKNUM= PTASK_BOM_COMPONENTS THEN
2110:
2111: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2164: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;

2160: -- The call to the procedure LOAD_RESOURCE is being
2161: -- moved inside the procedure LOAD_CALENDAR_DATE.
2162:
2163: if (v_coll_prec.calendar_flag = MSC_UTIL.SYS_NO) then
2164: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
2165: end if;
2166:
2167: ELSIF pTASKNUM= PTASK_OP_RESOURCE_SEQ THEN
2168:

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

2636:
2637: ELSIF pTASKNUM= PTASK_UOM THEN
2638:
2639: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2640: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
2641: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2642: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
2643:
2644: ELSIF pTASKNUM= PTASK_ATP_RULES THEN

Line 2642: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;

2638:
2639: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2640: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
2641: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2642: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
2643:
2644: ELSIF pTASKNUM= PTASK_ATP_RULES THEN
2645:
2646: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2657:
2658: ELSIF pTASKNUM= PTASK_CALENDAR_DATE THEN
2659:
2660: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2661: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2663: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
2664:
2665: ELSIF pTASKNUM= PTASK_DEMAND_CLASS THEN

Line 2663: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;

2659:
2660: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2661: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE');
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2663: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_DATE;
2664:
2665: ELSIF pTASKNUM= PTASK_DEMAND_CLASS THEN
2666:
2667: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2721:
2722: ELSIF pTASKNUM= PTASK_PARAMETER THEN
2723:
2724: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2725: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
2726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2727: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
2728:
2729: ELSIF pTASKNUM= PTASK_PLANNERS THEN

Line 2727: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;

2723:
2724: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2725: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
2726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2727: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
2728:
2729: ELSIF pTASKNUM= PTASK_PLANNERS THEN
2730:
2731: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2967:
2968:
2969:
2970:
2971: /* procedure LOAD_CALENDAR_SET_UP has been moved to package MSC_CL_SETUP_ODS_LOAD
2972: through bug5952569 */
2973:
2974: /* procedure LOAD_CALENDAR_DATE has been moved to package MSC_CL_SETUP_ODS_LOAD
2975: through bug5952569 */

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

2970:
2971: /* procedure LOAD_CALENDAR_SET_UP has been moved to package MSC_CL_SETUP_ODS_LOAD
2972: through bug5952569 */
2973:
2974: /* procedure LOAD_CALENDAR_DATE has been moved to package MSC_CL_SETUP_ODS_LOAD
2975: through bug5952569 */
2976:
2977: /*ds change change start */
2978:

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

3098: v_so_exchange_mode := pSO_EXCHANGE_MODE;
3099:
3100: v_prec_defined := FALSE;
3101:
3102: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* cursor org requires the org group flag */
3103:
3104: -- to initialize common global variables bug#5897346
3105: MSC_UTIL.INITIALIZE_COMMON_GLOBALS( pINSTANCE_ID);
3106:

Line 3177: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID);

3173: -- agmcont
3174: --EXECUTE_TASK( lv_task_status, lv_task_number);
3175: IF (v_is_partial_refresh or v_is_incremental_refresh or
3176: v_is_cont_refresh or (v_coll_prec.ds_mode = MSC_UTIL.SYS_YES) ) THEN
3177: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID);
3178:
3179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Execute Partial Task for task number: '||lv_task_number);
3180: EXECUTE_PARTIAL_TASK( lv_task_status, lv_task_number,
3181: v_coll_prec);

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

3404: END IF;
3405:
3406: v_prec_defined := FALSE;
3407:
3408: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); /* cursor org requires the org group flag */
3409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Monitor running in DSMODE = '||to_char(v_coll_prec.ds_mode));
3410:
3411: -- to initialize common global variables bug#5897346
3412: MSC_UTIL.INITIALIZE_COMMON_GLOBALS( pINSTANCE_ID);

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

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 */
3548: END IF;
3549:
3550: /* CP changes start */
3551: /* Find out the MSC:Configuration profile option value. */

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

3679: /* Following step does the data cleanup in staging tables and creates
3680: global Ids for Trading Partner and Items.
3681:
3682: If MSC:Configuration = 'APS' then
3683: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
3684: - TRANSFORM KEYS
3685:
3686: If MSC:Configuration = 'APS+SCE' or 'SCE' then
3687: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

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

3683: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
3684: - TRANSFORM KEYS
3685:
3686: If MSC:Configuration = 'APS+SCE' or 'SCE' then
3687: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
3688: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
3689: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
3690: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
3691: */

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

3693: /* DEBUG */
3694: if v_is_incremental_refresh THEN MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Incremental Refresh'); end if;
3695:
3696: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
3697: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');
3698: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA
3699: /* SCE CHANGE starts */
3700: /* Data cleanup based on MSC:Configuration profile option */
3701: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,

Line 3698: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA

3694: if v_is_incremental_refresh THEN MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Incremental Refresh'); end if;
3695:
3696: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
3697: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');
3698: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA
3699: /* SCE CHANGE starts */
3700: /* Data cleanup based on MSC:Configuration profile option */
3701: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
3702: v_my_company_name)

Line 3716: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

3712: v_coll_prec.tp_customer_flag)
3713:
3714: /* SCE CHANGE ends */
3715:
3716: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
3717:
3718: COMMIT;
3719:
3720:

Line 3739: 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 ');

3735:
3736: END IF;
3737:
3738: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
3739: 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 ');
3740: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
3741: 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 ');
3742: COMMIT;
3743: ELSE

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

3736: END IF;
3737:
3738: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
3739: 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 ');
3740: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
3741: 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 ');
3742: COMMIT;
3743: ELSE
3744: FND_MESSAGE.SET_NAME('MSC','MSC_CL_TRANSFORM_KEY_ERR');

Line 3741: 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 ');

3737:
3738: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
3739: 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 ');
3740: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
3741: 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 ');
3742: COMMIT;
3743: ELSE
3744: FND_MESSAGE.SET_NAME('MSC','MSC_CL_TRANSFORM_KEY_ERR');
3745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, FND_MESSAGE.GET);

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

3779: -- ============ Load Orgnization, Designator, UOM ==============
3780: /* load trading_partner first to provide organization_code information */
3781:
3782: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3785: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
3786:
3787: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');

Line 3785: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;

3781:
3782: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3785: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
3786:
3787: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
3788:
3789: /* SCE Change starts */

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

3783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3785: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
3786:
3787: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
3788:
3789: /* SCE Change starts */
3790: /* By this time Trading Partners , Organizations are loaded into planning area
3791: as well as collaboration area.

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

3810: /* Load parameters in the Main ODS Load so that this information is available to the function
3811: CALC_RESOURCE_AVAILABILITY called within LOAD_CALENDAR_DATE */
3812:
3813: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3814: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
3815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3816: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
3817:
3818: COMMIT;

Line 3816: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;

3812:
3813: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3814: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
3815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3816: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
3817:
3818: COMMIT;
3819:
3820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');

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

3816: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
3817:
3818: COMMIT;
3819:
3820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
3821: /* SCE Change starts */
3822:
3823: /* Populate msc_st_item_suppliers with company_id and company_site_id
3824: This step is required only if MSC:Configuration = 'SCE' or 'APS + SCE'

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

3859:
3860: /* load unit of measure */
3861:
3862: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3863: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
3864: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3865: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
3866:
3867: COMMIT;

Line 3865: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;

3861:
3862: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3863: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
3864: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3865: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
3866:
3867: COMMIT;
3868:
3869: /* CP-ACK starts */

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

3871: -- We will also load Calendar Dates as Set up entity.
3872: -- We need to do these changes since CP code refers to Calendar
3873: -- ============================================================
3874: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3875: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
3876: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3877: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
3878:
3879: /* CP-ACK ends */

Line 3877: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;

3873: -- ============================================================
3874: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3875: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
3876: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3877: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
3878:
3879: /* CP-ACK ends */
3880:
3881: IF v_is_complete_refresh THEN

Line 4269: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN

4265: END IF;
4266:
4267: /* ds change start */
4268: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
4269: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN
4270: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'update of msc_supplies top_transaction_id for eam is successful.....');
4271: ELSE
4272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in update of msc_supplies top_transaction_id......');
4273: RETCODE := MSC_UTIL.G_WARNING;

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

4554: BEGIN
4555: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4556: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
4557:
4558: --MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec
4559:
4560: lv_sce_pub_req_id := FND_REQUEST.SUBMIT_REQUEST(
4561: 'MSC',
4562: 'MSCXPUBO',

Line 4744: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (p_instance_id);

4740: PTASK_DEMAND NUMBER;
4741:
4742: BEGIN
4743:
4744: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (p_instance_id);
4745:
4746: 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
4747: IF (p_task_num = PTASK_SUPPLIER_CAPACITY ) THEN
4748: RETURN TRUE;

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

5144: v_so_exchange_mode:= MSC_UTIL.SYS_NO;
5145:
5146: -- agmcont:
5147: -- move this from below
5148: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID, v_coll_prec);
5149:
5150: if (v_is_cont_refresh) then
5151: -- set so refresh flags
5152: if (v_coll_prec.so_sn_flag = MSC_UTIL.SYS_INCR) then

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

5272: /* Following step does the data cleanup in staging tables and creates
5273: global Ids for Trading Partner and Items.
5274:
5275: If MSC:Configuration = 'APS' then
5276: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
5277: - TRANSFORM KEYS
5278:
5279: If MSC:Configuration = 'APS+SCE' or 'SCE' then
5280: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)

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

5276: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
5277: - TRANSFORM KEYS
5278:
5279: If MSC:Configuration = 'APS+SCE' or 'SCE' then
5280: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
5281: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
5282: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
5283: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
5284: */

Line 5288: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA THEN

5284: */
5285:
5286: /* added code to call cleanse Data when Targeted Collections is running */
5287:
5288: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA THEN
5289:
5290: COMMIT;
5291:
5292: ELSE

Line 5337: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

5333: v_coll_prec.tp_customer_flag)
5334:
5335: /* SCE CHANGE ends */
5336:
5337: AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
5338:
5339: COMMIT;
5340:
5341: ELSE

Line 5361: IF MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN

5357:
5358:
5359: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
5360:
5361: IF MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
5362: -- IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
5363: -- Do we do the CLEANSE of DATA or not for Partial replacement.
5364:
5365: COMMIT;

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

5358:
5359: ELSIF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS THEN
5360:
5361: IF MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
5362: -- IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA AND MSC_CL_SETUP_ODS_LOAD.TRANSFORM_KEYS THEN
5363: -- Do we do the CLEANSE of DATA or not for Partial replacement.
5364:
5365: COMMIT;
5366:

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

5408: commit;
5409: end if;
5410:
5411: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5412: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
5413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5414: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
5415:
5416: /* SCE Change starts */

Line 5414: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;

5410:
5411: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5412: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER');
5413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5414: MSC_CL_SETUP_ODS_LOAD.LOAD_TRADING_PARTNER;
5415:
5416: /* SCE Change starts */
5417: /* By this time Trading Partners , Organizations are loaded into planning area as well as collaboration area. Now we can populate the
5418: msc_trading_partner_maps table.

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

5448:
5449: IF v_coll_prec.parameter_flag = MSC_UTIL.SYS_YES THEN
5450:
5451: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5452: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
5453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5454: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
5455: END IF;
5456:

Line 5454: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;

5450:
5451: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5452: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER');
5453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5454: MSC_CL_SETUP_ODS_LOAD.LOAD_PARAMETER;
5455: END IF;
5456:
5457: COMMIT;
5458:

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

5508: v_is_partial_refresh := FALSE;
5509: end if;
5510:
5511: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
5513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5514: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
5515:
5516: COMMIT;

Line 5514: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;

5510:
5511: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5512: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_UOM');
5513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5514: MSC_CL_SETUP_ODS_LOAD.LOAD_UOM;
5515:
5516: COMMIT;
5517:
5518: END IF;

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

5529: v_is_partial_refresh := FALSE;
5530: end if;
5531:
5532: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5533: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
5534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5535: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
5536:
5537: END IF;

Line 5535: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;

5531:
5532: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5533: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP');
5534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5535: MSC_CL_SETUP_ODS_LOAD.LOAD_CALENDAR_SET_UP;
5536:
5537: END IF;
5538:
5539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'LAUNCH_MON_PARTIAL: Deleting MSC_NET_RESOURCE_AVAIL...');

Line 6006: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN

6002: END IF; -- partial_refresh
6003:
6004: /* ds change start */
6005: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN
6006: IF MSC_CL_SETUP_ODS_LOAD.LINK_SUPPLY_TOP_LINK_ID THEN
6007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'update of msc_supplies top_transaction_id for eam is successful.....');
6008: ELSE
6009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Error in update of msc_supplies top_transaction_id......');
6010: RETCODE := MSC_UTIL.G_WARNING;

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

6067: --log_message ('successfully altered phase 2 tables');
6068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'successfully altered phase 2 tables.' );
6069: END IF;
6070:
6071: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID, v_coll_prec);
6072: IF NOT MSC_CL_EXCHANGE_PARTTBL.Exchange_Partition
6073: (v_coll_prec,
6074: v_is_cont_refresh) THEN
6075: /* Only those tables that have partial

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

6276: BEGIN
6277:
6278: IF (v_cp_enabled= MSC_UTIL.SYS_YES ) THEN
6279:
6280: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec
6281: IF ( (v_coll_prec.mps_flag = MSC_UTIL.SYS_YES) or
6282: (v_coll_prec.po_flag = MSC_UTIL.SYS_YES) or
6283: (v_coll_prec.oh_flag = MSC_UTIL.SYS_YES) or
6284: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) or

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

6344: ELSIF v_is_cont_refresh THEN
6345: BEGIN
6346: IF (v_cp_enabled= MSC_UTIL.SYS_YES ) THEN
6347:
6348: MSC_CL_SETUP_ODS_LOAD.GET_COLL_PARAM (pINSTANCE_ID); -- This will initialze the record v_coll_prec
6349: IF ( (v_coll_prec.mps_flag = MSC_UTIL.SYS_YES and v_coll_prec.mps_sn_flag=MSC_UTIL.SYS_TGT ) or
6350: (v_coll_prec.po_flag = MSC_UTIL.SYS_YES and v_coll_prec.po_sn_flag=MSC_UTIL.SYS_TGT) or
6351: (v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and v_coll_prec.oh_sn_flag=MSC_UTIL.SYS_TGT) or
6352: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and v_coll_prec.wip_sn_flag=MSC_UTIL.SYS_TGT) or

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

6696: RETCODE OUT NOCOPY NUMBER,
6697: pINSTANCE_ID IN NUMBER) IS
6698: BEGIN
6699:
6700: MSC_CL_SETUP_ODS_LOAD.GENERATE_TRADING_PARTNER_KEYS (ERRBUF,RETCODE,pINSTANCE_ID);
6701:
6702: END GENERATE_TRADING_PARTNER_KEYS;
6703:
6704:

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

6727: MSC_UTIL.SYS_NO); -------lv_PURGE_SH);
6728: ERRBUF := lERRBUF;
6729: RETCODE := lRETCODE ;
6730: END LAUNCH_MONITOR_DET_SCH;
6731: /* procedure CLEAN_LIAB_AGREEMENT has been moved to package MSC_CL_SETUP_ODS_LOAD
6732: through bug5952569 */
6733:
6734: PROCEDURE alter_temp_table (ERRBUF OUT NOCOPY VARCHAR2,
6735: RETCODE OUT NOCOPY NUMBER,