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_AD_IMP_008 dependencies on IGS_PE_PERSON

Line 111: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed

107: || Who When What
108: || skpandey 21-SEP-2005 Bug: 3663505
109: || Description: Added ATTRIBUTES 21 TO 24 TO STORE ADDITIONAL INFORMATION
110: || pkpatel 15-APR-2002 Bug no.1834307 : Modified the Relationship_Type_C cursor to validate both Relationship_code and relationship_type
111: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed
112: || asbala 15-APR-2004 3349171: Incorrect usage of fnd_lookup_values view
113: || (reverse chronological order - newest change first)
114: */
115:

Line 156: l_person_id igs_pe_person.person_id%TYPE;

152: l_msg_count NUMBER ;
153: l_last_update_date DATE;
154: l_msg_data VARCHAR2(2000);
155: l_party_id NUMBER;
156: l_person_id igs_pe_person.person_id%TYPE;
157: l_party_number igs_pe_person.person_number%TYPE;
158: l_person_number igs_pe_person.person_number%TYPE;
159: l_profile_id NUMBER;
160: x_rowid VARCHAR2(25);

Line 157: l_party_number igs_pe_person.person_number%TYPE;

153: l_last_update_date DATE;
154: l_msg_data VARCHAR2(2000);
155: l_party_id NUMBER;
156: l_person_id igs_pe_person.person_id%TYPE;
157: l_party_number igs_pe_person.person_number%TYPE;
158: l_person_number igs_pe_person.person_number%TYPE;
159: l_profile_id NUMBER;
160: x_rowid VARCHAR2(25);
161: l_rowid VARCHAR2(25);

Line 158: l_person_number igs_pe_person.person_number%TYPE;

154: l_msg_data VARCHAR2(2000);
155: l_party_id NUMBER;
156: l_person_id igs_pe_person.person_id%TYPE;
157: l_party_number igs_pe_person.person_number%TYPE;
158: l_person_number igs_pe_person.person_number%TYPE;
159: l_profile_id NUMBER;
160: x_rowid VARCHAR2(25);
161: l_rowid VARCHAR2(25);
162: l_party_relationship_id NUMBER;

Line 324: IGS_PE_PERSON_PKG.INSERT_ROW(

320: P_REL_DUP_REC => p_rel_dup_rec,
321: P_MATCH_FOUND => p_match_found
322: );
323: IF p_match_found = 'N' THEN
324: IGS_PE_PERSON_PKG.INSERT_ROW(
325: X_MSG_COUNT => l_msg_count,
326: X_MSG_DATA => l_msg_data,
327: X_RETURN_STATUS => l_return_status,
328: X_ROWID => l_rowid,

Line 811: IGS_PE_PERSON_ADDR_PKG.UPDATE_ROW(

807: -- cursor to fetch l_last_update_date from hz_locations for a given location_id
808: l_location_ovn := addr_rec.location_ovn;
809: l_party_site_ovn := addr_rec.party_site_ovn;
810:
811: IGS_PE_PERSON_ADDR_PKG.UPDATE_ROW(
812: p_action => NULL,
813: p_rowid => l_row_id,
814: p_location_id => l_location_id ,
815: p_start_dt => nvl(reladdr_rec.start_dt,addr_rec.start_dt) ,

Line 1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1047: SELECT territory_short_name
1048: FROM fnd_territories_vl
1049: WHERE territory_code = p_territory_code;
1050:
1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1052: SELECT birth_date
1053: FROM igs_pe_person_base_v
1054: WHERE person_id = cp_person_id;
1055:

Line 1053: FROM igs_pe_person_base_v

1049: WHERE territory_code = p_territory_code;
1050:
1051: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1052: SELECT birth_date
1053: FROM igs_pe_person_base_v
1054: WHERE person_id = cp_person_id;
1055:
1056: l_Status igs_ad_relations_int.status%TYPE;
1057: l_Error_Code igs_ad_relations_int.error_code%TYPE;

Line 1357: IGS_PE_PERSON_ADDR_PKG.INSERT_ROW (

1353: l_flag_check_status VARCHAR2(1) := 'Y';
1354: l_addr_warning VARCHAR2(1) := 'N';
1355: BEGIN
1356: --Create the person address.
1357: IGS_PE_PERSON_ADDR_PKG.INSERT_ROW (
1358: p_action => NULL,
1359: p_rowid => l_row_id,
1360: p_location_id => l_location_id,
1361: p_start_dt => reladdr_rec.start_dt,

Line 2455: FROM igs_pe_person_base_v

2451:
2452: CURSOR birth_date_cur(cp_person_id hz_parties.party_id%TYPE)
2453: IS
2454: SELECT birth_date
2455: FROM igs_pe_person_base_v
2456: WHERE person_id = cp_person_id;
2457:
2458:
2459: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;

Line 3374: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

3370: WHERE party_type = 'ORGANIZATION' AND
3371: party_number = cp_employer_party_number AND
3372: status <> 'M';
3373:
3374: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3375: SELECT birth_date
3376: FROM igs_pe_person_base_v
3377: WHERE person_id = cp_person_id;
3378:

Line 3376: FROM igs_pe_person_base_v

3372: status <> 'M';
3373:
3374: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
3375: SELECT birth_date
3376: FROM igs_pe_person_base_v
3377: WHERE person_id = cp_person_id;
3378:
3379: lv_var VARCHAR2(1);
3380: l_count NUMBER(3);

Line 4026: CURSOR c_mar_eff_dt(p_person_id igs_pe_person.person_id%TYPE) IS

4022: -- date of birth, bug 2421786
4023:
4024: IF p_per_stat.MARITAL_STATUS_EFFECTIVE_DATE IS NOT NULL THEN
4025: DECLARE
4026: CURSOR c_mar_eff_dt(p_person_id igs_pe_person.person_id%TYPE) IS
4027: SELECT BIRTH_DATE
4028: FROM IGS_PE_PERSON_BASE_V WHERE PERSON_ID =p_person_id;
4029:
4030: BEGIN

Line 4028: FROM IGS_PE_PERSON_BASE_V WHERE PERSON_ID =p_person_id;

4024: IF p_per_stat.MARITAL_STATUS_EFFECTIVE_DATE IS NOT NULL THEN
4025: DECLARE
4026: CURSOR c_mar_eff_dt(p_person_id igs_pe_person.person_id%TYPE) IS
4027: SELECT BIRTH_DATE
4028: FROM IGS_PE_PERSON_BASE_V WHERE PERSON_ID =p_person_id;
4029:
4030: BEGIN
4031: OPEN c_mar_eff_dt(p_per_stat.pid);
4032: FETCH c_mar_eff_dt INTO l_birth_date;

Line 5283: FROM igs_pe_person_base_v

5279:
5280: -- Validate date of birth
5281: CURSOR birth_date_cur(cp_person_id NUMBER) IS
5282: SELECT birth_date
5283: FROM igs_pe_person_base_v
5284: WHERE person_id = cp_person_id;
5285:
5286: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
5287: l_error VARCHAR2(30);

Line 5286: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

5282: SELECT birth_date
5283: FROM igs_pe_person_base_v
5284: WHERE person_id = cp_person_id;
5285:
5286: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
5287: l_error VARCHAR2(30);
5288: BEGIN
5289: -- Call Log header
5290: