61: );
62:
63: PROCEDURE reject_mult_address_reqs
64: (
65: p_req_id_tbl IN po_tbl_number,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2
69: );
69: );
70:
71: PROCEDURE reject_mult_contact_reqs
72: (
73: p_req_id_tbl IN po_tbl_number,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2
77: );
77: );
78:
79: PROCEDURE reject_mult_bus_class_reqs
80: (
81: p_req_id_tbl IN po_tbl_number,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2
85: );
85: );
86:
87: PROCEDURE reject_mult_ps_reqs
88: (
89: p_req_id_tbl IN po_tbl_number,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2
93: );
93: );
94:
95: PROCEDURE approve_mult_address_reqs
96: (
97: p_req_id_tbl IN po_tbl_number,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2
101: );
101: );
102:
103: PROCEDURE approve_mult_contact_reqs
104: (
105: p_req_id_tbl IN po_tbl_number,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2
109: );
109: );
110:
111: PROCEDURE approve_mult_bus_class_reqs
112: (
113: p_req_id_tbl IN po_tbl_number,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2
117: );
117: );
118:
119: PROCEDURE approve_mult_ps_reqs
120: (
121: p_req_id_tbl IN po_tbl_number,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2
125: );
201: );
202:
203: PROCEDURE reject_mult_cont_addr_reqs
204: ( p_cont_req_id IN NUMBER,
205: p_req_id_tbl IN po_tbl_number,
206: x_return_status OUT nocopy VARCHAR2,
207: x_msg_count OUT nocopy NUMBER,
208: x_msg_data OUT nocopy VARCHAR2
209: );
236: p_url IN VARCHAR2 DEFAULT NULL
237: );
238:
239: PROCEDURE assign_mult_address_to_contact
240: ( p_site_id_tbl IN po_tbl_number,
241: p_cont_party_id IN NUMBER,
242: p_vendor_id IN NUMBER,
243: x_return_status OUT nocopy VARCHAR2,
244: x_msg_count OUT nocopy NUMBER,
245: x_msg_data OUT nocopy VARCHAR2
246: );
247:
248: PROCEDURE assign_user_sec_attr
249: ( p_req_id_tbl IN po_tbl_number,
250: p_usr_id IN NUMBER,
251: p_code_name IN VARCHAR2,
252: x_return_status OUT nocopy VARCHAR2,
253: x_msg_count OUT nocopy NUMBER,