1 PACKAGE pos_supplier_address_pkg AS
2 /* $Header: POSSAS.pls 120.4.12010000.2 2008/08/02 14:56:21 sthoppan ship $ */
3
4 PROCEDURE create_supplier_address
5 (p_vendor_id IN NUMBER,
6 p_vendor_party_id IN NUMBER,
7 p_party_site_name IN VARCHAR2,
8 p_address_line1 IN VARCHAR2,
9 p_address_line2 IN VARCHAR2,
10 p_address_line3 IN VARCHAR2,
11 p_address_line4 IN VARCHAR2,
12 p_country IN VARCHAR2,
13 p_city IN VARCHAR2,
14 p_state IN VARCHAR2,
15 p_province IN VARCHAR2,
16 p_postal_code IN VARCHAR2,
17 p_county IN VARCHAR2,
18 p_rfq_flag IN VARCHAR2,
19 p_pur_flag IN VARCHAR2,
20 p_pay_flag IN VARCHAR2,
21 p_primary_pay_flag IN VARCHAR2,
22 p_phone_area_code IN VARCHAR2,
23 p_phone_number IN VARCHAR2,
24 p_phone_extension IN VARCHAR2,
25 p_fax_area_code IN VARCHAR2,
26 p_fax_number IN VARCHAR2,
27 p_email_address IN VARCHAR2,
28 x_return_status OUT nocopy VARCHAR2,
29 x_msg_count OUT nocopy NUMBER,
30 x_msg_data OUT nocopy VARCHAR2,
31 x_party_site_id OUT nocopy NUMBER
32 );
33
34 PROCEDURE update_supplier_address
35 (p_vendor_id IN NUMBER,
36 p_vendor_party_id IN NUMBER,
37 p_party_site_id IN NUMBER,
38 p_party_site_name IN VARCHAR2,
39 p_address_line1 IN VARCHAR2,
40 p_address_line2 IN VARCHAR2,
41 p_address_line3 IN VARCHAR2,
42 p_address_line4 IN VARCHAR2,
43 p_country IN VARCHAR2,
44 p_city IN VARCHAR2,
45 p_state IN VARCHAR2,
46 p_province IN VARCHAR2,
47 p_postal_code IN VARCHAR2,
48 p_county IN VARCHAR2,
49 p_rfq_flag IN VARCHAR2,
50 p_pur_flag IN VARCHAR2,
51 p_pay_flag IN VARCHAR2,
52 p_primary_pay_flag IN VARCHAR2,
53 p_phone_area_code IN VARCHAR2,
54 p_phone_number IN VARCHAR2,
55 p_phone_extension IN VARCHAR2,
56 p_fax_area_code IN VARCHAR2,
57 p_fax_number IN VARCHAR2,
58 p_email_address IN VARCHAR2,
59 x_return_status OUT nocopy VARCHAR2,
60 x_msg_count OUT nocopy NUMBER,
61 x_msg_data OUT nocopy VARCHAR2
62 );
63
64 PROCEDURE unassign_address_to_contact
65 (p_contact_party_id IN NUMBER,
66 p_org_party_site_id IN NUMBER,
67 p_vendor_id IN NUMBER,
68 x_return_status OUT nocopy VARCHAR2,
69 x_msg_count OUT nocopy NUMBER,
70 x_msg_data OUT nocopy VARCHAR2
71 );
72
73 PROCEDURE assign_address_to_contact
74 (p_contact_party_id IN NUMBER,
75 p_org_party_site_id IN NUMBER,
76 p_vendor_id IN NUMBER,
77 x_attribute_category IN VARCHAR2 default null,
78 x_attribute1 IN VARCHAR2 default null,
79 x_attribute2 IN VARCHAR2 default null,
80 x_attribute3 IN VARCHAR2 default null,
81 x_attribute4 IN VARCHAR2 default null,
82 x_attribute5 IN VARCHAR2 default null,
83 x_attribute6 IN VARCHAR2 default null,
84 x_attribute7 IN VARCHAR2 default null,
85 x_attribute8 IN VARCHAR2 default null,
86 x_attribute9 IN VARCHAR2 default null,
87 x_attribute10 IN VARCHAR2 default null,
88 x_attribute11 IN VARCHAR2 default null,
89 x_attribute12 IN VARCHAR2 default null,
90 x_attribute13 IN VARCHAR2 default null,
91 x_attribute14 IN VARCHAR2 default null,
92 x_attribute15 IN VARCHAR2 default null,
93 x_return_status OUT nocopy VARCHAR2,
94 x_msg_count OUT nocopy NUMBER,
95 x_msg_data OUT nocopy VARCHAR2
96 );
97
98 /* Bug 6599374 Start */
99
100 PROCEDURE update_address_assignment_dff
101 (x_contact_party_id IN NUMBER,
102 x_org_party_site_id IN NUMBER,
103 x_vendor_id IN NUMBER,
104 x_attribute_category IN VARCHAR2 default null,
105 x_attribute1 IN VARCHAR2 default null,
106 x_attribute2 IN VARCHAR2 default null,
107 x_attribute3 IN VARCHAR2 default null,
108 x_attribute4 IN VARCHAR2 default null,
109 x_attribute5 IN VARCHAR2 default null,
110 x_attribute6 IN VARCHAR2 default null,
111 x_attribute7 IN VARCHAR2 default null,
112 x_attribute8 IN VARCHAR2 default null,
113 x_attribute9 IN VARCHAR2 default null,
114 x_attribute10 IN VARCHAR2 default null,
115 x_attribute11 IN VARCHAR2 default null,
116 x_attribute12 IN VARCHAR2 default null,
117 x_attribute13 IN VARCHAR2 default null,
118 x_attribute14 IN VARCHAR2 default null,
119 x_attribute15 IN VARCHAR2 default null,
120 x_return_status OUT nocopy VARCHAR2,
121 x_msg_count OUT nocopy NUMBER,
122 x_msg_data OUT nocopy VARCHAR2
123 );
124
125 /* Bug 6599374 End */
126 -- This procedure is used by the new supplier UI in r12
127 -- to update details such as site use flags, phone,
128 -- fax, email, notes for a supplier address
129 PROCEDURE buyer_update_address_details
130 (p_party_site_id IN NUMBER,
131 p_rfqFlag IN VARCHAR2,
132 p_purFlag IN VARCHAR2,
133 p_payFlag IN VARCHAR2,
134 p_primaryPayFlag IN VARCHAR2,
135 p_note IN VARCHAR2,
136 p_phone_area_code IN VARCHAR2 DEFAULT NULL,
137 p_phone IN VARCHAR2 DEFAULT NULL,
138 p_phone_contact_id IN NUMBER DEFAULT NULL,
139 p_phone_obj_ver_num IN NUMBER DEFAULT NULL,
140 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
141 p_fax IN VARCHAR2 DEFAULT NULL,
142 p_fax_contact_id IN NUMBER DEFAULT NULL,
143 p_fax_obj_ver_num IN NUMBER DEFAULT NULL,
144 p_email IN VARCHAR2 DEFAULT NULL,
145 p_email_contact_id IN NUMBER DEFAULT NULL,
146 p_email_obj_ver_num IN NUMBER DEFAULT NULL,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2
150 );
151
152 END pos_supplier_address_pkg;