DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on XLE_ENTITY_PROFILES

Line 2039: * p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE *

2035: * DESCRIPTION *
2036: * This function validates that the Legal Entity Id exists *
2037: * *
2038: * PARAMETERS *
2039: * p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE *
2040: * *
2041: * RETURNS *
2042: * TRUE - If Legal Entity Exists *
2043: * FALSE - If Legal Entity Doesnt Exist *

Line 2050: p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE

2046: * 20-Oct-2005 Anand Thiyagarajan - Created *
2047: ***************************************************************************************/
2048: FUNCTION validate_legal_entity_id
2049: (
2050: p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE
2051: )
2052: RETURN BOOLEAN
2053: IS
2054:

Line 2062: FROM xle_entity_profiles

2058:
2059: CURSOR Cur_legal_entity
2060: IS
2061: SELECT legal_entity_id
2062: FROM xle_entity_profiles
2063: WHERE legal_entity_id = p_legal_entity_id;
2064:
2065: /******************
2066: * Local Variables *

Line 2069: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE ;

2065: /******************
2066: * Local Variables *
2067: ******************/
2068:
2069: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE ;
2070:
2071: BEGIN
2072: OPEN Cur_legal_entity;
2073: FETCH Cur_legal_entity INTO l_legal_entity_id;

Line 2944: * p_le_id IN xle_entity_profiles.legal_entity_id%TYPE *

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 *
2948: * *

Line 2955: , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE

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
2959: CURSOR Cur_Alloc_Id

Line 3004: * p_le_id IN xle_entity_profiles.legal_entity_id%TYPE *

3000: * This function returns the account id for teh account key *
3001: * *
3002: * PARAMETERS *
3003: * p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE *
3004: * p_le_id IN xle_entity_profiles.legal_entity_id%TYPE *
3005: * *
3006: * RETURNS *
3007: * Account Id *
3008: * *

Line 3017: , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE

3013:
3014: FUNCTION Validate_Basis_account_key
3015: (
3016: p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE
3017: , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE
3018: )
3019: RETURN NUMBER
3020: IS
3021:

Line 3072: * p_le_id IN xle_entity_profiles.legal_entity_id%TYPE *

3068: * Validates the account id *
3069: * *
3070: * PARAMETERS *
3071: * p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE *
3072: * p_le_id IN xle_entity_profiles.legal_entity_id%TYPE *
3073: * *
3074: * RETURNS *
3075: * TRUE/FALSE *
3076: * *

Line 3084: , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE

3080:
3081: FUNCTION Validate_ACCOUNT_ID
3082: (
3083: p_Basis_account_id IN gl_aloc_bas.Basis_account_id%TYPE
3084: , p_le_id IN xle_entity_profiles.legal_entity_id%TYPE
3085: )
3086: RETURN BOOLEAN
3087: IS
3088: