APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_CALENDAR_ASSIGNMENTS

Line 321: --for loading in MSC_CALENDAR_ASSIGNMENTS

317: -- data before processing Acknowledgment records.
318: -- =================================================
319: PROCEDURE LOAD_CALENDAR_SET_UP IS
320:
321: --for loading in MSC_CALENDAR_ASSIGNMENTS
322: CURSOR c7 IS
323: SELECT distinct
324: msca.ASSOCIATION_TYPE,
325: msca.CALENDAR_CODE,

Line 796: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDAR_ASSIGNMENTS', MSC_CL_COLLECTION.v_instance_id, NULL);

792: --Collection of Calendar Assignments in case of complete, targeted and continuous refresh modes only..
793:
794: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh OR MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
795:
796: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDAR_ASSIGNMENTS', MSC_CL_COLLECTION.v_instance_id, NULL);
797:
798:
799: FOR c_rec IN c7 LOOP
800:

Line 803: INSERT INTO MSC_CALENDAR_ASSIGNMENTS

799: FOR c_rec IN c7 LOOP
800:
801: BEGIN
802:
803: INSERT INTO MSC_CALENDAR_ASSIGNMENTS
804: ( ASSOCIATION_TYPE,
805: CALENDAR_CODE,
806: CALENDAR_TYPE,
807: PARTNER_ID,

Line 849: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_ASSIGNMENTS');

845:
846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
847: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
848: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
849: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_ASSIGNMENTS');
850: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
852: RAISE;
853:

Line 860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_ASSIGNMENTS');

856:
857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_ASSIGNMENTS');
861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
862: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
863: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');
864: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CALENDAR_CODE);