APPS.GMF_VALIDATIONS_PVT dependencies on GMF_PERIOD_STATUSES

Line 2339: * p_period_id IN gmf_period_statuses.period_id%TYPE *

2335: * DESCRIPTION *
2336: * This function validates that the Period Id exists *
2337: * *
2338: * PARAMETERS *
2339: * p_period_id IN gmf_period_statuses.period_id%TYPE *
2340: * *
2341: * RETURNS *
2342: * TRUE - If Period Exists *
2343: * FALSE - If Period Doesnt Exist *

Line 2350: p_period_id IN gmf_period_statuses.period_id%TYPE

2346: * 20-Oct-2005 Anand Thiyagarajan - Created *
2347: ***************************************************************************************/
2348: FUNCTION Validate_period_id
2349: (
2350: p_period_id IN gmf_period_statuses.period_id%TYPE
2351: )
2352: RETURN BOOLEAN
2353: IS
2354:

Line 2362: FROM gmf_period_statuses

2358:
2359: CURSOR Cur_period
2360: IS
2361: SELECT period_id
2362: FROM gmf_period_statuses
2363: WHERE period_id = p_period_id;
2364:
2365: /******************
2366: * Local Variables *

Line 2369: l_period_id gmf_period_statuses.period_id%TYPE;

2365: /******************
2366: * Local Variables *
2367: ******************/
2368:
2369: l_period_id gmf_period_statuses.period_id%TYPE;
2370:
2371: BEGIN
2372: OPEN Cur_period;
2373: FETCH Cur_period INTO l_period_id;

Line 2398: * p_period_id IN gmf_period_statuses.period_id%TYPE *

2394: * DESCRIPTION *
2395: * This function validates that the Period Id exists *
2396: * *
2397: * PARAMETERS *
2398: * p_period_id IN gmf_period_statuses.period_id%TYPE *
2399: * *
2400: * RETURNS *
2401: * TRUE - If Period Exists *
2402: * FALSE - If Period Doesnt Exist *

Line 2409: p_period_id IN gmf_period_statuses.period_id%TYPE,

2405: * 20-Oct-2005 Anand Thiyagarajan - Created *
2406: ***************************************************************************************/
2407: FUNCTION Validate_period_id
2408: (
2409: p_period_id IN gmf_period_statuses.period_id%TYPE,
2410: p_cost_type_id OUT NOCOPY gmf_period_statuses.cost_type_id%TYPE
2411: )
2412: RETURN BOOLEAN
2413: IS

Line 2410: p_cost_type_id OUT NOCOPY gmf_period_statuses.cost_type_id%TYPE

2406: ***************************************************************************************/
2407: FUNCTION Validate_period_id
2408: (
2409: p_period_id IN gmf_period_statuses.period_id%TYPE,
2410: p_cost_type_id OUT NOCOPY gmf_period_statuses.cost_type_id%TYPE
2411: )
2412: RETURN BOOLEAN
2413: IS
2414:

Line 2422: FROM gmf_period_statuses

2418:
2419: CURSOR Cur_period
2420: IS
2421: SELECT period_id, cost_type_id
2422: FROM gmf_period_statuses
2423: WHERE period_id = p_period_id;
2424:
2425: /******************
2426: * Local Variables *

Line 2429: l_period_id gmf_period_statuses.period_id%TYPE;

2425: /******************
2426: * Local Variables *
2427: ******************/
2428:
2429: l_period_id gmf_period_statuses.period_id%TYPE;
2430:
2431: BEGIN
2432: OPEN Cur_period;
2433: FETCH Cur_period INTO l_period_id, p_cost_type_id;

Line 2486: FROM gmf_period_statuses a,

2482:
2483: CURSOR Cur_period
2484: IS
2485: SELECT period_id
2486: FROM gmf_period_statuses a,
2487: org_organization_definitions b
2488: WHERE b.organization_id = p_organization_id
2489: AND b.legal_entity = a.legal_entity_id
2490: AND a.calendar_code = p_calendar_code

Line 2498: l_period_id gmf_period_statuses.period_id%TYPE;

2494: /******************
2495: * Local Variables *
2496: ******************/
2497:
2498: l_period_id gmf_period_statuses.period_id%TYPE;
2499:
2500: BEGIN
2501: OPEN Cur_period;
2502: FETCH Cur_period INTO l_period_id;