DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ADDR_PKG dependencies on HZ_PARTY_SITE_V2PUB

Line 48: p_party_site_rec_insert HZ_PARTY_SITE_V2PUB.party_site_rec_type;

44: lv_rowid VARCHAR2(25);
45: l_tmp_var1 VARCHAR2(2000);
46: l_tmp_var VARCHAR2(2000);
47: p_location_rec_insert HZ_LOCATION_V2PUB.location_rec_type;
48: p_party_site_rec_insert HZ_PARTY_SITE_V2PUB.party_site_rec_type;
49: l_addr_val_status VARCHAR2(30);
50: l_addr_warn_msg VARCHAR2(2000);
51:
52: CURSOR c_birth_date_val IS SELECT date_of_birth FROM HZ_PERSON_PROFILES

Line 155: HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE

151: P_PARTY_SITE_REC_INSERT.PARTY_SITE_NUMBER := 'IGS-'||l_party_site_number;
152: END IF;
153:
154:
155: HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
156: (
157: P_INIT_MSG_LIST => p_init_msg_list,
158: P_PARTY_SITE_REC => p_party_site_rec_insert,
159: X_RETURN_STATUS => l_return_status,

Line 240: p_party_site_rec_update HZ_PARTY_SITE_V2PUB.party_site_rec_type;

236: l_msg_count NUMBER(15);
237: l_loc_id NUMBER(15);
238: lv_rowid VARCHAR2(25);
239: p_location_rec_update HZ_LOCATION_V2PUB.location_rec_type;
240: p_party_site_rec_update HZ_PARTY_SITE_V2PUB.party_site_rec_type;
241: l_tmp_var1 VARCHAR2(2000);
242: l_tmp_var VARCHAR2(2000);
243: l_start_dt DATE;
244: l_addr_val_status VARCHAR2(30);

Line 329: HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE(

325: l_msg_data := l_tmp_var1;
326: END IF;
327: RETURN;
328: ELSIF l_return_status = 'S' THEN
329: HZ_PARTY_SITE_V2PUB.UPDATE_PARTY_SITE(
330: p_init_msg_list => p_init_msg_list,
331: p_party_site_rec => p_party_site_rec_update,
332: p_object_version_number => p_party_site_ovn,
333: x_return_status => l_return_status,