APPS.GMD_COMMON_VAL dependencies on CM_CMPT_DTL

Line 2041: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

2037: * *********************************************************************** */
2038:
2039: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2040: p_retcode OUT NOCOPY VARCHAR2,
2041: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2042: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2043: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS
2044:
2045: x_return_status VARCHAR2(1) := 'S';

Line 2042: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,

2038:
2039: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2040: p_retcode OUT NOCOPY VARCHAR2,
2041: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2042: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2043: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS
2044:
2045: x_return_status VARCHAR2(1) := 'S';
2046: l_Recipe_Id NUMBER;

Line 2043: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS

2039: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2040: p_retcode OUT NOCOPY VARCHAR2,
2041: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2042: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2043: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS
2044:
2045: x_return_status VARCHAR2(1) := 'S';
2046: l_Recipe_Id NUMBER;
2047: l_formula_Id NUMBER;

Line 2058: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl

2054: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;
2055: VRList VRtbl;
2056:
2057: CURSOR FROZEN_EFF_CUR IS
2058: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl
2059: WHERE Calendar_code = pCalendar_code AND
2060: Period_code = pPeriod_code AND
2061: Cost_mthd_code = pCost_mthd_code AND
2062: ROLLOVER_IND = 1;