DBA Data[Home] [Help]

PACKAGE: APPS.GMF_ALLOC_PROCESS_PRIVATE

Source


1 PACKAGE GMF_ALLOC_PROCESS_PRIVATE AUTHID CURRENT_USER AS
2 /* $Header: gmfalcps.pls 115.2 2002/11/11 00:28:51 rseshadr ship $ */
3 
4    /*********************************************************************************
5    *  FUNCTION
6    *    get_company_acct_masks
7    *
8    *  DESCRIPTION
9    *     Retrieves the masks of accounting units and accounts.
10    *  INPUT PARAMETERS
11    *     v_co_code
12    *
13    *  OUTPUT PARAMETERS
14    *     P_deli_acct_mask
15    *     P_deli_au_mask :=
16    *     P_deli_comp :=
17    *     P_deli_au_len :
18    *     P_deli_acct_len
19    *     P_deli_key_mask
20    *
21    *  RETURNS
22    *           0  =  Sucessful
23    *          -1  =  No Segments found
24    *          -2  =  No delimeter found
25    *          -3  =  No  Account unit segments found.
26    *  HISTORY
27    *     sukarna Reddy                12/15/97       Converted from jpl to PLSQL
28    *     R.Sharath Kumar              10/30/2002     Bug# 2641405  Added NOCOPY hint
29    ************************************************************************************/
30 
31    P_deli_au_len 	      	NUMBER(10)    DEFAULT 0;	/* sotres AU length*/
32    P_deli_acct_len         	NUMBER(10)    DEFAULT 0;	/* stores accts length*/
33    P_deli_comp  	      	VARCHAR2(4)   DEFAULT NULL;	/* stores company delimeter*/
34    P_deli_key_mask 	      	VARCHAR2(500) DEFAULT NULL;	/* stores complete mask for key*/
35    P_deli_au_mask 	      	gl_accu_mst.acctg_unit_no%TYPE  DEFAULT NULL;  	/* stores mask for AU*/
36    P_deli_acct_mask       	gl_acct_mst.acct_no%TYPE DEFAULT NULL;
37    P_of_segment_delimeter   VARCHAR2(1);
38 
39    FUNCTION get_company_acct_masks(V_co_code IN VARCHAR2) RETURN NUMBER;
40 
41    FUNCTION format_string (v_string IN OUT NOCOPY VARCHAR2, v_mask IN VARCHAR2) RETURN VARCHAR2;
42 
43  END GMF_ALLOC_PROCESS_PRIVATE;