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_ALT_PERS_ID_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 1: package body IGS_PE_ALT_PERS_ID_PKG as

1: package body IGS_PE_ALT_PERS_ID_PKG as
2: /* $Header: IGSNI02B.pls 120.4 2005/10/17 02:23:06 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 21: old_references IGS_PE_ALT_PERS_ID%RowType;

17: --skpandey 01-AUG-2005 Bug No:4327807
18: -- Added an additional condition for p_action='DELETE' to accomodate Business logic
19: -------------------------------------------------------------------------------------------
20: l_rowid VARCHAR2(25);
21: old_references IGS_PE_ALT_PERS_ID%RowType;
22: new_references IGS_PE_ALT_PERS_ID%RowType;
23: PROCEDURE Set_Column_Values (
24: p_action IN VARCHAR2,
25: x_rowid IN VARCHAR2,

Line 22: new_references IGS_PE_ALT_PERS_ID%RowType;

18: -- Added an additional condition for p_action='DELETE' to accomodate Business logic
19: -------------------------------------------------------------------------------------------
20: l_rowid VARCHAR2(25);
21: old_references IGS_PE_ALT_PERS_ID%RowType;
22: new_references IGS_PE_ALT_PERS_ID%RowType;
23: PROCEDURE Set_Column_Values (
24: p_action IN VARCHAR2,
25: x_rowid IN VARCHAR2,
26: x_pe_person_id IN NUMBER,

Line 62: FROM IGS_PE_ALT_PERS_ID

58: x_region_cd IN VARCHAR2
59: ) as
60: CURSOR cur_old_ref_values IS
61: SELECT *
62: FROM IGS_PE_ALT_PERS_ID
63: WHERE rowid = x_rowid;
64: BEGIN
65: l_rowid := x_rowid;
66: -- Code for setting the Old and New Reference Values.

Line 140: -- Removed the call to igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_ALT_PERS_ID') and

136: --
137: --Change History:
138: --Who When What
139: --pkpatel 8-JUN-2002 Bug No: 2402077
140: -- Removed the call to igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_ALT_PERS_ID') and
141: -- all unnecessary check so that the date validation procedures can be called properly.
142: --askapoor 31-JAN-2005 Bug No: 3882788
143: -- Removed end_dt < sysdate and added check start_dt = end_dt
144: --pkpatel 16-JUL-2005 Bug 4327807 (Person SS Enhancement)

Line 349: FROM igs_pe_alt_pers_id alt, hz_parties hz

345: closed_ind = 'N';
346:
347: CURSOR cptu IS
348: SELECT hz.party_number
349: FROM igs_pe_alt_pers_id alt, hz_parties hz
350: WHERE alt.person_id_type = new_references.person_id_type
351: AND alt.api_person_id = new_references.api_person_id
352: AND alt.pe_person_id <> new_references.pe_person_id
353: AND (alt.start_dt <> alt.end_dt OR alt.end_dt IS NULL)

Line 460: FROM IGS_PE_ALT_PERS_ID

456: --kpadiyar 27-JAN-2003 Bug 2726415 - Added start_dt as part of the pk
457: ----------------------------------------------------------------------------------------------
458: CURSOR cur_rowid IS
459: SELECT rowid
460: FROM IGS_PE_ALT_PERS_ID
461: WHERE pe_person_id = x_pe_person_id
462: AND api_person_id = x_api_person_id
463: AND person_id_type = x_person_id_type
464: AND trunc(start_dt) = trunc(x_start_dt)

Line 484: FROM IGS_PE_ALT_PERS_ID

480: x_person_id IN VARCHAR2
481: ) as
482: CURSOR cur_rowid IS
483: SELECT rowid
484: FROM IGS_PE_ALT_PERS_ID
485: WHERE pe_person_id = x_person_id ;
486: lv_rowid cur_rowid%RowType;
487: BEGIN
488: Open cur_rowid;

Line 708: cursor C is select ROWID from IGS_PE_ALT_PERS_ID

704: x_attribute20 IN VARCHAR2,
705: x_region_cd IN VARCHAR2,
706: X_MODE IN VARCHAR2
707: ) as
708: cursor C is select ROWID from IGS_PE_ALT_PERS_ID
709: where PE_PERSON_ID = X_PE_PERSON_ID
710: and API_PERSON_ID = X_API_PERSON_ID
711: and PERSON_ID_TYPE = X_PERSON_ID_TYPE
712: and start_dt = x_start_dt;

Line 790: insert into IGS_PE_ALT_PERS_ID (

786: );
787: IF (x_mode = 'S') THEN
788: igs_sc_gen_001.set_ctx('R');
789: END IF;
790: insert into IGS_PE_ALT_PERS_ID (
791: PE_PERSON_ID,
792: API_PERSON_ID,
793: API_PERSON_ID_UF,
794: PERSON_ID_TYPE,

Line 955: from IGS_PE_ALT_PERS_ID

951: ATTRIBUTE18 ,
952: ATTRIBUTE19 ,
953: ATTRIBUTE20 ,
954: REGION_CD
955: from IGS_PE_ALT_PERS_ID
956: where ROWID = X_ROWID
957: for update nowait;
958: tlinfo c1%rowtype;
959: begin

Line 1122: update IGS_PE_ALT_PERS_ID set

1118: end if;
1119: IF (x_mode = 'S') THEN
1120: igs_sc_gen_001.set_ctx('R');
1121: END IF;
1122: update IGS_PE_ALT_PERS_ID set
1123: API_PERSON_ID_UF = NEW_REFERENCES.API_PERSON_ID_UF,
1124: START_DT = NEW_REFERENCES.START_DT,
1125: END_DT = NEW_REFERENCES.END_DT,
1126: ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,

Line 1218: cursor c1 is select rowid from IGS_PE_ALT_PERS_ID

1214: x_attribute20 IN VARCHAR2,
1215: x_region_cd IN VARCHAR2,
1216: X_MODE in VARCHAR2
1217: ) as
1218: cursor c1 is select rowid from IGS_PE_ALT_PERS_ID
1219: where PE_PERSON_ID = X_PE_PERSON_ID
1220: and API_PERSON_ID = X_API_PERSON_ID
1221: and PERSON_ID_TYPE = X_PERSON_ID_TYPE
1222: and start_dt = x_start_dt

Line 1307: delete from IGS_PE_ALT_PERS_ID

1303: );
1304: IF (x_mode = 'S') THEN
1305: igs_sc_gen_001.set_ctx('R');
1306: END IF;
1307: delete from IGS_PE_ALT_PERS_ID
1308: where ROWID = X_ROWID;
1309: if (sql%notfound) then
1310: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1311: igs_ge_msg_stack.add;

Line 1324: end IGS_PE_ALT_PERS_ID_PKG;

1320: p_action => 'DELETE',
1321: x_rowid => X_ROWID
1322: );
1323: end DELETE_ROW;
1324: end IGS_PE_ALT_PERS_ID_PKG;