[Home] [Help]
PACKAGE: APPS.JA_CN_SYSOPS_BANK_PKG
Source
1 package JA_CN_SYSOPS_BANK_PKG AUTHID CURRENT_USER as
2 --$Header: JACNSBPS.pls 120.0.12020000.2 2013/02/06 09:04:07 chongwan noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNSBPS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to get balance segment |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Get_BSV_LIST |
16 --| PROCEDURE Get_SECURITY_BSV |
17 --| PROCEDURE Get_PARA_BSV |
18 --| PROCEDURE Submit_XML_Charset_Conversion |
19 --| HISTORY |
20 --| Oct-31-2012 Jar Wang Created |
21 --+======================================================================*/
22 Type bsv_record is record(
23 FLEX_VALUE VARCHAR2(45),
24 DESCRIPTION VARCHAR2(45),
25 FLEX_VALUE_SET_ID INT);
26 Type bsv_type is table of bsv_record;
27
28
29
30 --==========================================================================
31 -- PROCEDURE NAME:
32 -- Get_BSV_LIST public
33 --
34 -- DESCRIPTION:
35 -- This procedure returns a list(with comma) of all balancing segment value have right to access.
36 --
37 -- PARAMETERS:
38 -- In: p_resp_app_id NUMBER
39 -- In: p_resp_id NUMBER
40 -- In: p_access_set_id NUMBER
41 -- Out: p_bsv_list Varchar2
42 -- DESIGN REFERENCES:
43 -- None
44 --
45 -- CHANGE HISTORY:
46 -- Nov-1-2012 Jar Wang Created
47 --===========================================================================
48 PROCEDURE Get_BSV_LIST(p_resp_app_id in pls_integer,
49 p_resp_id in pls_integer,
50 p_access_set_id in pls_integer,
51 p_bsv_list out nocopy varchar2);
52
53
54
55 --==========================================================================
56 -- PROCEDURE NAME:
57 -- Get_SECURITY_BSV public
58 --
59 -- DESCRIPTION:
60 -- This procedure returns all balancing segment value have right to access.
61 --
62 -- PARAMETERS:
63 -- In: p_resp_app_id NUMBER
64 -- In: p_resp_id NUMBER
65 -- In: p_ledger_id NUMBER
66 -- In: p_legal_id NUMBER
67 -- DESIGN REFERENCES:
68 -- None
69 --
70 -- CHANGE HISTORY:
71 -- Nov-1-2012 Jar Wang Created
72 --===========================================================================
73 FUNCTION Get_SECURITY_BSV(p_resp_app_id pls_integer,
74 p_resp_id pls_integer,
75 p_ledger_id pls_integer,
76 p_legal_id pls_integer) RETURN bsv_type
77 pipelined;
78
79
80 --==========================================================================
81 -- FUNCTION NAME:
82 -- Check_LE_BSV public
83 --
84 -- DESCRIPTION:
85 -- This function returns a boolean value whether the bsv is assigned to the legal entity.
86 --
87 -- PARAMETERS:
88 -- In: p_ledger NUMBER
89 -- In: p_legal_entity NUMBER
90 -- In: p_bsv NUMBER
91 -- RETURN:
92 -- false=>exists, true=>not exists
93 -- DESIGN REFERENCES:
94 -- None
95 --
96 -- CHANGE HISTORY:
97 -- Nov-27-2012 Jar Wang Created
98 --===========================================================================
99 FUNCTION Check_LE_BSV( p_ledger pls_integer,
100 p_legal_entity pls_integer,
101 p_bsv VARCHAR2
102 ) RETURN BOOLEAN;
103
104 --==========================================================================
105 -- FUNCTION NAME:
106 -- Check_DAS_BSV public
107 --
108 -- DESCRIPTION:
109 -- This function will check whether the bsv belong to the data access set.
110 --
111 -- PARAMETERS:
112 -- In: p_das NUMBER
113 -- In: p_ledger NUMBER
114 -- In: p_bsv NUMBER
115 -- RETURN:
116 -- DESIGN REFERENCES:
117 -- None
118 --
119 -- CHANGE HISTORY:
120 -- Jan-14-2013 Jar Wang Created
121 --===========================================================================
122 FUNCTION Check_DAS_BSV(p_das pls_integer,
123 p_ledger pls_integer,
124 p_bsv VARCHAR2
125 ) RETURN PLS_INTEGER;
126
127
128 --==========================================================================
129 -- PROCEDURE NAME:
130 -- Submit_XML_Charset_Conversion Private
131 --
132 -- DESCRIPTION:
133 -- This function is used to submit charset conversion concurrent
134 -- for XML files.
135 -- PARAMETERS:
136 -- In: p_xml_request_id xml publisher concurrent request id
137 -- p_source_charset source charset
138 -- p_destination_charset destination charset
139 -- p_source_separator source separator
140 -- Out: x_charset_request_id charset conversion request id
141 -- x_result_flag result flag
142 --
143 --
144 -- DESIGN REFERENCES:
145 -- None
146 --
147 -- CHANGE HISTORY:
148 -- 03/12/2012 Jarwang Created
149 --==========================================================================
150 PROCEDURE Submit_XML_Charset_Conversion(p_Xml_Request_Id IN NUMBER,
151 p_Source_Charset IN VARCHAR2,
152 p_Destination_Charset IN VARCHAR2,
153 p_Source_Separator IN VARCHAR2,
154 x_Charset_Request_Id OUT NOCOPY NUMBER,
155 x_Result_Flag OUT NOCOPY VARCHAR2);
156
157 FUNCTION Get_Currency(reportName VARCHAR2)
158 RETURN VARCHAR2 ;
159 end JA_CN_SYSOPS_BANK_PKG;
160