APPS.GMF_VALIDATIONS_PVT dependencies on GL_ALOC_MST

Line 1468: ( p_Alloc_Id IN gl_aloc_mst.Alloc_Id%TYPE

1464: --+==========================================================================+
1465: -- Func end of comments
1466:
1467: FUNCTION Validate_Alloc_Id
1468: ( p_Alloc_Id IN gl_aloc_mst.Alloc_Id%TYPE
1469: )
1470: RETURN BOOLEAN
1471: IS
1472: CURSOR Cur_Alloc_Id

Line 1477: gl_aloc_mst

1473: IS
1474: SELECT
1475: Alloc_Id
1476: FROM
1477: gl_aloc_mst
1478: WHERE
1479: Alloc_Id = p_Alloc_Id
1480: AND delete_mark = 0;
1481:

Line 1482: l_Alloc_Id gl_aloc_mst.Alloc_Id%TYPE ;

1478: WHERE
1479: Alloc_Id = p_Alloc_Id
1480: AND delete_mark = 0;
1481:
1482: l_Alloc_Id gl_aloc_mst.Alloc_Id%TYPE ;
1483:
1484: BEGIN
1485: OPEN Cur_Alloc_Id;
1486: FETCH Cur_Alloc_Id INTO l_Alloc_Id;

Line 1527: ( p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE,

1523: --+==========================================================================+
1524: -- Func end of comments
1525:
1526: FUNCTION Fetch_Alloc_Id
1527: ( p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE,
1528: p_co_code IN sy_orgn_mst.co_code%TYPE
1529: )
1530: RETURN NUMBER
1531: IS

Line 1537: gl_aloc_mst

1533: IS
1534: SELECT
1535: Alloc_id
1536: FROM
1537: gl_aloc_mst
1538: WHERE
1539: Alloc_Code = p_Alloc_Code
1540: AND Co_Code = p_Co_Code
1541: AND delete_mark = 0;

Line 1543: l_Alloc_id gl_aloc_mst.Alloc_id%TYPE := '' ;

1539: Alloc_Code = p_Alloc_Code
1540: AND Co_Code = p_Co_Code
1541: AND delete_mark = 0;
1542:
1543: l_Alloc_id gl_aloc_mst.Alloc_id%TYPE := '' ;
1544:
1545: BEGIN
1546:
1547: OPEN Cur_Alloc_Id;

Line 2945: * p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE *

2941: * DESCRIPTION *
2942: * This function gets the alloc id using alloc code and le id *
2943: * *
2944: * PARAMETERS *
2945: * p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE *
2946: * p_le_id IN xle_entity_profiles.legal_entity_id%TYPE *
2947: * *
2948: * RETURNS *
2949: * Alloc Id *

Line 2956: p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE

2952: * 20-Oct-2005 Jahnavi Boppana - Created *
2953: ***************************************************************************************/
2954: FUNCTION Fetch_Alloc_Id
2955: (
2956: p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE
2957: , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE
2958: )
2959: RETURN NUMBER
2960: IS

Line 2966: gl_aloc_mst

2962: IS
2963: SELECT
2964: Alloc_id
2965: FROM
2966: gl_aloc_mst
2967: WHERE
2968: Alloc_Code = p_Alloc_Code
2969: AND legal_entity_id = p_le_id
2970: AND delete_mark = 0;

Line 2972: l_Alloc_id gl_aloc_mst.Alloc_id%TYPE := '' ;

2968: Alloc_Code = p_Alloc_Code
2969: AND legal_entity_id = p_le_id
2970: AND delete_mark = 0;
2971:
2972: l_Alloc_id gl_aloc_mst.Alloc_id%TYPE := '' ;
2973:
2974: BEGIN
2975:
2976: OPEN Cur_Alloc_Id;