APPS.GMF_VALIDATIONS_PVT dependencies on MTL_ORGANIZATIONS

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

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

Line 2471: p_organization_id IN mtl_organizations.organization_id%TYPE,

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

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

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

Line 2538: p_organization_id IN mtl_organizations.organization_id%TYPE

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

Line 2558: l_organization_id mtl_organizations.organization_id%TYPE;

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

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

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

Line 2616: l_organization_id mtl_organizations.organization_id%TYPE;

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

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

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

Line 2658: p_organization_id IN mtl_organizations.organization_id%TYPE

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

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

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

Line 2719: p_organization_id IN mtl_organizations.organization_id%TYPE

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

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

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

Line 2783: p_organization_id IN mtl_organizations.organization_id%TYPE

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