APPS.GMF_VALIDATIONS_PVT dependencies on GL_ALOC_BAS

Line 1588: ( p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE

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

Line 1618: l_accu_desc gl_aloc_bas.basis_account_desc%TYPE ;

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

Line 1619: l_acct_desc gl_aloc_bas.basis_account_desc%TYPE ;

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

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

2999: * DESCRIPTION *
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 *

Line 3016: p_Basis_account_key IN gl_aloc_bas.Basis_account_key%TYPE

3012:
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

Line 3028: l_account_id gl_aloc_bas.Basis_account_id%TYPE;

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

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

3067: * DESCRIPTION *
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 *

Line 3083: p_Basis_account_id IN gl_aloc_bas.Basis_account_id%TYPE

3079: ***************************************************************************************/
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

Line 3097: l_account_id gl_aloc_bas.Basis_account_id%TYPE;

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