eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_TRADING_PARTNERS

Line 15012: REM| 1. msc_st_trading_partners |

15008: REM| DESCRIPTION |
15009: REM| |
15010: REM| This procedure updates the following table : |
15011: REM| |
15012: REM| 1. msc_st_trading_partners |
15013: REM| |
15014: REM| Input Parameters |
15015: REM| p_org_id - Organization_id |
15016: REM| p_cal_code - Calendar_code |

Line 15047: UPDATE MSC_ST_TRADING_PARTNERS

15043:
15044: stmt_no := 32;
15045: -- The Following Update statement the Trading Parters table with the
15046: -- Calendar Code for the Organization that uses the Calendar.
15047: UPDATE MSC_ST_TRADING_PARTNERS
15048: SET calendar_code = p_cal_code,
15049: organization_type = 2
15050: WHERE sr_tp_id = p_org_id
15051: AND partner_type = 3;

Line 17160: MSC_ST_TRADING_PARTNERS with the Calendar Code for a given Organization

17156:
17157: IF plsqltbl_rec(k).calendar_id = fetch_cal THEN
17158:
17159: /* Calling the Update Trading Partner Procedure,which updates the
17160: MSC_ST_TRADING_PARTNERS with the Calendar Code for a given Organization
17161: Id
17162: */
17163: stmt_no := 50;
17164: update_trading_partners(plsqltbl_rec(k).organization_id,

Line 17266: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS '

17262:
17263: /* B5001619 Rajesh All the process orgs should have organization_type=2 */
17264: BEGIN
17265: stmt_no := 67 ;
17266: Upd_Process_Org := 'UPDATE MSC_ST_TRADING_PARTNERS '
17267: ||' SET organization_type = 2 '
17268: ||' WHERE sr_tp_id in (SELECT organization_id '
17269: ||' FROM mtl_parameters'||p_db_link
17270: ||' WHERE process_enabled_flag = '||''''||'Y'||'''' || ')'