APPS.MSC_CL_COPY_STG_TBL dependencies on MSC_COLL_PARAMETERS

Line 486: -- msc_coll_parameters

482: pINSTANCE_ID IN NUMBER) IS
483: BEGIN
484:
485: -- First delete the existing record for that instance from
486: -- msc_coll_parameters
487:
488: DELETE FROM MSC_COLL_PARAMETERS
489: WHERE
490: INSTANCE_ID = v_inst_rp_src_id;

Line 488: DELETE FROM MSC_COLL_PARAMETERS

484:
485: -- First delete the existing record for that instance from
486: -- msc_coll_parameters
487:
488: DELETE FROM MSC_COLL_PARAMETERS
489: WHERE
490: INSTANCE_ID = v_inst_rp_src_id;
491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'COPY_COLL_PARAMETERS');
492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'pInstance Id: '|| pINSTANCE_ID);

Line 495: 'INSERT INTO MSC_COLL_PARAMETERS ('

491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'COPY_COLL_PARAMETERS');
492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'pInstance Id: '|| pINSTANCE_ID);
493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'db link: '|| v_dblink);
494: v_sql_stmt:=
495: 'INSERT INTO MSC_COLL_PARAMETERS ('
496: || 'INSTANCE_ID,'
497: || 'DELETE_ODS_DATA,'
498: || 'SUPPLIER_CAPACITY,'
499: || 'ATP_RULES,'

Line 619: ||'FROM MSC_COLL_PARAMETERS'|| v_dblink

615: || 'TRIP_SN_FLAG,'
616: || 'SALES_CHANNEL,'
617: || 'FISCAL_CALENDAR,'
618: || 'PAYBACK_DEMAND_SUPPLY '
619: ||'FROM MSC_COLL_PARAMETERS'|| v_dblink
620: ||' WHERE '
621: ||' instance_id = ' || to_char(pINSTANCE_ID);
622:
623: EXECUTE IMMEDIATE v_sql_stmt USING v_inst_rp_src_id;

Line 632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Error copying msc_coll_parameters');

628: EXCEPTION
629: WHEN OTHERS THEN
630: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Error copying msc_coll_parameters');
633: v_retcode := 2;
634: RAISE;
635: ELSE
636: IF v_retcode < 2 THEN

Line 638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Warning copying msc_coll_parameters');

634: RAISE;
635: ELSE
636: IF v_retcode < 2 THEN
637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Warning copying msc_coll_parameters');
639: v_retcode := 1;
640: END IF;
641: RETURN;
642: END IF;