APPS.GMP_CALENDAR_PKG dependencies on MSC_ST_TRADING_PARTNERS

Line 846: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS'

842: */
843: /* B4751574 Rajesh All the process orgs should have organization_type=2 */
844: BEGIN
845: stmt_no := 29 ;
846: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS'
847: ||' SET organization_type = 2'
848: ||' WHERE sr_tp_id in (SELECT organization_id '
849: ||' FROM mtl_parameters'||p_db_link
850: ||' WHERE process_enabled_flag = '||''''||'Y'||'''' || ')'

Line 1054: REM| 1. msc_st_trading_partners |

1050: REM| DESCRIPTION |
1051: REM| |
1052: REM| This procedure updates the following table : |
1053: REM| |
1054: REM| 1. msc_st_trading_partners |
1055: REM| |
1056: REM| Input Parameters |
1057: REM| p_org_id - Organization_id |
1058: REM| p_cal_code - Calendar_code |

Line 1088: UPDATE MSC_ST_TRADING_PARTNERS

1084: END IF;
1085:
1086: -- The Following Update statement the Trading Parters table with the
1087: -- Calendar Code for the Organization that uses the Calendar.
1088: UPDATE MSC_ST_TRADING_PARTNERS
1089: -- No need to update calendar code B5926204 Rajesh Patangya
1090: -- SET calendar_code = p_cal_code,
1091: SET organization_type = 2
1092: WHERE sr_tp_id = p_org_id