[Home] [Help]
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
327: l_pur_use_id hz_party_site_uses.party_site_use_id%TYPE;
328: l_pay_use_id hz_party_site_uses.party_site_use_id%TYPE;
329:
330: l_party_site_name hz_party_sites.party_site_name%type;
331: BEGIN
332:
333: --dbms_output.put_line (' In update all address types. Start');
334: l_step := 1;
340: pay.object_version_number, pur.object_version_number, rfq.object_version_number,
341: pay.status, pur.status, rfq.status, hps.party_site_name
342: into l_pay_use_id, l_pur_use_id, l_rfq_use_id, l_pay_obj_no, l_pur_obj_no, l_rfq_obj_no,
343: l_pay_status, l_pur_status, l_rfq_status , l_party_site_name
344: from hz_party_sites hps ,hz_party_site_uses pay, hz_party_site_uses pur, hz_party_site_uses rfq
345: where hps.party_site_id = p_party_site_id
346: --and hps.created_by_module like 'POS%'
347: and pay.party_site_id(+) = hps.party_site_id
348: and pur.party_site_id(+) = hps.party_site_id
869:
870: -- set phone for the address
871: update_party_phone(
872: p_party_id => p_party_site_id,
873: p_party_type => 'HZ_PARTY_SITES',
874: p_country_code => null,
875: p_area_code => p_phone_area_code ,
876: p_number => p_phone,
877: p_extension => null,
886:
887: -- set fax for the address
888: update_party_fax(
889: p_party_id => p_party_site_id,
890: p_party_type => 'HZ_PARTY_SITES',
891: p_country_code => null,
892: p_area_code => p_fax_area_code ,
893: p_number => p_fax,
894: p_extension => null,
903: END IF;
904:
905: update_party_email(
906: p_party_id => p_party_site_id,
907: p_party_type => 'HZ_PARTY_SITES',
908: p_email => p_email,
909: x_status => x_status,
910: x_exception_msg => x_exception_msg
911: );
926: IS
927: l_step NUMBER;
928: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
929: l_msg_count NUMBER;
930: l_obj_ver HZ_PARTY_SITES.object_version_number%TYPE;
931: l_created_by_module HZ_PARTY_SITES.created_by_module%TYPE;
932:
933: cursor l_site_cur is
934: select vendor_site_id, party_site_id, vendor_id from ap_supplier_sites_all where party_site_id = p_party_site_id;
927: l_step NUMBER;
928: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
929: l_msg_count NUMBER;
930: l_obj_ver HZ_PARTY_SITES.object_version_number%TYPE;
931: l_created_by_module HZ_PARTY_SITES.created_by_module%TYPE;
932:
933: cursor l_site_cur is
934: select vendor_site_id, party_site_id, vendor_id from ap_supplier_sites_all where party_site_id = p_party_site_id;
935: l_site_rec l_site_cur%ROWTYPE;
954: cursor l_bank_cur is
955: select uses.instrument_id, uses.order_of_preference, uses.start_date,
956: payee.supplier_site_id, payee.org_id, payee.org_type,
957: hps.party_id, uses.instrument_payment_use_id
958: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee, hz_party_sites hps
959: where uses.instrument_type = 'BANKACCOUNT'
960: and payee.ext_payee_id = uses.ext_pmt_party_id
961: and payee.payee_party_id = hps.party_id
962: and payee.payment_function = 'PAYABLES_DISB'
976: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
977: ' p_party_site_id ' || p_party_site_id);
978: END IF;
979:
980: -- End date the party_site in hz_party_sites with party_site_id = p_party_site_id
981: select object_version_number, created_by_module
982: into l_obj_ver, l_created_by_module
983: from hz_party_sites
984: where party_site_id = p_party_site_id;
979:
980: -- End date the party_site in hz_party_sites with party_site_id = p_party_site_id
981: select object_version_number, created_by_module
982: into l_obj_ver, l_created_by_module
983: from hz_party_sites
984: where party_site_id = p_party_site_id;
985:
986: l_party_site_rec.party_site_id := p_party_site_id;
987: l_party_site_rec.status := 'I';