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_PASSPORT_PKG dependencies on IGS_PE_PASSPORT

Line 1: PACKAGE BODY igs_pe_passport_pkg AS

1: PACKAGE BODY igs_pe_passport_pkg AS
2: /* $Header: IGSNI39B.pls 120.2 2005/10/17 02:20:09 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_passport%ROWTYPE;

Line 5: old_references igs_pe_passport%ROWTYPE;

1: PACKAGE BODY igs_pe_passport_pkg AS
2: /* $Header: IGSNI39B.pls 120.2 2005/10/17 02:20:09 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_passport%ROWTYPE;
6: new_references igs_pe_passport%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_passport%ROWTYPE;

2: /* $Header: IGSNI39B.pls 120.2 2005/10/17 02:20:09 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_passport%ROWTYPE;
6: new_references igs_pe_passport%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 55: FROM igs_pe_passport

51: */
52:
53: CURSOR cur_old_ref_values IS
54: SELECT *
55: FROM igs_pe_passport
56: WHERE rowid = x_rowid;
57:
58: BEGIN
59:

Line 128: CURSOR get_count_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE,

124: || Change History :
125: || Who When What
126: || (reverse chronological order - newest change first)
127: */
128: CURSOR get_count_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE,
129: p_passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE)
130: IS
131: SELECT visa_issue_date
132: FROM IGS_PE_VISA vis

Line 129: p_passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE)

125: || Who When What
126: || (reverse chronological order - newest change first)
127: */
128: CURSOR get_count_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE,
129: p_passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE)
130: IS
131: SELECT visa_issue_date
132: FROM IGS_PE_VISA vis
133: WHERE passport_id = p_passport_id

Line 162: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)

158: || Change History :
159: || Who When What
160: || (reverse chronological order - newest change first)
161: */
162: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
163: IS
164: SELECT birth_date
165: FROM igs_pe_person_base_v
166: WHERE person_id = cp_person_id;

Line 203: fnd_message.set_name ('IGS', 'IGS_PE_PASSPORT_DUP_EXISTS');

199: new_references.passport_cntry_code,
200: new_references.passport_number
201: )
202: ) THEN
203: fnd_message.set_name ('IGS', 'IGS_PE_PASSPORT_DUP_EXISTS');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:

Line 223: igs_pe_visa_pkg.get_fk_igs_pe_passport (

219: || (reverse chronological order - newest change first)
220: */
221: BEGIN
222:
223: igs_pe_visa_pkg.get_fk_igs_pe_passport (
224: old_references.passport_id
225: );
226:
227: END check_child_existance;

Line 271: FROM igs_pe_passport

267: || (reverse chronological order - newest change first)
268: */
269: CURSOR cur_rowid IS
270: SELECT rowid
271: FROM igs_pe_passport
272: WHERE passport_id = x_passport_id
273: FOR UPDATE NOWAIT;
274:
275: lv_rowid cur_rowid%RowType;

Line 308: FROM igs_pe_passport

304: || (reverse chronological order - newest change first)
305: */
306: CURSOR cur_rowid IS
307: SELECT rowid
308: FROM igs_pe_passport
309: WHERE person_id = x_person_id
310: AND passport_cntry_code = x_passport_cntry_code
311: AND passport_number = x_passport_number
312: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 560: INSERT INTO igs_pe_passport (

556:
557: IF (x_mode = 'S') THEN
558: igs_sc_gen_001.set_ctx('R');
559: END IF;
560: INSERT INTO igs_pe_passport (
561: passport_id,
562: person_id,
563: passport_number,
564: passport_expiry_date,

Line 593: igs_pe_passport_s.NEXTVAL,

589: last_update_date,
590: last_updated_by,
591: last_update_login
592: ) VALUES (
593: igs_pe_passport_s.NEXTVAL,
594: new_references.person_id,
595: new_references.passport_number,
596: new_references.passport_expiry_date,
597: new_references.passport_cntry_code,

Line 711: FROM igs_pe_passport

707: attribute17,
708: attribute18,
709: attribute19,
710: attribute20
711: FROM igs_pe_passport
712: WHERE rowid = x_rowid
713: FOR UPDATE NOWAIT;
714:
715: tlinfo c1%ROWTYPE;

Line 872: UPDATE igs_pe_passport

868:
869: IF (x_mode = 'S') THEN
870: igs_sc_gen_001.set_ctx('R');
871: END IF;
872: UPDATE igs_pe_passport
873: SET
874: person_id = new_references.person_id,
875: passport_number = new_references.passport_number,
876: passport_expiry_date = new_references.passport_expiry_date,

Line 971: FROM igs_pe_passport

967: || (reverse chronological order - newest change first)
968: */
969: CURSOR c1 IS
970: SELECT rowid
971: FROM igs_pe_passport
972: WHERE passport_id = x_passport_id;
973:
974: BEGIN
975:

Line 1072: DELETE FROM igs_pe_passport

1068:
1069: IF (x_mode = 'S') THEN
1070: igs_sc_gen_001.set_ctx('R');
1071: END IF;
1072: DELETE FROM igs_pe_passport
1073: WHERE rowid = x_rowid;
1074:
1075: IF (SQL%NOTFOUND) THEN
1076: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1089: END igs_pe_passport_pkg;

1085:
1086: END delete_row;
1087:
1088:
1089: END igs_pe_passport_pkg;