APPS.GMF_VALIDATIONS_PVT dependencies on GMF_PERIOD_STATUSES

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

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

Line 2348: p_period_id IN gmf_period_statuses.period_id%TYPE

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

Line 2360: FROM gmf_period_statuses

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

Line 2367: l_period_id gmf_period_statuses.period_id%TYPE;

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

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

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

Line 2407: p_period_id IN gmf_period_statuses.period_id%TYPE,

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

Line 2408: p_cost_type_id OUT NOCOPY gmf_period_statuses.cost_type_id%TYPE

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

Line 2420: FROM gmf_period_statuses

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

Line 2427: l_period_id gmf_period_statuses.period_id%TYPE;

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

Line 2484: FROM gmf_period_statuses a,

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

Line 2496: l_period_id gmf_period_statuses.period_id%TYPE;

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