8: /* customer in TCA. Also creates account, */
9: /* contact points, bill-to and ship-to addresses */
10: /* */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_person_rec Person Information */
9: /* contact points, bill-to and ship-to addresses */
10: /* */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_person_rec Person Information */
17: /* p_org_rec Organization Info */
10: /* */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_person_rec Person Information */
17: /* p_org_rec Organization Info */
18: /* Required fields for org rec are: */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_person_rec Person Information */
17: /* p_org_rec Organization Info */
18: /* Required fields for org rec are: */
19: /* Organization name */
50: /* x_ship_location_id Ship-to location ID */
51: /* x_ship_party_site_id Ship-to site id */
52: /* x_ship_party_site_number Ship-to site number */
53: /* x_ship_party_site_use_id Ship-to site use id */
54: /* x_return_status Standard OUT param */
55: /* x_msg_count Standard OUT param */
56: /* x_msg_data Standard OUT param */
57: /* */
58: /*----------------------------------------------------------------*/
51: /* x_ship_party_site_id Ship-to site id */
52: /* x_ship_party_site_number Ship-to site number */
53: /* x_ship_party_site_use_id Ship-to site use id */
54: /* x_return_status Standard OUT param */
55: /* x_msg_count Standard OUT param */
56: /* x_msg_data Standard OUT param */
57: /* */
58: /*----------------------------------------------------------------*/
59: PROCEDURE Create_Customer
52: /* x_ship_party_site_number Ship-to site number */
53: /* x_ship_party_site_use_id Ship-to site use id */
54: /* x_return_status Standard OUT param */
55: /* x_msg_count Standard OUT param */
56: /* x_msg_data Standard OUT param */
57: /* */
58: /*----------------------------------------------------------------*/
59: PROCEDURE Create_Customer
60: ( p_api_version IN NUMBER,
103: /* procedure name: Create_Contact */
104: /* description : procedure used to create a person contact */
105: /* in TCA. Also creates contact points. */
106: /* */
107: /* p_api_version Standard IN param */
108: /* p_commit Standard IN param */
109: /* p_init_msg_list Standard IN param */
110: /* p_validation_level Standard IN param */
111: /* p_person_rec Person Information */
104: /* description : procedure used to create a person contact */
105: /* in TCA. Also creates contact points. */
106: /* */
107: /* p_api_version Standard IN param */
108: /* p_commit Standard IN param */
109: /* p_init_msg_list Standard IN param */
110: /* p_validation_level Standard IN param */
111: /* p_person_rec Person Information */
112: /* p_phone_rec Phone Info */
105: /* in TCA. Also creates contact points. */
106: /* */
107: /* p_api_version Standard IN param */
108: /* p_commit Standard IN param */
109: /* p_init_msg_list Standard IN param */
110: /* p_validation_level Standard IN param */
111: /* p_person_rec Person Information */
112: /* p_phone_rec Phone Info */
113: /* p_email_rec Email Info */
106: /* */
107: /* p_api_version Standard IN param */
108: /* p_commit Standard IN param */
109: /* p_init_msg_list Standard IN param */
110: /* p_validation_level Standard IN param */
111: /* p_person_rec Person Information */
112: /* p_phone_rec Phone Info */
113: /* p_email_rec Email Info */
114: /* p_web_rec Web Info */
119: /* x_party_number Party Number gnerated */
120: /* x_phone_id Phone contact point ID */
121: /* x_email_id Email contact point ID */
122: /* x_url_id URL contact point ID */
123: /* x_return_status Standard OUT param */
124: /* x_msg_count Standard OUT param */
125: /* x_msg_data Standard OUT param */
126: /* */
127: /*----------------------------------------------------------------*/
120: /* x_phone_id Phone contact point ID */
121: /* x_email_id Email contact point ID */
122: /* x_url_id URL contact point ID */
123: /* x_return_status Standard OUT param */
124: /* x_msg_count Standard OUT param */
125: /* x_msg_data Standard OUT param */
126: /* */
127: /*----------------------------------------------------------------*/
128: PROCEDURE Create_Contact
121: /* x_email_id Email contact point ID */
122: /* x_url_id URL contact point ID */
123: /* x_return_status Standard OUT param */
124: /* x_msg_count Standard OUT param */
125: /* x_msg_data Standard OUT param */
126: /* */
127: /*----------------------------------------------------------------*/
128: PROCEDURE Create_Contact
129: ( p_api_version IN NUMBER,
151: /* procedure name: Create_Person */
152: /* description : procedure used to create */
153: /* a person in TCA */
154: /* */
155: /* p_api_version Standard IN param */
156: /* p_commit Standard IN param */
157: /* p_init_msg_list Standard IN param */
158: /* p_validation_level Standard IN param */
159: /* p_person_rec Person Information */
152: /* description : procedure used to create */
153: /* a person in TCA */
154: /* */
155: /* p_api_version Standard IN param */
156: /* p_commit Standard IN param */
157: /* p_init_msg_list Standard IN param */
158: /* p_validation_level Standard IN param */
159: /* p_person_rec Person Information */
160: /* x_party_id Party ID generated */
153: /* a person in TCA */
154: /* */
155: /* p_api_version Standard IN param */
156: /* p_commit Standard IN param */
157: /* p_init_msg_list Standard IN param */
158: /* p_validation_level Standard IN param */
159: /* p_person_rec Person Information */
160: /* x_party_id Party ID generated */
161: /* x_party_number Party Number gnerated */
154: /* */
155: /* p_api_version Standard IN param */
156: /* p_commit Standard IN param */
157: /* p_init_msg_list Standard IN param */
158: /* p_validation_level Standard IN param */
159: /* p_person_rec Person Information */
160: /* x_party_id Party ID generated */
161: /* x_party_number Party Number gnerated */
162: /* x_return_status Standard OUT param */
158: /* p_validation_level Standard IN param */
159: /* p_person_rec Person Information */
160: /* x_party_id Party ID generated */
161: /* x_party_number Party Number gnerated */
162: /* x_return_status Standard OUT param */
163: /* x_msg_count Standard OUT param */
164: /* x_msg_data Standard OUT param */
165: /* */
166: /*----------------------------------------------------------------*/
159: /* p_person_rec Person Information */
160: /* x_party_id Party ID generated */
161: /* x_party_number Party Number gnerated */
162: /* x_return_status Standard OUT param */
163: /* x_msg_count Standard OUT param */
164: /* x_msg_data Standard OUT param */
165: /* */
166: /*----------------------------------------------------------------*/
167: PROCEDURE Create_Person
160: /* x_party_id Party ID generated */
161: /* x_party_number Party Number gnerated */
162: /* x_return_status Standard OUT param */
163: /* x_msg_count Standard OUT param */
164: /* x_msg_data Standard OUT param */
165: /* */
166: /*----------------------------------------------------------------*/
167: PROCEDURE Create_Person
168: ( p_api_version IN NUMBER,
181: /* procedure name: Create_Organization */
182: /* description : procedure used to create an organization */
183: /* in TCA */
184: /* */
185: /* p_api_version Standard IN param */
186: /* p_commit Standard IN param */
187: /* p_init_msg_list Standard IN param */
188: /* p_validation_level Standard IN param */
189: /* p_org_rec Organization Info */
182: /* description : procedure used to create an organization */
183: /* in TCA */
184: /* */
185: /* p_api_version Standard IN param */
186: /* p_commit Standard IN param */
187: /* p_init_msg_list Standard IN param */
188: /* p_validation_level Standard IN param */
189: /* p_org_rec Organization Info */
190: /* x_party_id Party ID generated */
183: /* in TCA */
184: /* */
185: /* p_api_version Standard IN param */
186: /* p_commit Standard IN param */
187: /* p_init_msg_list Standard IN param */
188: /* p_validation_level Standard IN param */
189: /* p_org_rec Organization Info */
190: /* x_party_id Party ID generated */
191: /* x_party_number Party Number gnerated */
184: /* */
185: /* p_api_version Standard IN param */
186: /* p_commit Standard IN param */
187: /* p_init_msg_list Standard IN param */
188: /* p_validation_level Standard IN param */
189: /* p_org_rec Organization Info */
190: /* x_party_id Party ID generated */
191: /* x_party_number Party Number gnerated */
192: /* x_return_status Standard OUT param */
188: /* p_validation_level Standard IN param */
189: /* p_org_rec Organization Info */
190: /* x_party_id Party ID generated */
191: /* x_party_number Party Number gnerated */
192: /* x_return_status Standard OUT param */
193: /* x_msg_count Standard OUT param */
194: /* x_msg_data Standard OUT param */
195: /* */
196: /*----------------------------------------------------------------*/
189: /* p_org_rec Organization Info */
190: /* x_party_id Party ID generated */
191: /* x_party_number Party Number gnerated */
192: /* x_return_status Standard OUT param */
193: /* x_msg_count Standard OUT param */
194: /* x_msg_data Standard OUT param */
195: /* */
196: /*----------------------------------------------------------------*/
197: PROCEDURE Create_Organization
190: /* x_party_id Party ID generated */
191: /* x_party_number Party Number gnerated */
192: /* x_return_status Standard OUT param */
193: /* x_msg_count Standard OUT param */
194: /* x_msg_data Standard OUT param */
195: /* */
196: /*----------------------------------------------------------------*/
197: PROCEDURE Create_Organization
198: ( p_api_version IN NUMBER,
211: /* procedure name: Create_Account */
212: /* description : procedure used to create */
213: /* an account for a person */
214: /* */
215: /* p_api_version Standard IN param */
216: /* p_commit Standard IN param */
217: /* p_init_msg_list Standard IN param */
218: /* p_validation_level Standard IN param */
219: /* p_account_rec Account Info */
212: /* description : procedure used to create */
213: /* an account for a person */
214: /* */
215: /* p_api_version Standard IN param */
216: /* p_commit Standard IN param */
217: /* p_init_msg_list Standard IN param */
218: /* p_validation_level Standard IN param */
219: /* p_account_rec Account Info */
220: /* p_person_rec Person Information */
213: /* an account for a person */
214: /* */
215: /* p_api_version Standard IN param */
216: /* p_commit Standard IN param */
217: /* p_init_msg_list Standard IN param */
218: /* p_validation_level Standard IN param */
219: /* p_account_rec Account Info */
220: /* p_person_rec Person Information */
221: /* p_cust_profile_rec Profile Info */
214: /* */
215: /* p_api_version Standard IN param */
216: /* p_commit Standard IN param */
217: /* p_init_msg_list Standard IN param */
218: /* p_validation_level Standard IN param */
219: /* p_account_rec Account Info */
220: /* p_person_rec Person Information */
221: /* p_cust_profile_rec Profile Info */
222: /* x_cust_account_id Account ID generated */
220: /* p_person_rec Person Information */
221: /* p_cust_profile_rec Profile Info */
222: /* x_cust_account_id Account ID generated */
223: /* x_cust_account_number Account Number generated */
224: /* x_return_status Standard OUT param */
225: /* x_msg_count Standard OUT param */
226: /* x_msg_data Standard OUT param */
227: /* */
228: /*----------------------------------------------------------------*/
221: /* p_cust_profile_rec Profile Info */
222: /* x_cust_account_id Account ID generated */
223: /* x_cust_account_number Account Number generated */
224: /* x_return_status Standard OUT param */
225: /* x_msg_count Standard OUT param */
226: /* x_msg_data Standard OUT param */
227: /* */
228: /*----------------------------------------------------------------*/
229: PROCEDURE Create_Account
222: /* x_cust_account_id Account ID generated */
223: /* x_cust_account_number Account Number generated */
224: /* x_return_status Standard OUT param */
225: /* x_msg_count Standard OUT param */
226: /* x_msg_data Standard OUT param */
227: /* */
228: /*----------------------------------------------------------------*/
229: PROCEDURE Create_Account
230: ( p_api_version IN NUMBER,
245: /* procedure name: Create_Account */
246: /* description : procedure used to create */
247: /* an account for an organization */
248: /* */
249: /* p_api_version Standard IN param */
250: /* p_commit Standard IN param */
251: /* p_init_msg_list Standard IN param */
252: /* p_validation_level Standard IN param */
253: /* p_account_rec Account Info */
246: /* description : procedure used to create */
247: /* an account for an organization */
248: /* */
249: /* p_api_version Standard IN param */
250: /* p_commit Standard IN param */
251: /* p_init_msg_list Standard IN param */
252: /* p_validation_level Standard IN param */
253: /* p_account_rec Account Info */
254: /* p_org_rec Organization Info */
247: /* an account for an organization */
248: /* */
249: /* p_api_version Standard IN param */
250: /* p_commit Standard IN param */
251: /* p_init_msg_list Standard IN param */
252: /* p_validation_level Standard IN param */
253: /* p_account_rec Account Info */
254: /* p_org_rec Organization Info */
255: /* p_cust_profile_rec Profile Info */
248: /* */
249: /* p_api_version Standard IN param */
250: /* p_commit Standard IN param */
251: /* p_init_msg_list Standard IN param */
252: /* p_validation_level Standard IN param */
253: /* p_account_rec Account Info */
254: /* p_org_rec Organization Info */
255: /* p_cust_profile_rec Profile Info */
256: /* x_cust_account_id Account ID generated */
254: /* p_org_rec Organization Info */
255: /* p_cust_profile_rec Profile Info */
256: /* x_cust_account_id Account ID generated */
257: /* x_cust_account_number Account Number generated */
258: /* x_return_status Standard OUT param */
259: /* x_msg_count Standard OUT param */
260: /* x_msg_data Standard OUT param */
261: /* */
262: /*----------------------------------------------------------------*/
255: /* p_cust_profile_rec Profile Info */
256: /* x_cust_account_id Account ID generated */
257: /* x_cust_account_number Account Number generated */
258: /* x_return_status Standard OUT param */
259: /* x_msg_count Standard OUT param */
260: /* x_msg_data Standard OUT param */
261: /* */
262: /*----------------------------------------------------------------*/
263: PROCEDURE Create_Account
256: /* x_cust_account_id Account ID generated */
257: /* x_cust_account_number Account Number generated */
258: /* x_return_status Standard OUT param */
259: /* x_msg_count Standard OUT param */
260: /* x_msg_data Standard OUT param */
261: /* */
262: /*----------------------------------------------------------------*/
263: PROCEDURE Create_Account
264: ( p_api_version IN NUMBER,
279: /* procedure name: Create_ContactPoints */
280: /* description : procedure used to create */
281: /* contact points for a party */
282: /* */
283: /* p_api_version Standard IN param */
284: /* p_commit Standard IN param */
285: /* p_init_msg_list Standard IN param */
286: /* p_validation_level Standard IN param */
287: /* p_phone_rec Phone Info */
280: /* description : procedure used to create */
281: /* contact points for a party */
282: /* */
283: /* p_api_version Standard IN param */
284: /* p_commit Standard IN param */
285: /* p_init_msg_list Standard IN param */
286: /* p_validation_level Standard IN param */
287: /* p_phone_rec Phone Info */
288: /* p_email_rec Email Info */
281: /* contact points for a party */
282: /* */
283: /* p_api_version Standard IN param */
284: /* p_commit Standard IN param */
285: /* p_init_msg_list Standard IN param */
286: /* p_validation_level Standard IN param */
287: /* p_phone_rec Phone Info */
288: /* p_email_rec Email Info */
289: /* p_web_rec Web Info */
282: /* */
283: /* p_api_version Standard IN param */
284: /* p_commit Standard IN param */
285: /* p_init_msg_list Standard IN param */
286: /* p_validation_level Standard IN param */
287: /* p_phone_rec Phone Info */
288: /* p_email_rec Email Info */
289: /* p_web_rec Web Info */
290: /* p_create_phone_flag 'Y' to create phone contact point */
293: /* p_party_id Party ID for these contact points */
294: /* x_phone_id Phone contact point ID */
295: /* x_email_id Email contact point ID */
296: /* x_url_id URL contact point ID */
297: /* x_return_status Standard OUT param */
298: /* x_msg_count Standard OUT param */
299: /* x_msg_data Standard OUT param */
300: /* */
301: /*----------------------------------------------------------------*/
294: /* x_phone_id Phone contact point ID */
295: /* x_email_id Email contact point ID */
296: /* x_url_id URL contact point ID */
297: /* x_return_status Standard OUT param */
298: /* x_msg_count Standard OUT param */
299: /* x_msg_data Standard OUT param */
300: /* */
301: /*----------------------------------------------------------------*/
302: PROCEDURE Create_ContactPoints
295: /* x_email_id Email contact point ID */
296: /* x_url_id URL contact point ID */
297: /* x_return_status Standard OUT param */
298: /* x_msg_count Standard OUT param */
299: /* x_msg_data Standard OUT param */
300: /* */
301: /*----------------------------------------------------------------*/
302: PROCEDURE Create_ContactPoints
303: ( p_api_version IN NUMBER,
325: /* address records in TCA */
326: /* This includes creating a location, site, */
327: /* and site use. */
328: /* */
329: /* p_api_version Standard IN param */
330: /* p_commit Standard IN param */
331: /* p_init_msg_list Standard IN param */
332: /* p_validation_level Standard IN param */
333: /* p_loc_rec Location */
326: /* This includes creating a location, site, */
327: /* and site use. */
328: /* */
329: /* p_api_version Standard IN param */
330: /* p_commit Standard IN param */
331: /* p_init_msg_list Standard IN param */
332: /* p_validation_level Standard IN param */
333: /* p_loc_rec Location */
334: /* p_location_id Location ID, if it already exists */
327: /* and site use. */
328: /* */
329: /* p_api_version Standard IN param */
330: /* p_commit Standard IN param */
331: /* p_init_msg_list Standard IN param */
332: /* p_validation_level Standard IN param */
333: /* p_loc_rec Location */
334: /* p_location_id Location ID, if it already exists */
335: /* x_party_site_rec Site */
328: /* */
329: /* p_api_version Standard IN param */
330: /* p_commit Standard IN param */
331: /* p_init_msg_list Standard IN param */
332: /* p_validation_level Standard IN param */
333: /* p_loc_rec Location */
334: /* p_location_id Location ID, if it already exists */
335: /* x_party_site_rec Site */
336: /* x_party_site_use_rec Site use */
337: /* x_location_id Location ID created/used */
338: /* x_party_site_id Site id */
339: /* x_party_site_number Site number */
340: /* x_party_site_use_id Site use id */
341: /* x_return_status Standard OUT param */
342: /* x_msg_count Standard OUT param */
343: /* x_msg_data Standard OUT param */
344: /* */
345: /*----------------------------------------------------------------*/
338: /* x_party_site_id Site id */
339: /* x_party_site_number Site number */
340: /* x_party_site_use_id Site use id */
341: /* x_return_status Standard OUT param */
342: /* x_msg_count Standard OUT param */
343: /* x_msg_data Standard OUT param */
344: /* */
345: /*----------------------------------------------------------------*/
346: PROCEDURE Create_AddressRecords
339: /* x_party_site_number Site number */
340: /* x_party_site_use_id Site use id */
341: /* x_return_status Standard OUT param */
342: /* x_msg_count Standard OUT param */
343: /* x_msg_data Standard OUT param */
344: /* */
345: /*----------------------------------------------------------------*/
346: PROCEDURE Create_AddressRecords
347: ( p_api_version IN NUMBER,
365: /* procedure name: Create_Address */
366: /* description : procedure used to create */
367: /* a location in TCA */
368: /* */
369: /* p_api_version Standard IN param */
370: /* p_commit Standard IN param */
371: /* p_init_msg_list Standard IN param */
372: /* p_validation_level Standard IN param */
373: /* p_address_rec Location to create */
366: /* description : procedure used to create */
367: /* a location in TCA */
368: /* */
369: /* p_api_version Standard IN param */
370: /* p_commit Standard IN param */
371: /* p_init_msg_list Standard IN param */
372: /* p_validation_level Standard IN param */
373: /* p_address_rec Location to create */
374: /* x_location_id Location ID created */
367: /* a location in TCA */
368: /* */
369: /* p_api_version Standard IN param */
370: /* p_commit Standard IN param */
371: /* p_init_msg_list Standard IN param */
372: /* p_validation_level Standard IN param */
373: /* p_address_rec Location to create */
374: /* x_location_id Location ID created */
375: /* x_return_status Standard OUT param */
368: /* */
369: /* p_api_version Standard IN param */
370: /* p_commit Standard IN param */
371: /* p_init_msg_list Standard IN param */
372: /* p_validation_level Standard IN param */
373: /* p_address_rec Location to create */
374: /* x_location_id Location ID created */
375: /* x_return_status Standard OUT param */
376: /* x_msg_count Standard OUT param */
371: /* p_init_msg_list Standard IN param */
372: /* p_validation_level Standard IN param */
373: /* p_address_rec Location to create */
374: /* x_location_id Location ID created */
375: /* x_return_status Standard OUT param */
376: /* x_msg_count Standard OUT param */
377: /* x_msg_data Standard OUT param */
378: /* */
379: /*----------------------------------------------------------------*/
372: /* p_validation_level Standard IN param */
373: /* p_address_rec Location to create */
374: /* x_location_id Location ID created */
375: /* x_return_status Standard OUT param */
376: /* x_msg_count Standard OUT param */
377: /* x_msg_data Standard OUT param */
378: /* */
379: /*----------------------------------------------------------------*/
380: PROCEDURE Create_Address
373: /* p_address_rec Location to create */
374: /* x_location_id Location ID created */
375: /* x_return_status Standard OUT param */
376: /* x_msg_count Standard OUT param */
377: /* x_msg_data Standard OUT param */
378: /* */
379: /*----------------------------------------------------------------*/
380: PROCEDURE Create_Address
381: ( p_api_version IN NUMBER,
393: /* procedure name: Create_Relationship */
394: /* description : procedure used to create */
395: /* a relationship between parties */
396: /* */
397: /* p_api_version Standard IN param */
398: /* p_commit Standard IN param */
399: /* p_init_msg_list Standard IN param */
400: /* p_validation_level Standard IN param */
401: /* p_party_rel_rec Party relationship to create */
394: /* description : procedure used to create */
395: /* a relationship between parties */
396: /* */
397: /* p_api_version Standard IN param */
398: /* p_commit Standard IN param */
399: /* p_init_msg_list Standard IN param */
400: /* p_validation_level Standard IN param */
401: /* p_party_rel_rec Party relationship to create */
402: /* x_party_rel_id Relationship ID generated */
395: /* a relationship between parties */
396: /* */
397: /* p_api_version Standard IN param */
398: /* p_commit Standard IN param */
399: /* p_init_msg_list Standard IN param */
400: /* p_validation_level Standard IN param */
401: /* p_party_rel_rec Party relationship to create */
402: /* x_party_rel_id Relationship ID generated */
403: /* x_return_status Standard OUT param */
396: /* */
397: /* p_api_version Standard IN param */
398: /* p_commit Standard IN param */
399: /* p_init_msg_list Standard IN param */
400: /* p_validation_level Standard IN param */
401: /* p_party_rel_rec Party relationship to create */
402: /* x_party_rel_id Relationship ID generated */
403: /* x_return_status Standard OUT param */
404: /* x_msg_count Standard OUT param */
399: /* p_init_msg_list Standard IN param */
400: /* p_validation_level Standard IN param */
401: /* p_party_rel_rec Party relationship to create */
402: /* x_party_rel_id Relationship ID generated */
403: /* x_return_status Standard OUT param */
404: /* x_msg_count Standard OUT param */
405: /* x_msg_data Standard OUT param */
406: /* */
407: /*----------------------------------------------------------------*/
400: /* p_validation_level Standard IN param */
401: /* p_party_rel_rec Party relationship to create */
402: /* x_party_rel_id Relationship ID generated */
403: /* x_return_status Standard OUT param */
404: /* x_msg_count Standard OUT param */
405: /* x_msg_data Standard OUT param */
406: /* */
407: /*----------------------------------------------------------------*/
408: PROCEDURE Create_Relationship
401: /* p_party_rel_rec Party relationship to create */
402: /* x_party_rel_id Relationship ID generated */
403: /* x_return_status Standard OUT param */
404: /* x_msg_count Standard OUT param */
405: /* x_msg_data Standard OUT param */
406: /* */
407: /*----------------------------------------------------------------*/
408: PROCEDURE Create_Relationship
409: ( p_api_version IN NUMBER,
421: /* procedure name: Update_Party */
422: /* description : procedure used to update */
423: /* a party in TCA */
424: /* */
425: /* p_api_version Standard IN param */
426: /* p_commit Standard IN param */
427: /* p_init_msg_list Standard IN param */
428: /* p_validation_level Standard IN param */
429: /* p_person_rec Person Information */
422: /* description : procedure used to update */
423: /* a party in TCA */
424: /* */
425: /* p_api_version Standard IN param */
426: /* p_commit Standard IN param */
427: /* p_init_msg_list Standard IN param */
428: /* p_validation_level Standard IN param */
429: /* p_person_rec Person Information */
430: /* p_org_rec Organization Info */
423: /* a party in TCA */
424: /* */
425: /* p_api_version Standard IN param */
426: /* p_commit Standard IN param */
427: /* p_init_msg_list Standard IN param */
428: /* p_validation_level Standard IN param */
429: /* p_person_rec Person Information */
430: /* p_org_rec Organization Info */
431: /* p_party_type 'PERSON' or 'ORGANIZATION' */
424: /* */
425: /* p_api_version Standard IN param */
426: /* p_commit Standard IN param */
427: /* p_init_msg_list Standard IN param */
428: /* p_validation_level Standard IN param */
429: /* p_person_rec Person Information */
430: /* p_org_rec Organization Info */
431: /* p_party_type 'PERSON' or 'ORGANIZATION' */
432: /* p_obj_ver_num Last version for party */
430: /* p_org_rec Organization Info */
431: /* p_party_type 'PERSON' or 'ORGANIZATION' */
432: /* p_obj_ver_num Last version for party */
433: /* x_obj_ver_num New Last version for party */
434: /* x_return_status Standard OUT param */
435: /* x_msg_count Standard OUT param */
436: /* x_msg_data Standard OUT param */
437: /* */
438: /*----------------------------------------------------------------*/
431: /* p_party_type 'PERSON' or 'ORGANIZATION' */
432: /* p_obj_ver_num Last version for party */
433: /* x_obj_ver_num New Last version for party */
434: /* x_return_status Standard OUT param */
435: /* x_msg_count Standard OUT param */
436: /* x_msg_data Standard OUT param */
437: /* */
438: /*----------------------------------------------------------------*/
439: PROCEDURE Update_Party
432: /* p_obj_ver_num Last version for party */
433: /* x_obj_ver_num New Last version for party */
434: /* x_return_status Standard OUT param */
435: /* x_msg_count Standard OUT param */
436: /* x_msg_data Standard OUT param */
437: /* */
438: /*----------------------------------------------------------------*/
439: PROCEDURE Update_Party
440: ( p_api_version IN NUMBER,
455: /* procedure name: Update_Person */
456: /* description : procedure used to update */
457: /* a person in TCA */
458: /* */
459: /* p_api_version Standard IN param */
460: /* p_commit Standard IN param */
461: /* p_init_msg_list Standard IN param */
462: /* p_validation_level Standard IN param */
463: /* p_person_rec Person Information */
456: /* description : procedure used to update */
457: /* a person in TCA */
458: /* */
459: /* p_api_version Standard IN param */
460: /* p_commit Standard IN param */
461: /* p_init_msg_list Standard IN param */
462: /* p_validation_level Standard IN param */
463: /* p_person_rec Person Information */
464: /* p_obj_ver_num Last version for person */
457: /* a person in TCA */
458: /* */
459: /* p_api_version Standard IN param */
460: /* p_commit Standard IN param */
461: /* p_init_msg_list Standard IN param */
462: /* p_validation_level Standard IN param */
463: /* p_person_rec Person Information */
464: /* p_obj_ver_num Last version for person */
465: /* x_obj_ver_num New Last version for person */
458: /* */
459: /* p_api_version Standard IN param */
460: /* p_commit Standard IN param */
461: /* p_init_msg_list Standard IN param */
462: /* p_validation_level Standard IN param */
463: /* p_person_rec Person Information */
464: /* p_obj_ver_num Last version for person */
465: /* x_obj_ver_num New Last version for person */
466: /* x_return_status Standard OUT param */
462: /* p_validation_level Standard IN param */
463: /* p_person_rec Person Information */
464: /* p_obj_ver_num Last version for person */
465: /* x_obj_ver_num New Last version for person */
466: /* x_return_status Standard OUT param */
467: /* x_msg_count Standard OUT param */
468: /* x_msg_data Standard OUT param */
469: /* */
470: /*----------------------------------------------------------------*/
463: /* p_person_rec Person Information */
464: /* p_obj_ver_num Last version for person */
465: /* x_obj_ver_num New Last version for person */
466: /* x_return_status Standard OUT param */
467: /* x_msg_count Standard OUT param */
468: /* x_msg_data Standard OUT param */
469: /* */
470: /*----------------------------------------------------------------*/
471: PROCEDURE Update_Person
464: /* p_obj_ver_num Last version for person */
465: /* x_obj_ver_num New Last version for person */
466: /* x_return_status Standard OUT param */
467: /* x_msg_count Standard OUT param */
468: /* x_msg_data Standard OUT param */
469: /* */
470: /*----------------------------------------------------------------*/
471: PROCEDURE Update_Person
472: ( p_api_version IN NUMBER,
485: /* procedure name: Update_Organization */
486: /* description : procedure used to update */
487: /* an organization in TCA */
488: /* */
489: /* p_api_version Standard IN param */
490: /* p_commit Standard IN param */
491: /* p_init_msg_list Standard IN param */
492: /* p_validation_level Standard IN param */
493: /* p_org_rec Organization Info */
486: /* description : procedure used to update */
487: /* an organization in TCA */
488: /* */
489: /* p_api_version Standard IN param */
490: /* p_commit Standard IN param */
491: /* p_init_msg_list Standard IN param */
492: /* p_validation_level Standard IN param */
493: /* p_org_rec Organization Info */
494: /* The following fields must be set */
487: /* an organization in TCA */
488: /* */
489: /* p_api_version Standard IN param */
490: /* p_commit Standard IN param */
491: /* p_init_msg_list Standard IN param */
492: /* p_validation_level Standard IN param */
493: /* p_org_rec Organization Info */
494: /* The following fields must be set */
495: /* and are non-updatable: */
488: /* */
489: /* p_api_version Standard IN param */
490: /* p_commit Standard IN param */
491: /* p_init_msg_list Standard IN param */
492: /* p_validation_level Standard IN param */
493: /* p_org_rec Organization Info */
494: /* The following fields must be set */
495: /* and are non-updatable: */
496: /* party_rec.party_id */
498: /* party_rec.status */
499: /* party_rec.orig_system_reference */
500: /* p_obj_ver_num Last version num for org */
501: /* x_obj_ver_num New Last version num for org */
502: /* x_return_status Standard OUT param */
503: /* x_msg_count Standard OUT param */
504: /* x_msg_data Standard OUT param */
505: /* */
506: /*----------------------------------------------------------------*/
499: /* party_rec.orig_system_reference */
500: /* p_obj_ver_num Last version num for org */
501: /* x_obj_ver_num New Last version num for org */
502: /* x_return_status Standard OUT param */
503: /* x_msg_count Standard OUT param */
504: /* x_msg_data Standard OUT param */
505: /* */
506: /*----------------------------------------------------------------*/
507: PROCEDURE Update_Organization
500: /* p_obj_ver_num Last version num for org */
501: /* x_obj_ver_num New Last version num for org */
502: /* x_return_status Standard OUT param */
503: /* x_msg_count Standard OUT param */
504: /* x_msg_data Standard OUT param */
505: /* */
506: /*----------------------------------------------------------------*/
507: PROCEDURE Update_Organization
508: ( p_api_version IN NUMBER,
520: /* procedure name: Update_Account */
521: /* description : procedure used to update */
522: /* an account for a party */
523: /* */
524: /* p_api_version Standard IN param */
525: /* p_commit Standard IN param */
526: /* p_init_msg_list Standard IN param */
527: /* p_validation_level Standard IN param */
528: /* p_cust_acct_rec Account Info */
521: /* description : procedure used to update */
522: /* an account for a party */
523: /* */
524: /* p_api_version Standard IN param */
525: /* p_commit Standard IN param */
526: /* p_init_msg_list Standard IN param */
527: /* p_validation_level Standard IN param */
528: /* p_cust_acct_rec Account Info */
529: /* p_obj_ver_num Last version num for account */
522: /* an account for a party */
523: /* */
524: /* p_api_version Standard IN param */
525: /* p_commit Standard IN param */
526: /* p_init_msg_list Standard IN param */
527: /* p_validation_level Standard IN param */
528: /* p_cust_acct_rec Account Info */
529: /* p_obj_ver_num Last version num for account */
530: /* x_obj_ver_num New Last version num for account */
523: /* */
524: /* p_api_version Standard IN param */
525: /* p_commit Standard IN param */
526: /* p_init_msg_list Standard IN param */
527: /* p_validation_level Standard IN param */
528: /* p_cust_acct_rec Account Info */
529: /* p_obj_ver_num Last version num for account */
530: /* x_obj_ver_num New Last version num for account */
531: /* x_return_status Standard OUT param */
527: /* p_validation_level Standard IN param */
528: /* p_cust_acct_rec Account Info */
529: /* p_obj_ver_num Last version num for account */
530: /* x_obj_ver_num New Last version num for account */
531: /* x_return_status Standard OUT param */
532: /* x_msg_count Standard OUT param */
533: /* x_msg_data Standard OUT param */
534: /* */
535: /*----------------------------------------------------------------*/
528: /* p_cust_acct_rec Account Info */
529: /* p_obj_ver_num Last version num for account */
530: /* x_obj_ver_num New Last version num for account */
531: /* x_return_status Standard OUT param */
532: /* x_msg_count Standard OUT param */
533: /* x_msg_data Standard OUT param */
534: /* */
535: /*----------------------------------------------------------------*/
536: PROCEDURE Update_Account
529: /* p_obj_ver_num Last version num for account */
530: /* x_obj_ver_num New Last version num for account */
531: /* x_return_status Standard OUT param */
532: /* x_msg_count Standard OUT param */
533: /* x_msg_data Standard OUT param */
534: /* */
535: /*----------------------------------------------------------------*/
536: PROCEDURE Update_Account
537: ( p_api_version IN NUMBER,
549: /* procedure name: Update_ContactPoints */
550: /* description : procedure used to update */
551: /* contact points for a party */
552: /* */
553: /* p_api_version Standard IN param */
554: /* p_commit Standard IN param */
555: /* p_init_msg_list Standard IN param */
556: /* p_validation_level Standard IN param */
557: /* p_phone_rec Phone Info */
550: /* description : procedure used to update */
551: /* contact points for a party */
552: /* */
553: /* p_api_version Standard IN param */
554: /* p_commit Standard IN param */
555: /* p_init_msg_list Standard IN param */
556: /* p_validation_level Standard IN param */
557: /* p_phone_rec Phone Info */
558: /* p_email_rec Email Info */
551: /* contact points for a party */
552: /* */
553: /* p_api_version Standard IN param */
554: /* p_commit Standard IN param */
555: /* p_init_msg_list Standard IN param */
556: /* p_validation_level Standard IN param */
557: /* p_phone_rec Phone Info */
558: /* p_email_rec Email Info */
559: /* p_web_rec Web Info */
552: /* */
553: /* p_api_version Standard IN param */
554: /* p_commit Standard IN param */
555: /* p_init_msg_list Standard IN param */
556: /* p_validation_level Standard IN param */
557: /* p_phone_rec Phone Info */
558: /* p_email_rec Email Info */
559: /* p_web_rec Web Info */
560: /* p_phone_cnt_point_id ID of phone contact point */
568: /* p_update_url_flag 'Y' to update url contact point */
569: /* x_phone_obj_ver_num New Last version num for phone */
570: /* x_email_obj_ver_num New Last version num for email */
571: /* x_url_obj_ver_num New Last version num for url */
572: /* x_return_status Standard OUT param */
573: /* x_msg_count Standard OUT param */
574: /* x_msg_data Standard OUT param */
575: /* */
576: /*----------------------------------------------------------------*/
569: /* x_phone_obj_ver_num New Last version num for phone */
570: /* x_email_obj_ver_num New Last version num for email */
571: /* x_url_obj_ver_num New Last version num for url */
572: /* x_return_status Standard OUT param */
573: /* x_msg_count Standard OUT param */
574: /* x_msg_data Standard OUT param */
575: /* */
576: /*----------------------------------------------------------------*/
577: PROCEDURE Update_ContactPoints
570: /* x_email_obj_ver_num New Last version num for email */
571: /* x_url_obj_ver_num New Last version num for url */
572: /* x_return_status Standard OUT param */
573: /* x_msg_count Standard OUT param */
574: /* x_msg_data Standard OUT param */
575: /* */
576: /*----------------------------------------------------------------*/
577: PROCEDURE Update_ContactPoints
578: (
604: /* procedure name: Update_AddressRecords */
605: /* description : procedure used to update */
606: /* an address record in TCA */
607: /* */
608: /* p_api_version Standard IN param */
609: /* p_commit Standard IN param */
610: /* p_init_msg_list Standard IN param */
611: /* p_validation_level Standard IN param */
612: /* p_location_id Location ID, if it already exists */
605: /* description : procedure used to update */
606: /* an address record in TCA */
607: /* */
608: /* p_api_version Standard IN param */
609: /* p_commit Standard IN param */
610: /* p_init_msg_list Standard IN param */
611: /* p_validation_level Standard IN param */
612: /* p_location_id Location ID, if it already exists */
613: /* p_loc_rec Location */
606: /* an address record in TCA */
607: /* */
608: /* p_api_version Standard IN param */
609: /* p_commit Standard IN param */
610: /* p_init_msg_list Standard IN param */
611: /* p_validation_level Standard IN param */
612: /* p_location_id Location ID, if it already exists */
613: /* p_loc_rec Location */
614: /* p_addr_obj_ver_num Last version of the location */
607: /* */
608: /* p_api_version Standard IN param */
609: /* p_commit Standard IN param */
610: /* p_init_msg_list Standard IN param */
611: /* p_validation_level Standard IN param */
612: /* p_location_id Location ID, if it already exists */
613: /* p_loc_rec Location */
614: /* p_addr_obj_ver_num Last version of the location */
615: /* p_site_obj_ver_num Last version of the site */
615: /* p_site_obj_ver_num Last version of the site */
616: /* x_party_site_rec Site */
617: /* x_addr_obj_ver_num New Last version of the location */
618: /* x_site_obj_ver_num New Last version of the site */
619: /* x_return_status Standard OUT param */
620: /* x_msg_count Standard OUT param */
621: /* x_msg_data Standard OUT param */
622: /* */
623: /*----------------------------------------------------------------*/
616: /* x_party_site_rec Site */
617: /* x_addr_obj_ver_num New Last version of the location */
618: /* x_site_obj_ver_num New Last version of the site */
619: /* x_return_status Standard OUT param */
620: /* x_msg_count Standard OUT param */
621: /* x_msg_data Standard OUT param */
622: /* */
623: /*----------------------------------------------------------------*/
624: PROCEDURE Update_AddressRecords
617: /* x_addr_obj_ver_num New Last version of the location */
618: /* x_site_obj_ver_num New Last version of the site */
619: /* x_return_status Standard OUT param */
620: /* x_msg_count Standard OUT param */
621: /* x_msg_data Standard OUT param */
622: /* */
623: /*----------------------------------------------------------------*/
624: PROCEDURE Update_AddressRecords
625: (
642: /* procedure name: Update_Address */
643: /* description : procedure used to update */
644: /* a location in TCA */
645: /* */
646: /* p_api_version Standard IN param */
647: /* p_commit Standard IN param */
648: /* p_init_msg_list Standard IN param */
649: /* p_validation_level Standard IN param */
650: /* p_address_rec Location to create */
643: /* description : procedure used to update */
644: /* a location in TCA */
645: /* */
646: /* p_api_version Standard IN param */
647: /* p_commit Standard IN param */
648: /* p_init_msg_list Standard IN param */
649: /* p_validation_level Standard IN param */
650: /* p_address_rec Location to create */
651: /* p_obj_ver_num Last version num of the location */
644: /* a location in TCA */
645: /* */
646: /* p_api_version Standard IN param */
647: /* p_commit Standard IN param */
648: /* p_init_msg_list Standard IN param */
649: /* p_validation_level Standard IN param */
650: /* p_address_rec Location to create */
651: /* p_obj_ver_num Last version num of the location */
652: /* prior to calling this procedure */
645: /* */
646: /* p_api_version Standard IN param */
647: /* p_commit Standard IN param */
648: /* p_init_msg_list Standard IN param */
649: /* p_validation_level Standard IN param */
650: /* p_address_rec Location to create */
651: /* p_obj_ver_num Last version num of the location */
652: /* prior to calling this procedure */
653: /* x_obj_ver_num Last version num of the location */
651: /* p_obj_ver_num Last version num of the location */
652: /* prior to calling this procedure */
653: /* x_obj_ver_num Last version num of the location */
654: /* after completing this procedure */
655: /* x_return_status Standard OUT param */
656: /* x_msg_count Standard OUT param */
657: /* x_msg_data Standard OUT param */
658: /* */
659: /*----------------------------------------------------------------*/
652: /* prior to calling this procedure */
653: /* x_obj_ver_num Last version num of the location */
654: /* after completing this procedure */
655: /* x_return_status Standard OUT param */
656: /* x_msg_count Standard OUT param */
657: /* x_msg_data Standard OUT param */
658: /* */
659: /*----------------------------------------------------------------*/
660: PROCEDURE Update_Address
653: /* x_obj_ver_num Last version num of the location */
654: /* after completing this procedure */
655: /* x_return_status Standard OUT param */
656: /* x_msg_count Standard OUT param */
657: /* x_msg_data Standard OUT param */
658: /* */
659: /*----------------------------------------------------------------*/
660: PROCEDURE Update_Address
661: (