DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on CM_CLDR_DTL

Line 2063: * pCalendar_code - Calendar code set in cm_cldr_dtl

2059: * PROCEDURE
2060: * Run_status_update
2061: *
2062: * Parameter Input
2063: * pCalendar_code - Calendar code set in cm_cldr_dtl
2064: * pPeriod_code - Period code set in cm_cldr_dtl
2065: * pCost_mthd_code - Cost_mthd_code from cm_cldr_hdr
2066: *
2067: * Parameters Output

Line 2064: * pPeriod_code - Period code set in cm_cldr_dtl

2060: * Run_status_update
2061: *
2062: * Parameter Input
2063: * pCalendar_code - Calendar code set in cm_cldr_dtl
2064: * pPeriod_code - Period code set in cm_cldr_dtl
2065: * pCost_mthd_code - Cost_mthd_code from cm_cldr_hdr
2066: *
2067: * Parameters Output
2068: *

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

2073: * Description
2074: *
2075: * Procedure is used by costing to update the GMD tables with frozen status.
2076: * This procedure is registered as a concurrent program
2077: * Whenever costing updates the period status in cm_cldr_dtl table
2078: * from 0 to 1 , the trigger fires and submits a request for a
2079: * concurrent job.
2080: *
2081: * History

Line 2123: SELECT count(*) FROM cm_cldr_dtl

2119: Cost_mthd_code = pCost_mthd_code AND
2120: ROLLOVER_IND = 1;
2121:
2122: CURSOR Get_Period_Status IS
2123: SELECT count(*) FROM cm_cldr_dtl
2124: WHERE Calendar_code = pCalendar_code AND
2125: Period_code = pPeriod_code AND
2126: period_status = 1;
2127: