APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_CALENDAR_DATES

Line 313: -- into MSC_CALENDAR_DATES tables.

309: /* CP-ACK starts */
310: --==================================================
311: -- PROCEDURE : LOAD_CALENDAR_SET_UP
312: -- This procedure will load all calendar dates
313: -- into MSC_CALENDAR_DATES tables.
314: -- These code lines were part of LOAD_CALENDAR_DATE
315: -- procedure but we are now seperating this since
316: -- PO Acknowledgment collections need Calendar Dates
317: -- data before processing Acknowledgment records.

Line 351: --If instance type is not 'others', then insert into msc_calendars those calendars present in msc_calendar_dates

347: AND mtil.SR_TP_ID(+)= msca.CARRIER_PARTNER_ID
348: AND mtil.PARTNER_TYPE(+)=4;
349:
350:
351: --If instance type is not 'others', then insert into msc_calendars those calendars present in msc_calendar_dates
352: CURSOR c5 IS
353: SELECT distinct
354: mscd.CALENDAR_CODE,
355: mscd.CALENDAR_START_DATE,

Line 371: FROM MSC_CALENDAR_DATES mscd

367: Min(CALENDAR_DATE) FIRST_WORKING_DATE,
368: Max(CALENDAR_DATE) LAST_WORKING_DATE,
369: CALENDAR_CODE,
370: SR_INSTANCE_ID
371: FROM MSC_CALENDAR_DATES mscd
372: WHERE mscd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
373: and seq_num is not null
374: GROUP BY CALENDAR_CODE, SR_INSTANCE_ID;
375:

Line 470: UPDATE MSC_CALENDAR_DATES

466:
467: -- Calendar Dates --
468:
469: if (MSC_CL_COLLECTION.v_is_partial_refresh or MSC_CL_COLLECTION.v_is_complete_refresh ) THEN
470: UPDATE MSC_CALENDAR_DATES
471: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
472: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
473: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
474: WHERE

Line 481: ' INSERT INTO MSC_CALENDAR_DATES '

477:
478:
479: COMMIT;
480: lv_sql_stmt :=
481: ' INSERT INTO MSC_CALENDAR_DATES '
482: ||'( CALENDAR_DATE, '
483: ||' CALENDAR_CODE, '
484: ||' SEQ_NUM, '
485: ||' NEXT_SEQ_NUM, '

Line 568: UPDATE MSC_CALENDAR_DATES

564: BEGIN
565:
566: --IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
567:
568: UPDATE MSC_CALENDAR_DATES
569: SET
570: SEQ_NUM= lb_SEQ_NUM(j),
571: NEXT_SEQ_NUM= lb_NEXT_SEQ_NUM(j),
572: PRIOR_SEQ_NUM= lb_PRIOR_SEQ_NUM(j),

Line 623: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_DATES');

619:
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
621: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
622: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
623: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_DATES');
624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
625:
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
627: RAISE;

Line 635: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_DATES');

631:
632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
633: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
634: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
635: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDAR_DATES');
636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
637:
638: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
639: FND_MESSAGE.SET_TOKEN('COLUMN', 'EXCEPTION_SET_ID');

Line 665: DELETE MSC_CALENDAR_DATES

661: CLOSE c1;
662: COMMIT;
663:
664:
665: DELETE MSC_CALENDAR_DATES
666: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
667: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
668: AND exception_set_id = -1;
669:

Line 672: msc_analyse_tables_pk.analyse_table( 'MSC_CALENDAR_DATES');

668: AND exception_set_id = -1;
669:
670: COMMIT;
671:
672: msc_analyse_tables_pk.analyse_table( 'MSC_CALENDAR_DATES');
673:
674:
675: END IF;
676: