[Home] [Help]
3631: /* SCE CHANGE starts*/
3632:
3633: -- =============================================
3634: -- Change the company name in msc_companies and
3635: -- msc_trading_partners if it is changed in
3636: -- MSC : Operator Company Name profile option.
3637: -- =============================================
3638:
3639:
3878:
3879: /* CP-ACK ends */
3880:
3881: IF v_is_complete_refresh THEN
3882: msc_analyse_tables_pk.analyse_table( 'MSC_TRADING_PARTNERS');
3883: msc_analyse_tables_pk.analyse_table( 'MSC_DESIGNATORS');
3884: END IF;
3885:
3886:
5221:
5222: /* SCE CHANGE starts*/
5223: -- =============================================
5224: -- Change the company name in msc_companies and
5225: -- msc_trading_partners if it is cheanged in
5226: -- MSC : Operator Company Name profile option.
5227: -- =============================================
5228:
5229: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
6602:
6603: /*************** PREPLACE CHANGE END *****************/
6604:
6605: /* added this procedure for the conc program - Create Instance-Org Supplier Association
6606: This conc program updates the Msc_trading_partners table with the Modeleed Supplier info */
6607:
6608: PROCEDURE ENTER_MODELLED_INFO( ERRBUF OUT NOCOPY VARCHAR2,
6609: RETCODE OUT NOCOPY NUMBER,
6610: pINSTANCE_ID IN NUMBER,
6616: BEGIN
6617:
6618: IF ( (pSUPPLIER_ID IS NULL) AND (pSUPPLIER_SITE_ID IS NULL) ) THEN
6619:
6620: UPDATE msc_trading_partners
6621: SET MODELED_SUPPLIER_ID = null,
6622: MODELED_SUPPLIER_SITE_ID = null,
6623: ORG_SUPPLIER_MAPPED = 'N',
6624: ACCEPT_DEMANDS_FROM_UNMET_PO = null
6635: RETCODE := MSC_UTIL.G_SUCCESS ;
6636:
6637: ELSE
6638:
6639: UPDATE msc_trading_partners
6640: SET MODELED_SUPPLIER_ID = pSUPPLIER_ID,
6641: MODELED_SUPPLIER_SITE_ID = pSUPPLIER_SITE_ID,
6642: ORG_SUPPLIER_MAPPED = 'Y',
6643: ACCEPT_DEMANDS_FROM_UNMET_PO = pACCEPT_DEMANDS_FROM_UNMET_PO