DBA Data[Home] [Help]

APPS.GMP_CALENDAR_PKG dependencies on MSC_ST_TRADING_PARTNERS

Line 618: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS'

614:
615: /* B4751574 Rajesh All the process orgs should have organization_type=2 */
616: BEGIN
617: stmt_no := 29 ;
618: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS'
619: ||' SET organization_type = 2'
620: ||' WHERE sr_tp_id in (SELECT organization_id '
621: ||' FROM mtl_parameters'||p_db_link
622: ||' WHERE process_enabled_flag = '||''''||'Y'||'''' || ')'

Line 812: REM| 1. msc_st_trading_partners |

808: REM| DESCRIPTION |
809: REM| |
810: REM| This procedure updates the following table : |
811: REM| |
812: REM| 1. msc_st_trading_partners |
813: REM| |
814: REM| Input Parameters |
815: REM| p_org_id - Organization_id |
816: REM| p_cal_code - Calendar_code |

Line 846: UPDATE MSC_ST_TRADING_PARTNERS

842: END IF;
843:
844: -- The Following Update statement the Trading Parters table with the
845: -- Calendar Code for the Organization that uses the Calendar.
846: UPDATE MSC_ST_TRADING_PARTNERS
847: -- No need to update calendar code B5926204 Rajesh Patangya
848: -- SET calendar_code = p_cal_code,
849: SET organization_type = 2
850: WHERE sr_tp_id = p_org_id