eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.POS_SUPP_CLASSIFICATION_PKG

Source


1 PACKAGE POS_SUPP_CLASSIFICATION_PKG AUTHID CURRENT_USER AS
2 /*$Header: POSSBCS.pls 120.5 2010/12/21 23:55:29 suyjoshi ship $ */
3 
4 BUSINESS_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'POS_BUSINESS_CLASSIFICATIONS';
5 WOMEN_OWNED CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'WOMEN_OWNED';
6 MINORITY_OWNED CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'MINORITY_OWNED';
7 SMALL_BUSINESS CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'SMALL_BUSINESS';
8 
9 PROCEDURE SYNCHRONIZE_CLASS_TCA_TO_PO
10 ( pPartyId in Number,
11   pVendorId in Number
12 );
13 
14 PROCEDURE SYNCHRONIZE_CLASS_PO_TO_TCA
15 ( pPartyId in Number,
16   pVendorId in Number
17 );
18 
19 PROCEDURE remove_classification( pClassificationId in number);
20 
21 PROCEDURE add_bus_class_attr
22 (
23 p_party_id in number,
24 p_vendor_id in number,
25 p_lookup_code in varchar2,
26 p_exp_date    in date,
27 p_cert_num  in varchar2,
28 p_cert_agency in varchar2,
29 p_ext_attr_1 in varchar2,
30 p_class_status in varchar2,
31 p_request_id in number,
32 x_classification_id out nocopy number,
33 x_status    out nocopy varchar2,
34 x_exception_msg out nocopy varchar2
35 );
36 
37 
38 
39 PROCEDURE update_bus_class_attr
40 (
41 p_party_id in number,
42 p_vendor_id in number,
43 p_selected in varchar2,
44 p_classification_id in number,
45 p_request_id in number,
46 p_lookup_code in varchar2,
47 p_exp_date    in date,
48 p_cert_num  in varchar2,
49 p_cert_agency in varchar2,
50 p_ext_attr_1 in varchar2,
51 p_class_status in varchar2,
52 x_classification_id out nocopy number,
53 x_request_id out nocopy number,
54 x_status    out nocopy varchar2,
55 x_exception_msg out nocopy varchar2
56 );
57 
58 -- code added for clm reference data ER
59 PROCEDURE add_addr_bus_class_attr
60 (
61 p_party_id in number,
62 p_vendor_id in number,
63 p_party_site_id IN NUMBER,
64 p_lookup_code in varchar2,
65 p_exp_date    in date,
66 p_cert_num  in varchar2,
67 p_cert_agency in varchar2,
68 p_ext_attr_1 in varchar2,
69 p_class_status in varchar2,
70 x_classification_id out nocopy number,
71 x_status    out nocopy varchar2,
72 x_exception_msg out nocopy varchar2
73 );
74 
75 PROCEDURE update_addr_bus_class_attr
76 (
77 p_party_id in number,
78 p_vendor_id in number,
79 p_party_site_id IN NUMBER,
80 p_selected in varchar2,
81 p_classification_id in number,
82 p_lookup_code in varchar2,
83 p_exp_date    in date,
84 p_cert_num  in varchar2,
85 p_cert_agency in varchar2,
86 p_ext_attr_1 in varchar2,
87 p_class_status in varchar2,
88 x_classification_id out nocopy number,
89 x_request_id out nocopy number,
90 x_status    out nocopy varchar2,
91 x_exception_msg out nocopy varchar2
92 );
93 
94 PROCEDURE default_sites_bus_class_attr
95 (
96 p_vendor_id IN NUMBER,
97 p_party_site_id IN NUMBER,
98 p_vendor_site_id IN NUMBER,
99 x_status    out nocopy varchar2,
100 x_exception_msg out nocopy varchar2
101 );
102 
103 PROCEDURE add_site_bus_class_attr
104 (
105 p_party_id in number,
106 p_vendor_id in number,
107 p_party_site_id IN NUMBER,
108 p_vendor_site_id IN NUMBER,
109 p_lookup_code in varchar2,
110 p_exp_date    in date,
111 p_cert_num  in varchar2,
112 p_cert_agency in varchar2,
113 p_ext_attr_1 in varchar2,
114 p_class_status in varchar2,
115 x_classification_id out nocopy number,
116 x_status    out nocopy varchar2,
117 x_exception_msg out nocopy varchar2
118 );
119 
120 PROCEDURE update_site_bus_class_attr
121 (
122 p_party_id in number,
123 p_vendor_id in number,
124 p_party_site_id IN NUMBER,
125 p_vendor_site_id IN NUMBER,
126 p_selected in varchar2,
127 p_classification_id in number,
128 p_lookup_code in varchar2,
129 p_exp_date    in date,
130 p_cert_num  in varchar2,
131 p_cert_agency in varchar2,
132 p_ext_attr_1 in varchar2,
133 p_class_status in varchar2,
134 x_classification_id out nocopy number,
135 x_request_id out nocopy number,
136 x_status    out nocopy varchar2,
137 x_exception_msg out nocopy varchar2
138 );
139 
140 -- code added for clm reference data ER
141 
142 --Start for Bug 6620664 - Controlling concurrent updates to Business Classification screen
143 
144 PROCEDURE validate_bus_class_concurrency
145 (     p_party_id        IN  NUMBER,
146       p_class_id_tbl        IN  po_tbl_number,
147       p_req_id_tbl        IN  po_tbl_number,
148       p_last_upd_date_tbl        IN  po_tbl_date,
149       p_lkp_type_tbl        IN  po_tbl_varchar30,
150       p_lkp_code_tbl        IN  po_tbl_varchar30,
151       x_return_status     OUT nocopy VARCHAR2,
152       x_error_msg          OUT nocopy VARCHAR2
153 );
154 
155 --End for Bug 6620664 - Controlling concurrent updates to Business Classification screen
156 
157 
158 END POS_SUPP_CLASSIFICATION_PKG;