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 799: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDAR_ASSIGNMENTS', MSC_CL_COLLECTION.v_instance_id, NULL);

795: --Collection of Calendar Assignments in case of complete, targeted and continuous refresh modes only..
796:
797: 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
798:
799: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDAR_ASSIGNMENTS', MSC_CL_COLLECTION.v_instance_id, NULL);
800:
801:
802: FOR c_rec IN c7 LOOP
803:

Line 806: INSERT INTO MSC_CALENDAR_ASSIGNMENTS

802: FOR c_rec IN c7 LOOP
803:
804: BEGIN
805:
806: INSERT INTO MSC_CALENDAR_ASSIGNMENTS
807: ( ASSOCIATION_TYPE,
808: CALENDAR_CODE,
809: CALENDAR_TYPE,
810: PARTNER_ID,

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

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

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

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