APPS.GMF_VALIDATIONS_PVT dependencies on MTL_ORGANIZATIONS

Line 2456: * p_organization_id IN mtl_organizations.organization_id%TYPE *

2452: * DESCRIPTION *
2453: * This function validates that the Period Code exists *
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: * *

Line 2469: p_organization_id IN mtl_organizations.organization_id%TYPE,

2465: * 20-Oct-2005 Anand Thiyagarajan - Created *
2466: ***************************************************************************************/
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: )

Line 2525: * p_organization_id IN mtl_organizations.organization_id%TYPE *

2521: * DESCRIPTION *
2522: * This function validates that the Organization Id exists *
2523: * *
2524: * PARAMETERS *
2525: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2526: * *
2527: * RETURNS *
2528: * TRUE - If Organization Exists *
2529: * FALSE - If Organization Doesnt Exist *

Line 2536: p_organization_id IN mtl_organizations.organization_id%TYPE

2532: * 20-Oct-2005 Anand Thiyagarajan - Created *
2533: ***************************************************************************************/
2534: FUNCTION Validate_organization_id
2535: (
2536: p_organization_id IN mtl_organizations.organization_id%TYPE
2537: )
2538: RETURN BOOLEAN
2539: IS
2540:

Line 2556: l_organization_id mtl_organizations.organization_id%TYPE;

2552: /******************
2553: * Local Variables *
2554: ******************/
2555:
2556: l_organization_id mtl_organizations.organization_id%TYPE;
2557:
2558: BEGIN
2559: OPEN Cur_organization;
2560: FETCH Cur_organization INTO l_organization_id;

Line 2585: * p_organization_code IN mtl_organizations.organization_code%TYPE *

2581: * DESCRIPTION *
2582: * This function validates that the Organization Code exists *
2583: * *
2584: * PARAMETERS *
2585: * p_organization_code IN mtl_organizations.organization_code%TYPE *
2586: * *
2587: * RETURNS *
2588: * Organization Id *
2589: * *

Line 2614: l_organization_id mtl_organizations.organization_id%TYPE;

2610: /******************
2611: * Local Variables *
2612: ******************/
2613:
2614: l_organization_id mtl_organizations.organization_id%TYPE;
2615:
2616: BEGIN
2617: OPEN Cur_organization;
2618: FETCH Cur_organization INTO l_organization_id;

Line 2644: * p_organization_id IN mtl_organizations.organization_id%TYPE *

2640: * This function validates that the Inventory Item Id exists *
2641: * *
2642: * PARAMETERS *
2643: * p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE*
2644: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2645: * *
2646: * RETURNS *
2647: * TRUE - If Item Exists *
2648: * FALSE - If Item Doesnt Exist *

Line 2656: p_organization_id IN mtl_organizations.organization_id%TYPE

2652: ***************************************************************************************/
2653: FUNCTION Validate_inventory_item_id
2654: (
2655: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
2656: p_organization_id IN mtl_organizations.organization_id%TYPE
2657: )
2658: RETURN BOOLEAN
2659: IS
2660:

Line 2705: * p_organization_id IN mtl_organizations.organization_id%TYPE *

2701: * DESCRIPTION *
2702: * This function validates that the Item Number exists *
2703: * *
2704: * PARAMETERS *
2705: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2706: * p_item_number IN mtl_item_flexfields.item_number%TYPE *
2707: * *
2708: * RETURNS *
2709: * Inventory Item Id *

Line 2717: p_organization_id IN mtl_organizations.organization_id%TYPE

2713: ***************************************************************************************/
2714: FUNCTION Validate_item_number
2715: (
2716: p_item_number IN mtl_item_flexfields.item_number%TYPE,
2717: p_organization_id IN mtl_organizations.organization_id%TYPE
2718: )
2719: RETURN NUMBER
2720: IS
2721:

Line 2767: * p_organization_id IN mtl_organizations.organization_id%TYPE *

2763: * This function validates that the Lot Number exists *
2764: * *
2765: * PARAMETERS *
2766: * p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE*
2767: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2768: * p_lot_number in mtl_lot_numbers.lot_number%TYPE *
2769: * *
2770: * RETURNS *
2771: * TRUE - If Lot Exists *

Line 2781: p_organization_id IN mtl_organizations.organization_id%TYPE

2777: FUNCTION Validate_Lot_Number
2778: (
2779: p_lot_number IN mtl_lot_numbers.lot_number%TYPE,
2780: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
2781: p_organization_id IN mtl_organizations.organization_id%TYPE
2782: )
2783: RETURN BOOLEAN
2784: IS
2785: