eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_PERSON_SS_PKG dependencies on HZ_PARTIES

Line 228: p_hz_parties_ovn IN OUT NOCOPY NUMBER,

224: p_title IN VARCHAR2,
225: p_birth_dt IN DATE,
226: p_preferred_name IN VARCHAR2,
227: p_api_person_id IN VARCHAR2,
228: p_hz_parties_ovn IN OUT NOCOPY NUMBER,
229: p_attribute_category IN VARCHAR2,
230: p_attribute1 IN VARCHAR2,
231: p_attribute2 IN VARCHAR2,
232: p_attribute3 IN VARCHAR2,

Line 266: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS

262: WHERE preferred_ind ='Y';
263:
264: pref_id_rec pref_id_cur%ROWTYPE;
265:
266: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
267: SELECT p.rowid row_id,
268: p.party_number person_number,
269: p.person_last_name surname ,
270: p.person_first_name given_names ,

Line 287: FROM hz_parties p,

283: pd.level_of_qual level_of_qual_id ,
284: pd.military_service_reg ,
285: pd.veteran ,
286: p.object_version_number
287: FROM hz_parties p,
288: igs_pe_hz_parties pd,
289: hz_person_profiles pp
290: WHERE p.party_id = cp_person_id
291: AND p.party_id = pd.party_id (+)

Line 288: igs_pe_hz_parties pd,

284: pd.military_service_reg ,
285: pd.veteran ,
286: p.object_version_number
287: FROM hz_parties p,
288: igs_pe_hz_parties pd,
289: hz_person_profiles pp
290: WHERE p.party_id = cp_person_id
291: AND p.party_id = pd.party_id (+)
292: AND p.party_id = pp.party_id

Line 352: x_hz_parties_ovn => c_person_rec.object_version_number,

348: x_email_addr => c_person_rec.email_addr,
349: x_level_of_qual_id => c_person_rec.level_of_qual_id,
350: x_military_service_reg => c_person_rec.military_service_reg,
351: x_veteran => c_person_rec.veteran,
352: x_hz_parties_ovn => c_person_rec.object_version_number,
353: x_attribute_category => p_attribute_category,
354: x_attribute1 => p_attribute1,
355: x_attribute2 => p_attribute2,
356: x_attribute3 => p_attribute3,

Line 555: OPEN dup_phone_cur(p_person_id,'PHONE','HZ_PARTIES','I',l_phone_number);

551: IF (p_email_format IS NULL) THEN
552:
553: l_phone_number := p_phone_country_code||'-'||p_phone_area_code||'-'||p_phone_number||'-'||p_phone_extension;
554:
555: OPEN dup_phone_cur(p_person_id,'PHONE','HZ_PARTIES','I',l_phone_number);
556: FETCH dup_phone_cur INTO dup_phone_rec;
557: CLOSE dup_phone_cur;
558:
559: IF dup_phone_rec.contact_point_id IS NOT NULL THEN

Line 566: OPEN dup_email_cur(p_person_id,'EMAIL','HZ_PARTIES','I',p_email_address);

562: l_object_version_number := dup_phone_rec.object_version_number;
563: END IF;
564:
565: ELSE
566: OPEN dup_email_cur(p_person_id,'EMAIL','HZ_PARTIES','I',p_email_address);
567: FETCH dup_email_cur INTO dup_email_rec;
568: CLOSE dup_email_cur;
569:
570: IF dup_email_rec.contact_point_id IS NOT NULL THEN

Line 588: p_owner_table_name => 'HZ_PARTIES',

584: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(
585: p_action => 'UPDATE',
586: p_rowid => l_rowid,
587: p_status => p_status,
588: p_owner_table_name => 'HZ_PARTIES',
589: p_owner_table_id => p_person_id,
590: P_primary_flag => p_primary_flag,
591: p_phone_country_code => p_phone_country_code,
592: p_phone_area_code => p_phone_area_code,

Line 628: p_owner_table_name => 'HZ_PARTIES',

624: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
625: p_action => 'UPDATE',
626: p_rowid => l_rowid,
627: p_status => p_status,
628: p_owner_table_name => 'HZ_PARTIES',
629: p_owner_table_id => p_person_id,
630: P_primary_flag => p_primary_flag,
631: p_email_format => p_email_format,
632: p_email_address => p_email_address,

Line 671: p_owner_table_name => 'HZ_PARTIES',

667: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(
668: p_action => 'INSERT',
669: p_rowid => l_rowid ,
670: p_status => p_status,
671: p_owner_table_name => 'HZ_PARTIES',
672: p_owner_table_id => p_person_id,
673: P_primary_flag => p_primary_flag,
674: p_phone_country_code => p_phone_country_code,
675: p_phone_area_code => p_phone_area_code,

Line 690: p_owner_table_name => 'HZ_PARTIES',

686: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
687: p_action => 'INSERT',
688: p_rowid => l_rowid ,
689: p_status => p_status,
690: p_owner_table_name => 'HZ_PARTIES',
691: p_owner_table_id => p_person_id,
692: P_primary_flag => p_primary_flag,
693: p_email_format => p_email_format,
694: p_email_address => p_email_address,

Line 1134: p_hz_parties_ovn IN OUT NOCOPY NUMBER,

1130: p_pre_name_adjunct IN VARCHAR2,
1131: p_suffix IN VARCHAR2,
1132: p_title IN VARCHAR2,
1133: p_rel_end IN VARCHAR2,
1134: p_hz_parties_ovn IN OUT NOCOPY NUMBER,
1135: p_hz_rel_ovn IN OUT NOCOPY NUMBER
1136: )
1137: IS
1138: BEGIN

Line 1410: CURSOR pehz_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

1406: l_party_rec_type Hz_Party_V2Pub.PARTY_REC_TYPE;
1407: v_party_last_update_date hz_person_profiles.last_update_date%TYPE;
1408: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;
1409:
1410: CURSOR pehz_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1411: SELECT pehz.ROWID, pehz.*
1412: FROM IGS_PE_HZ_PARTIES pehz
1413: WHERE party_id = cp_person_id;
1414:

Line 1412: FROM IGS_PE_HZ_PARTIES pehz

1408: lv_perosn_profile_id hz_person_profiles.person_profile_id%TYPE;
1409:
1410: CURSOR pehz_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1411: SELECT pehz.ROWID, pehz.*
1412: FROM IGS_PE_HZ_PARTIES pehz
1413: WHERE party_id = cp_person_id;
1414:
1415: tlinfo2 pehz_cur%ROWTYPE;
1416:

Line 1417: CURSOR c_pe_stat (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

1413: WHERE party_id = cp_person_id;
1414:
1415: tlinfo2 pehz_cur%ROWTYPE;
1416:
1417: CURSOR c_pe_stat (cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
1418: SELECT
1419: p.rowid row_id,
1420: pp.person_profile_id,
1421: p.party_id person_id,

Line 1500: hz_parties p

1496: sd.birth_cntry_resn_code
1497: FROM
1498: hz_person_profiles pp,
1499: igs_pe_stat_details sd,
1500: hz_parties p
1501: WHERE
1502: sd.person_id(+) = p.party_id AND
1503: pp.party_id = p.party_id AND
1504: SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date, SYSDATE) AND

Line 1613: x_hz_parties_ovn => cv_pe_stat.object_version_number,

1609: x_primary_contact_id => cv_pe_stat.primary_contact_id,
1610: x_personal_income => cv_pe_stat.personal_income,
1611: x_head_of_household_flag => cv_pe_stat.head_of_household_flag,
1612: x_content_source_number => cv_pe_stat.content_source_number,
1613: x_hz_parties_ovn => cv_pe_stat.object_version_number,
1614: x_attribute_category => cv_pe_stat.attribute_category,
1615: x_attribute1 => cv_pe_stat.attribute1,
1616: x_attribute2 => cv_pe_stat.attribute2,
1617: x_attribute3 => cv_pe_stat.attribute3,

Line 1682: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(

1678: FETCH pehz_cur INTO tlinfo2;
1679:
1680: -- PRBHARDW replaced update_row with add_row as part of BUG 5248350
1681:
1682: IGS_PE_HZ_PARTIES_PKG.ADD_ROW(
1683: X_ROWID => tlinfo2.ROWID,
1684: X_PARTY_ID => P_PERSON_ID,
1685: X_DECEASED_IND => tlinfo2.deceased_ind,
1686: X_ARCHIVE_EXCLUSION_IND => tlinfo2.archive_exclusion_ind,

Line 2174: P_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,

2170: P_BIRTHDATE IN DATE,
2171: P_PRE_NAME_ADJUNCT IN VARCHAR2,
2172: P_SUFFIX IN VARCHAR2,
2173: P_TITLE IN VARCHAR2,
2174: P_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,
2175: P_HZ_REL_OVN IN OUT NOCOPY NUMBER,
2176: P_JOINT_MAILING IN VARCHAR2,
2177: P_NEXT_OF_KIN IN VARCHAR2,
2178: P_EMERGENCY_CONTACT IN VARCHAR2,

Line 2193: FROM hz_parties hp, hz_relationships hr

2189: P_COPY_PRIMARY_ADDR IN VARCHAR2
2190: ) IS
2191: CURSOR c_existing_rel(cp_first_name VARCHAR2, cp_last_name VARCHAR2,cp_subject_id NUMBER,cp_rel_code VARCHAR2)IS
2192: SELECT hr.object_id, hr.relationship_id
2193: FROM hz_parties hp, hz_relationships hr
2194: WHERE UPPER(hp.person_first_name) = UPPER(cp_first_name)
2195: AND UPPER(hp.person_last_name) = UPPER(cp_last_name)
2196: AND hp.party_id = hr.object_id
2197: AND hr.subject_id = cp_subject_id

Line 2264: hz_parties p,

2260: p.status,
2261: pd.felony_convicted_flag,
2262: p.last_update_date
2263: FROM
2264: hz_parties p,
2265: igs_pe_hz_parties pd,
2266: hz_person_profiles pp
2267: WHERE p.party_id = cp_object_id
2268: AND p.party_id = pd.party_id (+)

Line 2265: igs_pe_hz_parties pd,

2261: pd.felony_convicted_flag,
2262: p.last_update_date
2263: FROM
2264: hz_parties p,
2265: igs_pe_hz_parties pd,
2266: hz_person_profiles pp
2267: WHERE p.party_id = cp_object_id
2268: AND p.party_id = pd.party_id (+)
2269: AND p.party_id = pp.party_id

Line 2362: FROM hz_parties

2358: WHERE hps.party_site_id = cp_party_site_id;
2359:
2360: CURSOR c_subject_party_name (cp_subject_id NUMBER) IS
2361: SELECT party_name
2362: FROM hz_parties
2363: WHERE party_id = cp_subject_id;
2364:
2365: rec_site_detail c_site_detail%ROWTYPE;
2366: rec_relationship c_relationship%ROWTYPE;

Line 2403: L_SUB_PARTY_NAME hz_parties.party_name%TYPE;

2399: l_site_last_update_date DATE;
2400: l_profile_last_update_date DATE;
2401: l_object_version_number NUMBER;
2402: l_loc_exists BOOLEAN;
2403: L_SUB_PARTY_NAME hz_parties.party_name%TYPE;
2404:
2405: err_msg_data varchar2(200);
2406:
2407: CURSOR IS_HR_PERSON(CP_PARTY_ID NUMBER) IS

Line 2465: X_HZ_PARTIES_OVN => P_HZ_PARTIES_OVN,

2461: X_EMAIL_ADDR => NULL,
2462: X_LEVEL_OF_QUAL_ID => NULL,
2463: X_MILITARY_SERVICE_REG => NULL,
2464: X_VETERAN => NULL,
2465: X_HZ_PARTIES_OVN => P_HZ_PARTIES_OVN,
2466: X_ATTRIBUTE_CATEGORY => NULL,
2467: X_ATTRIBUTE1 => NULL,
2468: X_ATTRIBUTE2 => NULL,
2469: X_ATTRIBUTE3 => NULL,

Line 2509: P_HZ_OVN => P_HZ_PARTIES_OVN,

2505: P_BIRTH_CITY => NULL,
2506: P_BIRTH_COUNTRY => NULL,
2507: P_VETERAN => NULL,
2508: P_RELIGION_CD => NULL,
2509: P_HZ_OVN => P_HZ_PARTIES_OVN,
2510: P_RETURN_STATUS => l_return_status,
2511: P_MSG_COUNT => P_MSG_COUNT,
2512: P_MSG_DATA => l_msg_data,
2513: P_CALLER => 'RELATIONSHIP_SS'

Line 2672: p_hz_parties_ovn := l_person.object_version_number;

2668: OPEN c_person(p_object_id);
2669: FETCH c_person INTO l_person;
2670: CLOSE c_person;
2671:
2672: p_hz_parties_ovn := l_person.object_version_number;
2673:
2674: IF (P_MODE = 'INSERT') THEN
2675: OPEN IS_HR_PERSON(p_object_id);
2676: FETCH IS_HR_PERSON INTO L_FOUND;

Line 2712: X_HZ_PARTIES_OVN => P_HZ_PARTIES_OVN,

2708: X_EMAIL_ADDR => l_person.EMAIL_ADDR,
2709: X_LEVEL_OF_QUAL_ID => l_person.LEVEL_OF_QUAL_ID,
2710: X_MILITARY_SERVICE_REG => l_person.MILITARY_SERVICE_REG,
2711: X_VETERAN => l_person.VETERAN,
2712: X_HZ_PARTIES_OVN => P_HZ_PARTIES_OVN,
2713: X_ATTRIBUTE_CATEGORY => l_person.ATTRIBUTE_CATEGORY,
2714: X_ATTRIBUTE1 => l_person.ATTRIBUTE1,
2715: X_ATTRIBUTE2 => l_person.ATTRIBUTE2,
2716: X_ATTRIBUTE3 => l_person.ATTRIBUTE3,

Line 2755: P_HZ_OVN => P_HZ_PARTIES_OVN,

2751: P_BIRTH_CITY => NULL,
2752: P_BIRTH_COUNTRY => NULL,
2753: P_VETERAN => NULL,
2754: P_RELIGION_CD => NULL,
2755: P_HZ_OVN => P_HZ_PARTIES_OVN,
2756: P_RETURN_STATUS => l_return_status,
2757: P_MSG_COUNT => P_MSG_COUNT,
2758: P_MSG_DATA => p_msg_data,
2759: P_CALLER => 'RELATIONSHIP_SS'