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.

APPS.GMD_COMMON_VAL dependencies on CM_CLDR_DTL

Line 2005: * pCalendar_code - Calendar code set in cm_cldr_dtl

2001: * PROCEDURE
2002: * Run_status_update
2003: *
2004: * Parameter Input
2005: * pCalendar_code - Calendar code set in cm_cldr_dtl
2006: * pPeriod_code - Period code set in cm_cldr_dtl
2007: * pCost_mthd_code - Cost_mthd_code from cm_cldr_hdr
2008: *
2009: * Parameters Output

Line 2006: * pPeriod_code - Period code set in cm_cldr_dtl

2002: * Run_status_update
2003: *
2004: * Parameter Input
2005: * pCalendar_code - Calendar code set in cm_cldr_dtl
2006: * pPeriod_code - Period code set in cm_cldr_dtl
2007: * pCost_mthd_code - Cost_mthd_code from cm_cldr_hdr
2008: *
2009: * Parameters Output
2010: *

Line 2019: * Whenever costing updates the period status in cm_cldr_dtl table

2015: * Description
2016: *
2017: * Procedure is used by costing to update the GMD tables with frozen status.
2018: * This procedure is registered as a concurrent program
2019: * Whenever costing updates the period status in cm_cldr_dtl table
2020: * from 0 to 1 , the trigger fires and submits a request for a
2021: * concurrent job.
2022: *
2023: * History

Line 2065: SELECT count(*) FROM cm_cldr_dtl

2061: Cost_mthd_code = pCost_mthd_code AND
2062: ROLLOVER_IND = 1;
2063:
2064: CURSOR Get_Period_Status IS
2065: SELECT count(*) FROM cm_cldr_dtl
2066: WHERE Calendar_code = pCalendar_code AND
2067: Period_code = pPeriod_code AND
2068: period_status = 1;
2069: