[Home] [Help]
51:
52:
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
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:
346: select object_version_number
347: from hz_locations
348: where (location_id = p_location_id);
349:
350: cursor c_obj_version_site (p_party_site_id hz_party_sites.party_site_id%type) is
351: select object_version_number
352: from hz_party_sites
353: where (party_site_id = p_party_site_id);
354:
348: where (location_id = p_location_id);
349:
350: cursor c_obj_version_site (p_party_site_id hz_party_sites.party_site_id%type) is
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
437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RETURN;
439: END IF;
440: --Added for bug 5263736
441: /* Since the same local variable is used for capturing object version numbers of hz_locations and hz_party_sites first nullify it */
442:
443: l_object_version_number := NULL;
444:
445: OPEN c_obj_version_site (l_party_site_id);
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;
728: l_return_status varchar2(2000);
729: l_msg_count NUMBER;
730: l_msg_data VARCHAR2(2000);
731: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;
732: l_party_site_id HZ_PARTY_SITES.party_site_id %TYPE;
733: l_location_id HZ_LOCATIONS.location_id%type;
734:
735: CURSOR C IS SELECT rowid FROM ap_supplier_sites
736: WHERE vendor_site_id = l_vendor_site_id;
847: l_return_status varchar2(2000);
848: l_msg_count NUMBER;
849: l_msg_data VARCHAR2(2000);
850: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;
851: l_party_site_id HZ_PARTY_SITES.party_site_id %TYPE;
852: l_location_id HZ_LOCATIONS.location_id%type;
853:
854:
855: l_location_rec hz_location_v2pub.location_rec_type;
853:
854:
855: l_location_rec hz_location_v2pub.location_rec_type;
856: l_object_version_number number;
857: cursor c_loc is select LOC.LOCATION_ID from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC,AP_SUPPLIER_SITES_ALL AP
858: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
859: AND LOC.LOCATION_ID = PS.LOCATION_ID
860: AND LOC.LOCATION_ID = AP.LOCATION_ID
861: AND AP.vendor_site_id = X_vendor_site_id
868:
869:
870:
871: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
872: cursor c_party is select PS.party_site_id from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AP_SUPPLIER_SITES_ALL AP
873: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
874: AND AP.vendor_site_id = X_vendor_site_id
875: AND AP.ORG_ID = X_org_id;
876:
873: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
874: AND AP.vendor_site_id = X_vendor_site_id
875: AND AP.ORG_ID = X_org_id;
876:
877: cursor c_obj_version_site (p_party_site_id hz_party_sites.party_site_id%type) is
878: select object_version_number
879: from hz_party_sites
880: where (party_site_id = p_party_site_id);
881: BEGIN
875: AND AP.ORG_ID = X_org_id;
876:
877: cursor c_obj_version_site (p_party_site_id hz_party_sites.party_site_id%type) is
878: select object_version_number
879: from hz_party_sites
880: where (party_site_id = p_party_site_id);
881: BEGIN
882:
883: OPEN C_LOC;