89:
90:
91: PROCEDURE bulk_cr_party_notification(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
97: X_Return_Status OUT NOCOPY VARCHAR2,
90:
91: PROCEDURE bulk_cr_party_notification(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
97: X_Return_Status OUT NOCOPY VARCHAR2,
98: X_Msg_Count OUT NOCOPY NUMBER,
91: PROCEDURE bulk_cr_party_notification(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
97: X_Return_Status OUT NOCOPY VARCHAR2,
98: X_Msg_Count OUT NOCOPY NUMBER,
99: X_Msg_Data OUT NOCOPY VARCHAR2
101:
102:
103: PROCEDURE Create_assignment_log_row(
104: P_Api_Version_Number IN NUMBER,
105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108: P_assignment_log_rec IN assignment_log_rec_type,
109: X_assignment_id OUT NOCOPY NUMBER,
102:
103: PROCEDURE Create_assignment_log_row(
104: P_Api_Version_Number IN NUMBER,
105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108: P_assignment_log_rec IN assignment_log_rec_type,
109: X_assignment_id OUT NOCOPY NUMBER,
110: X_Return_Status OUT NOCOPY VARCHAR2,
103: PROCEDURE Create_assignment_log_row(
104: P_Api_Version_Number IN NUMBER,
105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108: P_assignment_log_rec IN assignment_log_rec_type,
109: X_assignment_id OUT NOCOPY NUMBER,
110: X_Return_Status OUT NOCOPY VARCHAR2,
111: X_Msg_Count OUT NOCOPY NUMBER,
114:
115:
116: PROCEDURE update_party_response(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: P_rowid IN ROWID,
122: p_lead_assignment_id IN NUMBER,
115:
116: PROCEDURE update_party_response(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: P_rowid IN ROWID,
122: p_lead_assignment_id IN NUMBER,
123: p_party_resource_id IN NUMBER,
116: PROCEDURE update_party_response(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: P_rowid IN ROWID,
122: p_lead_assignment_id IN NUMBER,
123: p_party_resource_id IN NUMBER,
124: p_response IN VARCHAR2,
131:
132:
133: PROCEDURE bulk_set_party_notify_id(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: p_itemtype IN VARCHAR2,
139: p_itemkey IN VARCHAR2,
132:
133: PROCEDURE bulk_set_party_notify_id(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: p_itemtype IN VARCHAR2,
139: p_itemkey IN VARCHAR2,
140: p_notify_type IN VARCHAR2,
133: PROCEDURE bulk_set_party_notify_id(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: p_itemtype IN VARCHAR2,
139: p_itemkey IN VARCHAR2,
140: p_notify_type IN VARCHAR2,
141: X_Return_Status OUT NOCOPY VARCHAR2,
145:
146:
147: procedure UpdateAssignment (
148: p_api_version_number IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152: ,p_action IN VARCHAR2
153: ,p_lead_assignment_id IN number
146:
147: procedure UpdateAssignment (
148: p_api_version_number IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152: ,p_action IN VARCHAR2
153: ,p_lead_assignment_id IN number
154: ,p_status_date IN DATE
147: procedure UpdateAssignment (
148: p_api_version_number IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152: ,p_action IN VARCHAR2
153: ,p_lead_assignment_id IN number
154: ,p_status_date IN DATE
155: ,p_status IN VARCHAR2
161:
162:
163: procedure removeRejectedFromAccess (
164: p_api_version_number IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
166: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
167: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
168: ,p_itemtype IN VARCHAR2
169: ,p_itemkey IN VARCHAR2
162:
163: procedure removeRejectedFromAccess (
164: p_api_version_number IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
166: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
167: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
168: ,p_itemtype IN VARCHAR2
169: ,p_itemkey IN VARCHAR2
170: ,p_partner_id IN VARCHAR2
163: procedure removeRejectedFromAccess (
164: p_api_version_number IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
166: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
167: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
168: ,p_itemtype IN VARCHAR2
169: ,p_itemkey IN VARCHAR2
170: ,p_partner_id IN VARCHAR2
171: ,x_msg_count OUT NOCOPY NUMBER
173: ,x_return_status OUT NOCOPY VARCHAR2);
174:
175: procedure SetPartnerAttributes (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_itemType IN VARCHAR2
181: ,p_itemKey IN VARCHAR2
174:
175: procedure SetPartnerAttributes (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_itemType IN VARCHAR2
181: ,p_itemKey IN VARCHAR2
182: ,p_partner_id IN NUMBER
175: procedure SetPartnerAttributes (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,p_itemType IN VARCHAR2
181: ,p_itemKey IN VARCHAR2
182: ,p_partner_id IN NUMBER
183: ,p_partner_org IN VARCHAR2
186: ,x_return_status OUT NOCOPY VARCHAR2);
187:
188: procedure setTimeout (
189: p_api_version_number IN NUMBER
190: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
192: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193: ,p_itemtype IN VARCHAR2
194: ,p_itemkey IN VARCHAR2
187:
188: procedure setTimeout (
189: p_api_version_number IN NUMBER
190: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
192: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193: ,p_itemtype IN VARCHAR2
194: ,p_itemkey IN VARCHAR2
195: ,p_partner_id IN NUMBER
188: procedure setTimeout (
189: p_api_version_number IN NUMBER
190: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
192: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193: ,p_itemtype IN VARCHAR2
194: ,p_itemkey IN VARCHAR2
195: ,p_partner_id IN NUMBER
196: ,p_timeoutType IN VARCHAR2
199: ,x_return_status OUT NOCOPY VARCHAR2);
200:
201: procedure set_offered_attributes (
202: p_api_version_number IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
204: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_itemType IN VARCHAR2
207: ,p_itemKey IN VARCHAR2
200:
201: procedure set_offered_attributes (
202: p_api_version_number IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
204: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_itemType IN VARCHAR2
207: ,p_itemKey IN VARCHAR2
208: ,p_partner_id IN NUMBER
201: procedure set_offered_attributes (
202: p_api_version_number IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
204: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
205: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206: ,p_itemType IN VARCHAR2
207: ,p_itemKey IN VARCHAR2
208: ,p_partner_id IN NUMBER
209: ,x_msg_count OUT NOCOPY NUMBER
211: ,x_return_status OUT NOCOPY VARCHAR2);
212:
213: procedure update_routing_stage (
214: p_api_version_number IN NUMBER
215: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
218: ,p_itemtype IN VARCHAR2
219: ,p_itemkey IN VARCHAR2
212:
213: procedure update_routing_stage (
214: p_api_version_number IN NUMBER
215: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
218: ,p_itemtype IN VARCHAR2
219: ,p_itemkey IN VARCHAR2
220: ,p_routing_stage IN VARCHAR2
213: procedure update_routing_stage (
214: p_api_version_number IN NUMBER
215: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
218: ,p_itemtype IN VARCHAR2
219: ,p_itemkey IN VARCHAR2
220: ,p_routing_stage IN VARCHAR2
221: ,p_active_but_open_flag IN VARCHAR2
224: ,x_return_status OUT NOCOPY VARCHAR2);
225:
226: procedure StartWorkflow (
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231: p_itemKey IN VARCHAR2,
232: p_itemType IN VARCHAR2,
225:
226: procedure StartWorkflow (
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231: p_itemKey IN VARCHAR2,
232: p_itemType IN VARCHAR2,
233: p_creating_username IN VARCHAR2,
226: procedure StartWorkflow (
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231: p_itemKey IN VARCHAR2,
232: p_itemType IN VARCHAR2,
233: p_creating_username IN VARCHAR2,
234: p_attrib_values_rec IN ATTRIB_VALUES_REC_TYPE,
238:
239:
240: procedure validateResponse (
241: p_api_version_number IN NUMBER
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
243: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
245: ,p_response_code IN VARCHAR2
246: ,p_routing_status IN VARCHAR2
239:
240: procedure validateResponse (
241: p_api_version_number IN NUMBER
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
243: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
245: ,p_response_code IN VARCHAR2
246: ,p_routing_status IN VARCHAR2
247: ,p_decision_maker_flag IN VARCHAR2
240: procedure validateResponse (
241: p_api_version_number IN NUMBER
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
243: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
245: ,p_response_code IN VARCHAR2
246: ,p_routing_status IN VARCHAR2
247: ,p_decision_maker_flag IN VARCHAR2
248: ,p_notify_type IN VARCHAR2
251: ,x_return_status OUT NOCOPY VARCHAR2);
252:
253: procedure set_current_routing_flag (
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_itemKey in varchar2,
259: p_entity IN VARCHAR2,
252:
253: procedure set_current_routing_flag (
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_itemKey in varchar2,
259: p_entity IN VARCHAR2,
260: p_entity_id IN NUMBER,
253: procedure set_current_routing_flag (
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_itemKey in varchar2,
259: p_entity IN VARCHAR2,
260: p_entity_id IN NUMBER,
261: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_data OUT NOCOPY VARCHAR2);
264:
265: PROCEDURE send_notification(
266: P_Api_Version_Number IN NUMBER,
267: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
268: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: p_itemtype IN VARCHAR2,
271: p_itemkey IN VARCHAR2,
264:
265: PROCEDURE send_notification(
266: P_Api_Version_Number IN NUMBER,
267: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
268: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: p_itemtype IN VARCHAR2,
271: p_itemkey IN VARCHAR2,
272: p_activity_id IN NUMBER,
265: PROCEDURE send_notification(
266: P_Api_Version_Number IN NUMBER,
267: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
268: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: p_itemtype IN VARCHAR2,
271: p_itemkey IN VARCHAR2,
272: p_activity_id IN NUMBER,
273: p_route_stage IN VARCHAR2,
277: X_Msg_Data OUT NOCOPY VARCHAR2);
278:
279: procedure AbandonWorkflow (
280: p_api_version_number IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: p_creating_username IN VARCHAR2,
285: p_attrib_values_rec IN attrib_values_rec_type,
278:
279: procedure AbandonWorkflow (
280: p_api_version_number IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: p_creating_username IN VARCHAR2,
285: p_attrib_values_rec IN attrib_values_rec_type,
286: p_partner_org_name IN VARCHAR2,
279: procedure AbandonWorkflow (
280: p_api_version_number IN NUMBER,
281: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284: p_creating_username IN VARCHAR2,
285: p_attrib_values_rec IN attrib_values_rec_type,
286: p_partner_org_name IN VARCHAR2,
287: p_action_reason IN VARCHAR2,
291:
292: PROCEDURE Create_Oppty_Routing_Log_Row
293: (
294: P_Api_Version_Number IN NUMBER,
295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
299: X_Return_Status OUT NOCOPY VARCHAR2,
292: PROCEDURE Create_Oppty_Routing_Log_Row
293: (
294: P_Api_Version_Number IN NUMBER,
295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
299: X_Return_Status OUT NOCOPY VARCHAR2,
300: X_Msg_Count OUT NOCOPY NUMBER,
293: (
294: P_Api_Version_Number IN NUMBER,
295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298: P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
299: X_Return_Status OUT NOCOPY VARCHAR2,
300: X_Msg_Count OUT NOCOPY NUMBER,
301: X_Msg_Data OUT NOCOPY VARCHAR2