PACKAGE: APPS.POS_SUPP_CLASSIFICATION_PKG

Source

1 PACKAGE POS_SUPP_CLASSIFICATION_PKG AS
2 /*$Header: POSSBCS.pls 120.4 2007/12/28 20:20:18 pbaldota 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 
59 --Start for Bug 6620664 - Controlling concurrent updates to Business Classification screen
60 
61 PROCEDURE validate_bus_class_concurrency
62 (     p_party_id        IN  NUMBER,
63       p_class_id_tbl        IN  po_tbl_number,
64       p_req_id_tbl        IN  po_tbl_number,
65       p_last_upd_date_tbl        IN  po_tbl_date,
66       p_lkp_type_tbl        IN  po_tbl_varchar30,
67       p_lkp_code_tbl        IN  po_tbl_varchar30,
68       x_return_status     OUT nocopy VARCHAR2,
69       x_error_msg          OUT nocopy VARCHAR2
70 );
71 
72 --End for Bug 6620664 - Controlling concurrent updates to Business Classification screen
73 
74 
75 END POS_SUPP_CLASSIFICATION_PKG;