[Home] [Help]
PACKAGE: APPS.OKL_ACCOUNT_GENERATOR_PVT
Source
1 PACKAGE OKL_ACCOUNT_GENERATOR_PVT AS
2 /* $Header: OKLRAGTS.pls 120.5 2006/07/11 09:40:22 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- Record type which holds the account generator rule lines.
7 TYPE acc_rul_lns_rec_type IS RECORD (
8 id NUMBER := okc_api.g_miss_num,
9 segment OKL_ACC_GEN_RUL_LNS.segment%TYPE := okc_api.g_miss_char,
10 segment_number NUMBER := okc_api.g_miss_num,
11 agr_id NUMBER := okc_api.g_miss_num,
12 source OKL_ACC_GEN_RUL_LNS.source%TYPE := okc_api.g_miss_char,
13 constants OKL_ACC_GEN_RUL_LNS.constants%TYPE := okc_api.g_miss_char
14 );
15
16 TYPE acc_rul_lns_tbl_type IS TABLE OF acc_rul_lns_rec_type INDEX BY BINARY_INTEGER;
17
18
19 -- Table type which holds the account generator source related information
20
21 TYPE primary_key_rec IS RECORD
22 (source_table okl_ag_source_maps.source%TYPE,
23 primary_key_column VARCHAR2(100)
24 );
25
26 TYPE primary_key_tbl IS TABLE OF primary_key_rec INDEX BY BINARY_INTEGER;
27
28 TYPE acc_gen_wf_sources_rec IS RECORD
29 (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
30 TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31 STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32 FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33 SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34 FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35 INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36 MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37 REV_REC_FLAG VARCHAR2(1) := 'N',
38 SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39 SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40 ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
41 CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
42 CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
43
44 SUBTYPE error_message_type IS okl_accounting_util.error_message_type;
45
46
47 ---------------------------------------------------------------------------
48 -- GLOBAL MESSAGE CONSTANTS
49 ---------------------------------------------------------------------------
50 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
51 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
52 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
53 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54 G_AE_LINE_TYPE_TOKEN CONSTANT VARCHAR2(200) := 'AE_LINE_TYPE';
55 G_ACC_GEN_RULE_ID CONSTANT VARCHAR2(200) := 'ACC_GEN_ RULE_ID';
56 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
57 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
61 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
62 G_EXCEPTION_ERROR EXCEPTION;
63 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
64
65
66 ---------------------------------------------------------------------------
67 -- GLOBAL EXCEPTION
68 ---------------------------------------------------------------------------
69 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
70 ---------------------------------------------------------------------------
71 ---------------------------------------------------------------------------
72 -- GLOBAL VARIABLES
73 ---------------------------------------------------------------------------
74 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNT_GENERATOR_PVT';
75 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
76
77 -------------------------------------------------------------------------------
78 -- PACKAGE LEVEL GLOBAL VARIABLES
79 -------------------------------------------------------------------------------
80 G_GL_APP_SHORT_NAME CONSTANT VARCHAR2(10) := 'SQLGL';
81 G_ACC_KEY_FLEX_CODE CONSTANT VARCHAR2(3) := 'GL#';
82
83
84 ---------------------------------------------------------------------------
85 -- Procedures and Functions
86 ---------------------------------------------------------------------------
87 -- Main account generator function which is getting invoked from outside. This is the
88 -- interface for account generator.
89
90 -- Changed by Santonyr on 22-Sep-2004 to fix bug 3901209.
91 -- Added a new parameter 'p_ae_tmpt_line_id'.
92 -- If Account Generator fails due to lack of sources, it picks up the
93 -- default account code for the passed account template line and returns.
94
95 -- Changed the signature for bug 4157521
96
97 FUNCTION GET_CCID
98 (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_acc_gen_wf_sources_rec IN acc_gen_wf_sources_rec,
105 p_ae_line_type IN okl_acc_gen_rules.ae_line_type%TYPE,
106 p_primary_key_tbl IN primary_key_tbl,
107 p_ae_tmpt_line_id IN NUMBER DEFAULT NULL
108 )
109 RETURN NUMBER;
110
111 END OKL_ACCOUNT_GENERATOR_PVT;