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 SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 479: ' INSERT INTO MSC_CALENDAR_DATES '

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

Line 566: UPDATE MSC_CALENDAR_DATES

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

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

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

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

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

Line 663: DELETE MSC_CALENDAR_DATES

659: CLOSE c1;
660: COMMIT;
661:
662:
663: DELETE MSC_CALENDAR_DATES
664: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
665: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
666:
667: COMMIT;

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

665: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
666:
667: COMMIT;
668:
669: msc_analyse_tables_pk.analyse_table( 'MSC_CALENDAR_DATES');
670:
671:
672: END IF;
673: