[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;