[Home] [Help]
53: CURSOR C IS SELECT location_id FROM HZ_LOCATIONS
54: WHERE location_id = X_location_id;
55: CURSOR C1 IS SELECT party_site_id FROM HZ_PARTY_SITES
56: WHERE party_site_id = X_party_site_id;
57: CURSOR C2 IS SELECT rowid FROM HZ_CUST_ACCT_SITES
58: WHERE cust_acct_site_id = X_address_id;
59: CURSOR C3 IS SELECT address_id FROM IGI_RA_ADDRESSES
60: WHERE address_id = X_address_id;
61: CURSOR C4 IS SELECT location_id FROM HZ_LOC_ASSIGNMENTS
324: l_msg_data varchar2(2000);
325:
326: l_location_id number;
327: l_object_version_number number;
328: cursor c_loc is select LOC.LOCATION_ID from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
329: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
330: AND LOC.LOCATION_ID = PS.LOCATION_ID
331: AND CS.rowid = x_rowid;
332:
331: AND CS.rowid = x_rowid;
332:
333: l_party_site_id number;
334: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
335: cursor c_party is select PS.party_site_id from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
336: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
337: AND LOC.LOCATION_ID = PS.LOCATION_ID
338: AND CS.rowid = x_rowid;
339:
338: AND CS.rowid = x_rowid;
339:
340: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
341: l_cust_acct_site_id number;
342: cursor c_cust_acct is select cust_acct_site_id from hz_cust_acct_sites
343: where rowid = X_rowid;
344:
345: cursor c_obj_version_loc (p_location_id hz_locations.location_id%type) is
346: select object_version_number
351: select object_version_number
352: from hz_party_sites
353: where (party_site_id = p_party_site_id);
354:
355: cursor c_obj_version_cust_acct (p_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%type) is
356: select object_version_number
357: from hz_cust_acct_sites
358: where (cust_acct_site_id = p_cust_acct_site_id);
359:
353: where (party_site_id = p_party_site_id);
354:
355: cursor c_obj_version_cust_acct (p_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%type) is
356: select object_version_number
357: from hz_cust_acct_sites
358: where (cust_acct_site_id = p_cust_acct_site_id);
359:
360: BEGIN
361: OPEN C_LOC;
455: x_msg_count => l_msg_count,
456: x_msg_data => l_msg_data
457: );
458:
459: /* Since the same local variable is used for capturing object version numbers of hz_locations, hz_party_sites andcust_acc hz_cust_acct_sites first nullify it */
460:
461: l_object_version_number := NULL;
462:
463: OPEN c_obj_version_cust_acct (l_cust_acct_site_id);
483: last_update_login = X_last_update_login,
484: last_update_date = X_last_update_date,
485: last_updated_by = X_last_updated_by
486: WHERE ira.address_id = (select CS.cust_acct_site_id
487: from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
488: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
489: AND LOC.LOCATION_ID = PS.LOCATION_ID
490: AND CS.rowid = x_rowid);
491: END Address_Update_Row;
533: LOC.language,
534: LOC.address_lines_phonetic,
535: CS.customer_category_code,
536: CS.ece_tp_location_code
537: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
538: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
539: AND LOC.LOCATION_ID = PS.LOCATION_ID
540: AND CS.rowid = x_rowid
541: FOR UPDATE OF CS.cust_acct_site_id NOWAIT;
545: CURSOR C1 IS
546: SELECT *
547: FROM igi_ra_addresses ira
548: WHERE ira.address_id = (select CS.cust_acct_site_id
549: from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
550: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
551: AND LOC.LOCATION_ID = PS.LOCATION_ID
552: AND CS.rowid = x_rowid)
553: FOR UPDATE OF ira.address_Id NOWAIT;