[Home] [Help]
PACKAGE: APPS.JA_CN_VOUCHER_NUM_PKG
Source
1 PACKAGE JA_CN_VOUCHER_NUM_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNVNGS.pls 120.4 2011/05/13 03:35:17 choli noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNVNGS.pls |
10 --| |
11 --| |
12 --| DESCRIPTION |
13 --| Use this package to generate the voucher numbers |
14 --| |
15 --| PROCEDURE LIST |
16 --| Procedure beforeReport |
17 --| Procedure Generate_voucher_number |
18 --| Procedure Generate_voucher_num_periods |
19
20 --| |
21 --| HISTORY |
22 --| 29-Jul-2010 Chongwu Li Created |
23 --| 29-Sep-2010 Jianchao Chi Updated |
24 --| 12-May-2011 Chongwu Li Updated, add method |
25 --| get_balancing_segment for CFS seperated patch |
26 --| tracked by bug 12541220 |
27 --+======================================================================*/
28
29 P_LEDGER_ID NUMBER;
30 P_LEDGER_NAME VARCHAR2(300);
31 P_CURRENCY VARCHAR2(300);
32 P_LEGAL_ENTITY_ID NUMBER;
33 P_LEGAL_ENTITY VARCHAR2(300);
34 P_COA_ID NUMBER;
35 P_PERIOD_FROM VARCHAR2(15);
36 P_PERIOD_TO VARCHAR2(15);
37 P_GL_DATE_FROM DATE;
38 P_GL_DATE_TO DATE;
39 P_PROFILE_OPTION_VALUE NUMBER;
40 P_REGENERATE_FLAG VARCHAR2(15);
41 --==========================================================================
42 -- PROCEDURE NAME:
43 --
44 -- Generate_voucher_number Public
45 --
46 -- DESCRIPTION:
47 --
48 -- This function is to generate the voucher number for the giving period
49 --
50 -- PARAMETERS:
51 -- In: pn_ledger_id Ledger ID
52 -- pn_legal_entity_id Legal Entity ID
53 -- pv_period_name Period Name
54 -- pv_regenerate_flag Regeneration Flag
55 -- Out:
56 --
57 -- DESIGN REFERENCES:
58 --
59 --
60 -- CHANGE HISTORY:
61 -- 27-Sep-2010 Chongwu Li Created
62 --
63 --===========================================================================
64 PROCEDURE Generate_voucher_number(pn_ledger_id IN NUMBER,
65 pn_legal_entity_id IN NUMBER,
66 pv_period_name IN VARCHAR2,
67 pv_regenerate_flag IN VARCHAR2);
68
69 --==========================================================================
70 -- PROCEDURE NAME:
71 --
72 -- Generate_voucher_num_periods Public
73 --
74 -- DESCRIPTION:
75 --
76 -- This function is to generate the voucher number for the period range
77 --
78 -- PARAMETERS:
79 -- In: pn_ledger_id Ledger ID
80 -- pn_legal_entity_id Legal Entity ID
81 -- pv_period_from Period From
82 -- pv_period_to Period To
83 -- pv_regenerate_flag Regeneration Flag
84 -- Out:
85 --
86 -- DESIGN REFERENCES:
87 --
88 --
89 -- CHANGE HISTORY:
90 -- 27-Sep-2010 Chongwu Li Created
91 --
92 --===========================================================================
93 PROCEDURE Generate_voucher_num_periods(pn_ledger_id IN NUMBER,
94 pn_legal_entity_id IN NUMBER,
95 pv_period_from IN VARCHAR2,
96 pv_period_to IN VARCHAR2,
97 pv_regenerate_flag IN VARCHAR2);
98 --==========================================================================
99 -- PROCEDURE NAME:
100 --
101 -- beforeReport Public
102 --
103 -- DESCRIPTION:
104 --
105 -- This function is to generate the voucher number for the period range
106 --
107 -- PARAMETERS:
108 -- In: N/A
109 -- Out: TRUE/FALSE
110 --
111 -- DESIGN REFERENCES:
112 --
113 --
114 -- CHANGE HISTORY:
115 -- 29-Sep-2010 Jianchao Chi Created
116 --
117 --===========================================================================
118 PROCEDURE beforeReport(Errbuf OUT NOCOPY VARCHAR2,
119 Retcode OUT NOCOPY VARCHAR2,
120 P_RESP_APPLICATION_ID IN NUMBER,
121 P_LEGAL_ENTITY_TEMP IN NUMBER,
122 P_PROFILE_OPTION_VALUE IN NUMBER,
123 P_LEDGER_ID IN NUMBER,
124 P_LEDGER_NAME IN VARCHAR2,
125 P_LEGAL_ENTITY_ID IN NUMBER,
126 P_LEGAL_ENTITY IN VARCHAR2,
127 P_PERIOD_FROM IN VARCHAR2,
128 P_PERIOD_TO IN VARCHAR2,
129 P_REGENERATE_FLAG IN VARCHAR2);
130
131 --==========================================================================
132 -- PROCEDURE NAME:
133 -- get_balancing_segment public
134 --
135 -- DESCRIPTION:
136 -- This procedure returns the balancing segment value of a CCID.
137 --
138 -- PARAMETERS:
139 -- In: P_CC_ID NUMBER
140 --
141 -- DESIGN REFERENCES:
142 -- None
143 --
144 -- CHANGE HISTORY:
145 -- 11-Aug-2010 Chaoqun Wu created
146 --===========================================================================
147 FUNCTION get_balancing_segment
148 (P_CC_ID IN NUMBER
149 )
150 RETURN VARCHAR2;
151 END JA_CN_VOUCHER_NUM_PKG;
152