1 PACKAGE FV_CCR_GRP AS
2 /* $Header: FVGACCRS.pls 120.0.12000000.2 2007/09/28 15:02:39 sasukuma ship $*/
3 -- Start of comments
4 -- API name : FV_IS_CCR
5 -- Type : Group.
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN : p_api_version IN NUMBER
10 -- p_init_msg_list IN VARCHAR2
11 -- Default = null
12 -- p_object_id IN NUMBER
13 -- p_object_type IN VARCHAR2(1)
14 --
15 -- OUT : x_return_status OUT VARCHAR2(1)
16 -- x_msg_count OUT NUMBER
17 -- x_msg_data OUT VARCHAR2(2000)
18 -- x_ccr_id OUT NUMBER
19 -- x_error_code OUT NUMBER
20 -- x_out_status OUT VARCHAR2(1)
21 --
22 -- Version : Current version 1.0
23 -- Initial version 1.0
24 --
25 -- Notes : This API determines whether a given supplier site
26 -- represents a CCR vendor and returns its unique
27 -- identifier and boolean variable showing whether it is
28 -- CCR or Not and error_code if the object is ccr but some
29 -- too many rows exist for the object.
30 --
31 -- End of comments
32 PROCEDURE FV_IS_CCR
33 ( p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT null,
35 p_object_id IN NUMBER,
36 p_object_type IN VARCHAR2,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 x_ccr_id OUT NOCOPY NUMBER,
41 x_out_status OUT NOCOPY VARCHAR2,
42 x_error_code OUT NOCOPY NUMBER
43 );
44
45
46 -- Start of comments
47 -- API name : FV_CCR_REG_STATUS
48 -- Type : Group.
49 -- Function :
50 -- Pre-reqs : None.
51 -- Parameters :
52 -- IN : p_api_version IN NUMBER
53 -- p_init_msg_list IN VARCHAR2
54 -- Default null
55 -- p_vendor_site_id IN NUMBER
56 --
57 -- OUT : x_return_status OUT VARCHAR2(1)
58 -- x_msg_count OUT NUMBER
59 -- x_msg_data OUT VARCHAR2(2000)
60 -- x_ccr_status OUT VARCHAR2(30)
61 -- x_error_code OUT NUMBER
62 --
63 -- Version : Current version 1.0
64 -- Initial version 1.0
65 --
66 -- Notes : This API checks the registration
67 -- status of a CCR vendor.
68 --
69 -- End of comments
70 PROCEDURE FV_CCR_REG_STATUS
71 ( p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT null,
73 p_vendor_site_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 x_ccr_status OUT NOCOPY VARCHAR2,
78 x_error_code OUT NOCOPY NUMBER
79 );
80
81
82 -- Start of comments
83 -- API name : IS_VENDOR_FEDERAL
84 -- Type : Group.
85 -- Function :
86 -- Pre-reqs : None.
87 -- Parameters :
88 -- IN p_api_version IN NUMBER
89 -- p_init_msg_list IN VARCHAR2
90 -- Default null
91 -- p_vendor_id IN NUMBER
92 --
93 -- OUT x_return_status OUT VARCHAR2(1)
94 -- x_msg_count OUT NUMBER
95 -- x_msg_data OUT VARCHAR2(2000)
96 -- x_error_code OUT NUMBER
97 -- x_federal OUT VARCHAR2(1)
98 --
99 -- Version : Current version 1.0
100 -- Initial version 1.0
101 --
102 -- Notes : This API returns a value of Y if
103 -- the vendor is FEDERAL or else
104 -- it returns a value of N
105 --
106 -- End of comments
107 PROCEDURE IS_VENDOR_FEDERAL
108 (
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
111 p_vendor_id IN NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 x_federal OUT NOCOPY VARCHAR2,
116 x_error_code OUT NOCOPY NUMBER
117 );
118
119
120
121 -- Start of comments
122 -- API name : FV_IS_BANK_ACCOUNT_USES_CCR
123 -- Type : Group.
124 -- Function :
125 -- Pre-reqs : None.
126 -- Parameters :
127 -- IN : p_api_version IN NUMBER
128 -- p_init_msg_list IN VARCHAR2
129 -- Default = null
130 -- p_vendor_site_id IN NUMBER
131 --
132 --
133 -- OUT : x_return_status OUT VARCHAR2(1)
134 -- x_msg_count OUT NUMBER
135 -- x_msg_data OUT VARCHAR2(2000)
136 -- x_error_code OUT NUMBER
137 -- x_out_status OUT VARCHAR2(1)
138 --
139 -- Version : Current version 1.0
140 -- Initial version 1.0
141 --
142 -- Notes : This API determines whether a given supplier site
143 -- has bank account use created by ccr or not. It returns
144 -- Y if bank account use is created by Data Processing
145 -- program as part of CCR Import.
146 --
147 -- End of comments
148
149 PROCEDURE FV_IS_BANK_ACCOUNT_USES_CCR
150 ( p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
152 p_vendor_site_id IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 x_out_status OUT NOCOPY VARCHAR2,
157 x_error_code OUT NOCOPY NUMBER
158 );
159
160 FUNCTION SELECT_THIRD_PARTY
161 (
162 p_vendor_site_id NUMBER
163 ) RETURN VARCHAR2;
164 FUNCTION SELECT_BANK_ACCOUNT
165 (
166 p_bank_account_id IN NUMBER,
167 p_vendor_site_id NUMBER
168 ) RETURN NUMBER;
169
170 END;