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_HZ_REL_PKG dependencies on IGS_PE_HZ_REL

Line 1: PACKAGE BODY igs_pe_hz_rel_pkg AS

1: PACKAGE BODY igs_pe_hz_rel_pkg AS
2: /* $Header: IGSNIB1B.pls 120.2 2005/07/08 01:28:18 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_rel%ROWTYPE;

Line 5: old_references igs_pe_hz_rel%ROWTYPE;

1: PACKAGE BODY igs_pe_hz_rel_pkg AS
2: /* $Header: IGSNIB1B.pls 120.2 2005/07/08 01:28:18 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_rel%ROWTYPE;
6: new_references igs_pe_hz_rel%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_hz_rel%ROWTYPE;

2: /* $Header: IGSNIB1B.pls 120.2 2005/07/08 01:28:18 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_rel%ROWTYPE;
6: new_references igs_pe_hz_rel%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 40: FROM igs_pe_hz_rel

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM igs_pe_hz_rel
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 109: FROM igs_pe_hz_rel a , hz_relationships d

105: -- cursor to get the surname, prefix, given_names of member
106: --
107: CURSOR check_update IS
108: SELECT d.subject_id
109: FROM igs_pe_hz_rel a , hz_relationships d
110: WHERE a.rowid = p_rowid
111: AND (NVL(a.primary,'N') = 'Y' OR NVL(a.secondary,'N') = 'Y')
112: AND d.relationship_id = a.relationship_id
113: AND a.directional_flag = d.directional_flag;

Line 121: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c

117: SELECT a.rowid,
118: b.person_last_name surname,
119: b.person_first_name given_names,
120: b.person_pre_name_adjunct prefix
121: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c
122: WHERE a.relationship_id = c.relationship_id
123: AND c.subject_id = p_person_id
124: AND c.object_id = b.party_id
125: AND c.directional_flag = a.directional_flag

Line 134: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c

130: SELECT a.rowid,
131: b.person_last_name surname,
132: b.person_first_name given_names,
133: b.person_pre_name_adjunct prefix
134: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c
135: WHERE a.relationship_id = c.relationship_id
136: AND c.subject_id = p_person_id
137: AND c.object_id = b.party_id
138: AND c.directional_flag = a.directional_flag

Line 186: UPDATE igs_pe_hz_rel

182: CLOSE c_prefix_desc;
183: END IF;
184: CLOSE c_member_detail2;
185:
186: UPDATE igs_pe_hz_rel
187: SET
188: joint_salutation = new_references.joint_salutation
189: WHERE rowid =rec_sec_member_detail.rowid;
190:

Line 206: UPDATE igs_pe_hz_rel

202: CLOSE c_prefix_desc;
203: END IF;
204: CLOSE c_member_detail1;
205:
206: UPDATE igs_pe_hz_rel
207: SET
208: joint_salutation = new_references.joint_salutation
209: WHERE rowid = rec_prime_member_detail.rowid;
210:

Line 221: UPDATE igs_pe_hz_rel

217:
218: /* Set the joint salutation to null if the member is changed from not being a primary or secondary */
219: IF ( NVL(new_references.primary,'N') = 'N' and (NVL(new_references.primary,'N') <> NVL(old_references.primary,'N')) ) OR
220: ( NVL(new_references.secondary,'N') = 'N' and (NVL(new_references.secondary,'N') <> NVL(old_references.secondary,'N')) ) THEN
221: UPDATE igs_pe_hz_rel
222: SET joint_salutation = NULL
223: WHERE rowid = p_rowid;
224:
225: END IF;

Line 307: UPDATE igs_pe_hz_rel

303: rec_sec_member_detail.given_names||' '||rec_sec_member_detail.surname;
304: END IF;
305: END IF;
306:
307: UPDATE igs_pe_hz_rel
308: SET
309: joint_salutation = trim(lv_joint_salutation)
310: WHERE rowid in (rec_prime_member_detail.rowid,rec_sec_member_detail.rowid);
311:

Line 388: FROM igs_pe_hz_rel

384: || (reverse chronological order - newest change first)
385: */
386: CURSOR cur_rowid IS
387: SELECT rowid
388: FROM igs_pe_hz_rel
389: WHERE relationship_id = x_relationship_id
390: AND directional_flag = x_directional_flag
391: FOR UPDATE NOWAIT;
392:

Line 564: l_directional_flag igs_pe_hz_rel.directional_flag%TYPE;

560:
561: x_last_update_date DATE;
562: x_last_updated_by NUMBER;
563: x_last_update_login NUMBER;
564: l_directional_flag igs_pe_hz_rel.directional_flag%TYPE;
565:
566: BEGIN
567:
568: x_last_update_date := SYSDATE;

Line 583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');

579: x_last_update_login := -1;
580: END IF;
581: ELSE
582: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:

Line 612: INSERT INTO igs_pe_hz_rel (

608:
609: IF (x_mode = 'S') THEN
610: igs_sc_gen_001.set_ctx('R');
611: END IF;
612: INSERT INTO igs_pe_hz_rel (
613: relationship_id,
614: directional_flag,
615: primary,
616: secondary,

Line 658: INSERT INTO igs_pe_hz_rel (

654: ELSIF new_references.directional_flag = 'B' THEN
655: l_directional_flag := 'F';
656: END IF;
657:
658: INSERT INTO igs_pe_hz_rel (
659: relationship_id,
660: directional_flag,
661: primary,
662: secondary,

Line 746: FROM igs_pe_hz_rel

742: rep_staff,
743: rep_student,
744: rep_alumni,
745: emergency_contact_flag
746: FROM igs_pe_hz_rel
747: WHERE rowid = x_rowid
748: FOR UPDATE NOWAIT;
749:
750: tlinfo c1%ROWTYPE;

Line 833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');

829: x_last_update_login := -1;
830: END IF;
831: ELSE
832: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836: END IF;
837:

Line 865: UPDATE igs_pe_hz_rel

861: igs_sc_gen_001.set_ctx('R');
862: END IF;
863: --if the passed emergency contact flag is not null then update the database value. Else don't update emergency Contact value.
864: IF new_references.emergency_contact_flag is NOT NULL THEN
865: UPDATE igs_pe_hz_rel
866: SET
867: primary = new_references.primary,
868: secondary = new_references.secondary,
869: joint_salutation = new_references.joint_salutation,

Line 881: UPDATE igs_pe_hz_rel

877: last_updated_by = x_last_updated_by,
878: last_update_login = x_last_update_login
879: WHERE rowid = x_rowid;
880: ELSE
881: UPDATE igs_pe_hz_rel
882: SET
883: primary = new_references.primary,
884: secondary = new_references.secondary,
885: joint_salutation = new_references.joint_salutation,

Line 953: FROM igs_pe_hz_rel

949: || (reverse chronological order - newest change first)
950: */
951: CURSOR c1 IS
952: SELECT rowid
953: FROM igs_pe_hz_rel
954: WHERE relationship_id = x_relationship_id
955: AND directional_flag = x_directional_flag;
956:
957: BEGIN

Line 1025: DELETE FROM igs_pe_hz_rel

1021:
1022: IF (x_mode = 'S') THEN
1023: igs_sc_gen_001.set_ctx('R');
1024: END IF;
1025: DELETE FROM igs_pe_hz_rel
1026: WHERE rowid = x_rowid;
1027:
1028: IF (SQL%NOTFOUND) THEN
1029: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1042: END igs_pe_hz_rel_pkg;

1038:
1039: END delete_row;
1040:
1041:
1042: END igs_pe_hz_rel_pkg;