1 PACKAGE pos_util_pkg as
2 /* $Header: POSUTILS.pls 120.0.12000000.3 2007/08/22 11:29:29 pkapoor ship $ */
3
4 -- global variable for logging
5 g_log_module_name VARCHAR2(30) := 'POSUTILB';
6
7 FUNCTION bool_to_varchar(b IN BOOLEAN)
8 RETURN VARCHAR2;
9
10
11 /** procedure Retrieve_Doc_Security
12 --------------------------------
13 purpose:
14 --------
15 the iSP wrapper api to retrieve where clause for Purchasing Document Security
16 by calling the PO document security api PO_DOCUMENT_CHECKS_GRP. PO_Security_Check
17
18 */
19
20 PROCEDURE Retrieve_Doc_Security (p_query_table IN VARCHAR2,
21 p_owner_id_column IN VARCHAR2,
22 p_employee_id IN VARCHAR2,
23 p_employee_bind_start IN NUMBER,
24 p_org_id IN NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 x_where_clause OUT NOCOPY VARCHAR2);
28
29
30 PROCEDURE update_revision (p_organizationId in number,
31 p_inventoryItemId in number,
32 p_vendorId in number,
33 p_batchId in number,
34 x_returnCode out NOCOPY varchar,
35 x_err_msg out NOCOPY varchar);
36
37 /** function IS_FV_ENABLED
38 -----------------------
39 purpose:
40 --------
41 The iSP wrapper api to retrieve the value of Profile Option FV: Federal Enabled
42 by calling the Federal Financial api fv_install.enabled.
43
44 Returns 'T' if the Federal is enabled otherwise 'F'
45
46 */
47
48 FUNCTION IS_FV_ENABLED RETURN VARCHAR2;
49
50 /** PROCEDURE FV_IS_CCR
51 -----------------------
52 purpose:
53 --------
54 The iSP wrapper api to know if record is in CCR,
55 by calling the Federal Financial api FV_CCR_GRP.FV_IS_CCR
56
57 p_object_type, p_object_id:
58 Here S-> Supplier --> Pass supplier_id
59 B=> Bank branch --> pass bank brnahc id
60 T=> Supplier site --> Pass Pay site or main address site id
61 A-> Bank account Bank account id
62 */
63
64 PROCEDURE FV_IS_CCR
65 ( p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT null,
67 p_object_id IN NUMBER,
68 p_object_type IN VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 x_ccr_id OUT NOCOPY NUMBER,
73 x_out_status OUT NOCOPY VARCHAR2,
74 x_error_code OUT NOCOPY NUMBER
75 );
76
77 /** function IS_ADDR_CCR
78 -----------------------
79 purpose:
80 --------
81 The iSP wrapper api over FV_IS_CCR to know if there is any CCR Site associated to an address
82 p_object_id: party_site_id for the address.
83
84 Returns 'T' if the Address has atleast one CCR site, otherwise 'F'
85
86 */
87
88 FUNCTION IS_ADDR_CCR(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 ,
91 p_object_id IN NUMBER
92 )RETURN VARCHAR2;
93
94
95 /** function IS_SITE_CCR
96 -----------------------
97 purpose:
98 --------
99 The iSP wrapper api over FV_IS_CCR to know if site is a CCR Site
100 p_object_id: vendor_site_id
101
102 Returns 'T' if the site is CCR Site otherwise 'F'
103
104 */
105 FUNCTION IS_SITE_CCR(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 ,
108 p_object_id IN NUMBER
109 )RETURN VARCHAR2;
110
111
112 /** function IS_SUPP_CCR
113 -----------------------
114 purpose:
115 --------
116 The iSP wrapper api over FV_IS_CCR to know if Supplier is a CCR Supplier.
117 p_object_id: vendor_id.
118
119 Returns 'T' if the supplier is CCR Supplier otherwise 'F'
120
121 */
122 FUNCTION IS_SUPP_CCR(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 ,
125 p_object_id IN NUMBER
126 )RETURN VARCHAR2;
127
128 /** function IS_CCR_SITE_ACTIVE
129 -----------------------
130 purpose:
131 --------
132 The iSP wrapper api over FV_CCR_GRP.FV_CCR_REG_STATUS to know if site is CCR
133 site and if registration_status is active.
134 p_object_id: vendor_site_id.
135
136 Returns 'A' if the site is CCR Site and registration_status is active otherwise 'F'
137
138 */
139 FUNCTION IS_CCR_SITE_ACTIVE(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 ,
142 p_object_id IN NUMBER
143 )RETURN VARCHAR2;
144
145
146 END pos_util_pkg;