APPS.MSC_E1APS_UTIL dependencies on MSC_CL_PRE_PROCESS

Line 653: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER

649: -- TO Update TP_SITE_CODE to BILL_TO
650: lv_sql_stmt :=
651: 'UPDATE msc_trading_partner_sites '
652: ||' SET TP_SITE_CODE = ''BILL_TO'' '
653: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER
654: ||' AND sr_instance_id = ' || parInstanceID
655: ||' AND partner_address like ''E1_BILL_TO%''';
656:
657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 665: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER

661: --TO Update TP_SITE_CODE to SHIP_TO
662: lv_sql_stmt :=
663: 'UPDATE msc_trading_partner_sites '
664: ||' SET TP_SITE_CODE = ''SHIP_TO'' '
665: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER
666: ||' AND sr_instance_id = ' || parInstanceID
667: ||' AND partner_address not like ''E1_BILL_TO%'''; -- Removed comment for bug# 12558193
668: -- OR partner_address is null )';
669:

Line 681: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER

677:
678: lv_sql_stmt :=
679: 'UPDATE msc_trading_partner_sites '
680: ||' SET TP_SITE_CODE = LOCATION '
681: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER
682: ||' AND sr_instance_id = ' || parInstanceID ;
683:
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
685: EXECUTE IMMEDIATE lv_sql_stmt;