DBA Data[Home] [Help]

APPS.GMD_COMMON_VAL dependencies on CM_CMPT_DTL

Line 2099: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

2095: * *********************************************************************** */
2096:
2097: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2098: p_retcode OUT NOCOPY VARCHAR2,
2099: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2100: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2101: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS
2102:
2103: x_return_status VARCHAR2(1) := 'S';

Line 2100: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,

2096:
2097: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2098: p_retcode OUT NOCOPY VARCHAR2,
2099: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2100: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2101: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS
2102:
2103: x_return_status VARCHAR2(1) := 'S';
2104: l_Recipe_Id NUMBER;

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

2097: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2098: p_retcode OUT NOCOPY VARCHAR2,
2099: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2100: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2101: pCost_mthd_code IN cm_cmpt_dtl.cost_mthd_code%TYPE) IS
2102:
2103: x_return_status VARCHAR2(1) := 'S';
2104: l_Recipe_Id NUMBER;
2105: l_formula_Id NUMBER;

Line 2116: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl

2112: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;
2113: VRList VRtbl;
2114:
2115: CURSOR FROZEN_EFF_CUR IS
2116: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl
2117: WHERE Calendar_code = pCalendar_code AND
2118: Period_code = pPeriod_code AND
2119: Cost_mthd_code = pCost_mthd_code AND
2120: ROLLOVER_IND = 1;

Line 2920: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

2916:
2917: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2918: p_retcode OUT NOCOPY VARCHAR2,
2919: pLegal_entity_id IN number,
2920: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2921: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2922: pCost_type_id IN cm_cmpt_dtl.Cost_type_id%TYPE) IS
2923:
2924: x_return_status VARCHAR2(1) := 'S';

Line 2921: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,

2917: PROCEDURE Run_status_update( p_errbuf OUT NOCOPY VARCHAR2,
2918: p_retcode OUT NOCOPY VARCHAR2,
2919: pLegal_entity_id IN number,
2920: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2921: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2922: pCost_type_id IN cm_cmpt_dtl.Cost_type_id%TYPE) IS
2923:
2924: x_return_status VARCHAR2(1) := 'S';
2925: l_Recipe_Id NUMBER;

Line 2922: pCost_type_id IN cm_cmpt_dtl.Cost_type_id%TYPE) IS

2918: p_retcode OUT NOCOPY VARCHAR2,
2919: pLegal_entity_id IN number,
2920: pCalendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
2921: pPeriod_code IN cm_cmpt_dtl.period_code%TYPE,
2922: pCost_type_id IN cm_cmpt_dtl.Cost_type_id%TYPE) IS
2923:
2924: x_return_status VARCHAR2(1) := 'S';
2925: l_Recipe_Id NUMBER;
2926: l_formula_Id NUMBER;

Line 2945: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl

2941: Period_code = pPeriod_code AND
2942: Cost_type_id = pCost_type_id ;
2943:
2944: CURSOR FROZEN_EFF_CUR IS
2945: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl
2946: WHERE period_id = l_period_id AND
2947: cost_type_id = pCost_type_id AND
2948: ROLLOVER_IND = 1;
2949: