APPS.GMF_VALIDATIONS_PVT dependencies on CM_CLDR_DTL

Line 198: --| on cm_cldr_dtl |

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

Line 216: p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE,

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

Line 217: x_Period_Status OUT NOCOPY cm_cldr_dtl.period_status%TYPE

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

Line 220: CURSOR cur_cm_cldr_dtl

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

Line 225: cm_cldr_dtl

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

Line 233: OPEN cur_cm_cldr_dtl;

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

Line 234: FETCH cur_cm_cldr_dtl INTO x_period_status;

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

Line 235: CLOSE cur_cm_cldr_dtl;

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

Line 237: IF (cur_cm_cldr_dtl%NOTFOUND)

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

Line 239: CLOSE cur_cm_cldr_dtl;

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

Line 242: CLOSE cur_cm_cldr_dtl;

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

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

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

Line 2471: p_period_code IN cm_cldr_dtl.period_code%TYPE,

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