APPS.GMF_VALIDATIONS_PVT dependencies on CM_CLDR_DTL

Line 200: --| on cm_cldr_dtl |

196: --| Validates Period Code |
197: --| |
198: --| DESCRIPTION |
199: --| This function validates that the Period Code exists in |
200: --| on cm_cldr_dtl |
201: --| |
202: --| PARAMETERS |
203: --| p_calendar_code IN VARCHAR2(4) - Calendar Method Code |
204: --| p_period_code IN VARCHAR2(4) - Period Code |

Line 218: p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE,

214:
215: PROCEDURE Validate_Period_Code
216: (
217: p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE,
218: p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE,
219: x_Period_Status OUT NOCOPY cm_cldr_dtl.period_status%TYPE
220: )
221: IS
222: CURSOR cur_cm_cldr_dtl

Line 219: x_Period_Status OUT NOCOPY cm_cldr_dtl.period_status%TYPE

215: PROCEDURE Validate_Period_Code
216: (
217: p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE,
218: p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE,
219: x_Period_Status OUT NOCOPY cm_cldr_dtl.period_status%TYPE
220: )
221: IS
222: CURSOR cur_cm_cldr_dtl
223: IS

Line 222: CURSOR cur_cm_cldr_dtl

218: p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE,
219: x_Period_Status OUT NOCOPY cm_cldr_dtl.period_status%TYPE
220: )
221: IS
222: CURSOR cur_cm_cldr_dtl
223: IS
224: SELECT
225: period_status
226: FROM

Line 227: cm_cldr_dtl

223: IS
224: SELECT
225: period_status
226: FROM
227: cm_cldr_dtl
228: WHERE
229: calendar_code = p_calendar_code
230: AND period_code = p_period_code
231: AND delete_mark = 0;

Line 235: OPEN cur_cm_cldr_dtl;

231: AND delete_mark = 0;
232:
233: BEGIN
234:
235: OPEN cur_cm_cldr_dtl;
236: FETCH cur_cm_cldr_dtl INTO x_period_status;
237: CLOSE cur_cm_cldr_dtl;
238: /*
239: IF (cur_cm_cldr_dtl%NOTFOUND)

Line 236: FETCH cur_cm_cldr_dtl INTO x_period_status;

232:
233: BEGIN
234:
235: OPEN cur_cm_cldr_dtl;
236: FETCH cur_cm_cldr_dtl INTO x_period_status;
237: CLOSE cur_cm_cldr_dtl;
238: /*
239: IF (cur_cm_cldr_dtl%NOTFOUND)
240: THEN

Line 237: CLOSE cur_cm_cldr_dtl;

233: BEGIN
234:
235: OPEN cur_cm_cldr_dtl;
236: FETCH cur_cm_cldr_dtl INTO x_period_status;
237: CLOSE cur_cm_cldr_dtl;
238: /*
239: IF (cur_cm_cldr_dtl%NOTFOUND)
240: THEN
241: CLOSE cur_cm_cldr_dtl;

Line 239: IF (cur_cm_cldr_dtl%NOTFOUND)

235: OPEN cur_cm_cldr_dtl;
236: FETCH cur_cm_cldr_dtl INTO x_period_status;
237: CLOSE cur_cm_cldr_dtl;
238: /*
239: IF (cur_cm_cldr_dtl%NOTFOUND)
240: THEN
241: CLOSE cur_cm_cldr_dtl;
242: RETURN FALSE;
243: ELSE

Line 241: CLOSE cur_cm_cldr_dtl;

237: CLOSE cur_cm_cldr_dtl;
238: /*
239: IF (cur_cm_cldr_dtl%NOTFOUND)
240: THEN
241: CLOSE cur_cm_cldr_dtl;
242: RETURN FALSE;
243: ELSE
244: CLOSE cur_cm_cldr_dtl;
245: RETURN TRUE;

Line 244: CLOSE cur_cm_cldr_dtl;

240: THEN
241: CLOSE cur_cm_cldr_dtl;
242: RETURN FALSE;
243: ELSE
244: CLOSE cur_cm_cldr_dtl;
245: RETURN TRUE;
246: END IF;
247: */
248: EXCEPTION

Line 2460: * p_period_code IN cm_cldr_dtl.period_code%TYPE *

2456: * *
2457: * PARAMETERS *
2458: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2459: * p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE *
2460: * p_period_code IN cm_cldr_dtl.period_code%TYPE *
2461: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *
2462: * *
2463: * RETURNS *
2464: * Period Id *

Line 2473: p_period_code IN cm_cldr_dtl.period_code%TYPE,

2469: FUNCTION Validate_period_code
2470: (
2471: p_organization_id IN mtl_organizations.organization_id%TYPE,
2472: p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE,
2473: p_period_code IN cm_cldr_dtl.period_code%TYPE,
2474: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
2475: )
2476: RETURN NUMBER
2477: IS