APPS.GMF_VALIDATIONS_PVT dependencies on GL_ALOC_BAS

Line 1590: ( p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE

1586: --+==========================================================================+
1587: -- Func end of comments
1588:
1589: PROCEDURE Validate_Basis_account_key
1590: ( p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE
1591: , p_co_code IN sy_orgn_mst.co_code%TYPE
1592: , p_basis_description OUT NOCOPY VARCHAR2
1593: , p_return_status OUT NOCOPY NUMBER
1594: )

Line 1620: l_accu_desc gl_aloc_bas.basis_account_desc%TYPE ;

1616: l_cnt_acctg_unit NUMBER(10);
1617: l_cnt_seg NUMBER(10);
1618:
1619: l_segments_tab gmf_get_mappings.my_opm_seg_values; -- to store segments
1620: l_accu_desc gl_aloc_bas.basis_account_desc%TYPE ;
1621: l_acct_desc gl_aloc_bas.basis_account_desc%TYPE ;
1622:
1623: BEGIN
1624:

Line 1621: l_acct_desc gl_aloc_bas.basis_account_desc%TYPE ;

1617: l_cnt_seg NUMBER(10);
1618:
1619: l_segments_tab gmf_get_mappings.my_opm_seg_values; -- to store segments
1620: l_accu_desc gl_aloc_bas.basis_account_desc%TYPE ;
1621: l_acct_desc gl_aloc_bas.basis_account_desc%TYPE ;
1622:
1623: BEGIN
1624:
1625: l_segments_tab := gmf_get_mappings.get_opm_segment_values(p_Basis_account_key, p_co_code, 2);

Line 3005: * p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE *

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

Line 3018: p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE

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

Line 3030: l_account_id gl_aloc_bas.Basis_account_id%TYPE;

3026: SELECT chart_of_accounts_id
3027: FROM gmf_legal_entities
3028: WHERE legal_entity_id = p_le_id ;
3029:
3030: l_account_id gl_aloc_bas.Basis_account_id%TYPE;
3031: l_chart_of_accounts_id gmf_legal_entities.chart_of_accounts_id%TYPE;
3032:
3033: BEGIN
3034:

Line 3073: * p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE *

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

Line 3085: p_Basis_account_id IN gl_aloc_bas.Basis_account_id%TYPE

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

Line 3099: l_account_id gl_aloc_bas.Basis_account_id%TYPE;

3095: WHERE gle.legal_entity_id = p_le_id
3096: AND glc.code_combination_id = p_Basis_account_id
3097: AND gle.chart_of_accounts_id = glc.chart_of_accounts_id ;
3098:
3099: l_account_id gl_aloc_bas.Basis_account_id%TYPE;
3100:
3101: BEGIN
3102:
3103: OPEN Cur_accounts_id;