118: type resource_details_tbl_type is TABLE OF RESOURCE_DETAILS_REC_TYPE;
119:
120: PROCEDURE Create_party_notification(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_party_notify_Rec IN PV_ASSIGN_UTIL_Pvt.party_notify_rec_type,
126: X_PARTY_NOTIFICATION_ID OUT NOCOPY NUMBER,
119:
120: PROCEDURE Create_party_notification(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_party_notify_Rec IN PV_ASSIGN_UTIL_Pvt.party_notify_rec_type,
126: X_PARTY_NOTIFICATION_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,
120: PROCEDURE Create_party_notification(
121: P_Api_Version_Number IN NUMBER,
122: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: P_party_notify_Rec IN PV_ASSIGN_UTIL_Pvt.party_notify_rec_type,
126: X_PARTY_NOTIFICATION_ID OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,
128: X_Msg_Count OUT NOCOPY NUMBER,
131:
132:
133: procedure create_lead_workflow_row (
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_workflow_rec IN LEAD_WORKFLOW_REC_TYPE
139: ,x_itemkey OUT NOCOPY VARCHAR2
132:
133: procedure create_lead_workflow_row (
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_workflow_rec IN LEAD_WORKFLOW_REC_TYPE
139: ,x_itemkey OUT NOCOPY VARCHAR2
140: ,x_return_status OUT NOCOPY VARCHAR2
133: procedure create_lead_workflow_row (
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_workflow_rec IN LEAD_WORKFLOW_REC_TYPE
139: ,x_itemkey OUT NOCOPY VARCHAR2
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
143:
144:
145: procedure create_lead_assignment_row (
146: p_api_version_number IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150: ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
151: ,x_lead_assignment_id OUT NOCOPY NUMBER
144:
145: procedure create_lead_assignment_row (
146: p_api_version_number IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150: ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
151: ,x_lead_assignment_id OUT NOCOPY NUMBER
152: ,x_return_status OUT NOCOPY VARCHAR2
145: procedure create_lead_assignment_row (
146: p_api_version_number IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150: ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
151: ,x_lead_assignment_id OUT NOCOPY NUMBER
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
155:
156:
157: procedure delete_lead_assignment_row (
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162: ,p_lead_assignment_id IN NUMBER
163: ,x_return_status OUT NOCOPY VARCHAR2
156:
157: procedure delete_lead_assignment_row (
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162: ,p_lead_assignment_id IN NUMBER
163: ,x_return_status OUT NOCOPY VARCHAR2
164: ,x_msg_count OUT NOCOPY NUMBER
157: procedure delete_lead_assignment_row (
158: p_api_version_number IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162: ,p_lead_assignment_id IN NUMBER
163: ,x_return_status OUT NOCOPY VARCHAR2
164: ,x_msg_count OUT NOCOPY NUMBER
165: ,x_msg_data OUT NOCOPY VARCHAR2);
166:
167:
168: procedure get_partner_info (
169: p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_mode IN VARCHAR2, -- VENDOR or EXTERNAL
174: p_partner_id IN NUMBER,
167:
168: procedure get_partner_info (
169: p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_mode IN VARCHAR2, -- VENDOR or EXTERNAL
174: p_partner_id IN NUMBER,
175: p_entity IN VARCHAR2,
168: procedure get_partner_info (
169: p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_mode IN VARCHAR2, -- VENDOR or EXTERNAL
174: p_partner_id IN NUMBER,
175: p_entity IN VARCHAR2,
176: p_entity_id IN NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2);
183:
184: procedure GetWorkflowID (
185: p_api_version_number IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
187: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
188: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
189: ,p_lead_id IN NUMBER
190: ,p_entity IN VARCHAR2
183:
184: procedure GetWorkflowID (
185: p_api_version_number IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
187: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
188: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
189: ,p_lead_id IN NUMBER
190: ,p_entity IN VARCHAR2
191: ,x_itemType OUT NOCOPY VARCHAR2
184: procedure GetWorkflowID (
185: p_api_version_number IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
187: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
188: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
189: ,p_lead_id IN NUMBER
190: ,p_entity IN VARCHAR2
191: ,x_itemType OUT NOCOPY VARCHAR2
192: ,x_itemKey OUT NOCOPY VARCHAR2
197: ,x_msg_data OUT NOCOPY VARCHAR2);
198:
199: procedure UpdateAccess
200: ( p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: p_itemtype IN VARCHAR2,
205: p_itemkey IN VARCHAR2,
198:
199: procedure UpdateAccess
200: ( p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: p_itemtype IN VARCHAR2,
205: p_itemkey IN VARCHAR2,
206: p_current_username IN VARCHAR2,
199: procedure UpdateAccess
200: ( p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: p_itemtype IN VARCHAR2,
205: p_itemkey IN VARCHAR2,
206: p_current_username IN VARCHAR2,
207: p_lead_id IN NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2);
217:
218: procedure Log_assignment_status (
219: p_api_version_number IN NUMBER
220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
224: ,x_return_status OUT NOCOPY VARCHAR2
217:
218: procedure Log_assignment_status (
219: p_api_version_number IN NUMBER
220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
218: procedure Log_assignment_status (
219: p_api_version_number IN NUMBER
220: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
221: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
222: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223: ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
226: ,x_msg_data OUT NOCOPY VARCHAR2);
226: ,x_msg_data OUT NOCOPY VARCHAR2);
227:
228: PROCEDURE removePreferedPartner (
229: p_api_version_number IN NUMBER
230: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
231: , p_commit IN VARCHAR2 := FND_API.G_FALSE
232: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
233: , p_lead_id IN NUMBER
234: , p_item_type IN VARCHAR2
227:
228: PROCEDURE removePreferedPartner (
229: p_api_version_number IN NUMBER
230: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
231: , p_commit IN VARCHAR2 := FND_API.G_FALSE
232: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
233: , p_lead_id IN NUMBER
234: , p_item_type IN VARCHAR2
235: , p_item_key IN VARCHAR2
228: PROCEDURE removePreferedPartner (
229: p_api_version_number IN NUMBER
230: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
231: , p_commit IN VARCHAR2 := FND_API.G_FALSE
232: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
233: , p_lead_id IN NUMBER
234: , p_item_type IN VARCHAR2
235: , p_item_key IN VARCHAR2
236: , p_partner_id IN NUMBER
240:
241:
242: procedure checkforErrors (
243: p_api_version_number IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
245: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
247: ,p_itemtype IN VARCHAR2
248: ,p_itemkey IN VARCHAR2
241:
242: procedure checkforErrors (
243: p_api_version_number IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
245: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
247: ,p_itemtype IN VARCHAR2
248: ,p_itemkey IN VARCHAR2
249: ,x_return_status OUT NOCOPY VARCHAR2
242: procedure checkforErrors (
243: p_api_version_number IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
245: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
247: ,p_itemtype IN VARCHAR2
248: ,p_itemkey IN VARCHAR2
249: ,x_return_status OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER