APPS.GMF_VALIDATIONS_PVT dependencies on GL_ALOC_MST

Line 1466: ( p_Alloc_Id IN gl_aloc_mst.Alloc_Id%TYPE

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

Line 1475: gl_aloc_mst

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

Line 1480: l_Alloc_Id gl_aloc_mst.Alloc_Id%TYPE ;

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

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

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

Line 1535: gl_aloc_mst

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

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

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

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

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

Line 2954: p_Alloc_Code IN gl_aloc_mst.Alloc_Code%TYPE

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

Line 2964: gl_aloc_mst

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

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

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