APPS.IGS_PE_VISA_PKG dependencies on IGS_PE_PASSPORT

Line 144: CURSOR get_pass_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE)

140: || Who When What
141: || pkpatel 13-Jun-2005 Added the validations for DOB, Dates and the POE Overlap
142: || (reverse chronological order - newest change first)
143: */
144: CURSOR get_pass_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE)
145: IS
146: SELECT passport_expiry_date
147: FROM IGS_PE_PASSPORT
148: WHERE passport_id = p_passport_id;

Line 147: FROM IGS_PE_PASSPORT

143: */
144: CURSOR get_pass_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE)
145: IS
146: SELECT passport_expiry_date
147: FROM IGS_PE_PASSPORT
148: WHERE passport_id = p_passport_id;
149:
150: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
151: IS

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

146: SELECT passport_expiry_date
147: FROM IGS_PE_PASSPORT
148: WHERE passport_id = p_passport_id;
149:
150: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
151: IS
152: SELECT birth_date
153: FROM igs_pe_person_base_v
154: WHERE person_id = cp_person_id;

Line 165: l_exp_date igs_pe_passport.passport_expiry_date%TYPE;

161: WHERE visa_id = cp_visa_id AND
162: (visit_start_date < cp_issue_date OR visit_end_date > cp_expiry_date+30);
163:
164: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
165: l_exp_date igs_pe_passport.passport_expiry_date%TYPE;
166: l_count NUMBER(1);
167:
168: BEGIN
169: IF p_inserting or p_updating THEN

Line 264: ELSIF NOT igs_pe_passport_pkg.get_pk_for_validation (

260:
261: IF (((old_references.passport_id = new_references.passport_id)) OR
262: ((new_references.passport_id IS NULL))) THEN
263: NULL;
264: ELSIF NOT igs_pe_passport_pkg.get_pk_for_validation (
265: new_references.passport_id
266: ) THEN
267: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
268: igs_ge_msg_stack.add;

Line 379: PROCEDURE get_fk_igs_pe_passport (

375:
376: END get_uk_for_validation ;
377:
378:
379: PROCEDURE get_fk_igs_pe_passport (
380: x_passport_id IN NUMBER
381: ) AS
382: /*
383: || Created By : [email protected]

Line 411: END get_fk_igs_pe_passport;

407: RETURN;
408: END IF;
409: CLOSE cur_rowid;
410:
411: END get_fk_igs_pe_passport;
412:
413:
414: PROCEDURE before_dml (
415: p_action IN VARCHAR2,