APPS.IGS_PE_NONIMG_STAT_PKG dependencies on IGS_PE_NONIMG_FORM

Line 93: kumma 08-JAN-2003 2739579, Added a parameter of visa_type to igs_pe_nonimg_form_pkg.update_row

89: Purpose :
90: Know limitations, enhancements or remarks
91: Change History
92: Who When What
93: kumma 08-JAN-2003 2739579, Added a parameter of visa_type to igs_pe_nonimg_form_pkg.update_row
94: (reverse chronological order - newest change first)
95: ***************************************************************/
96:
97: BEGIN

Line 109: CURSOR c_get_form_values ( cp_nonimg_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE ) IS

105: AND typ.person_type_code = per_typ.person_type_code
106: AND typ.end_date IS NULL ;
107:
108:
109: CURSOR c_get_form_values ( cp_nonimg_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE ) IS
110: SELECT form.rowid,form.*
111: FROM igs_pe_nonimg_form form
112: WHERE form.nonimg_form_id = cp_nonimg_form_id ;
113:

Line 111: FROM igs_pe_nonimg_form form

107:
108:
109: CURSOR c_get_form_values ( cp_nonimg_form_id igs_pe_nonimg_form.nonimg_form_id%TYPE ) IS
110: SELECT form.rowid,form.*
111: FROM igs_pe_nonimg_form form
112: WHERE form.nonimg_form_id = cp_nonimg_form_id ;
113:
114: l_form c_get_form_values%ROWTYPE;
115: l_form_status igs_pe_nonimg_form.form_status%TYPE;

Line 115: l_form_status igs_pe_nonimg_form.form_status%TYPE;

111: FROM igs_pe_nonimg_form form
112: WHERE form.nonimg_form_id = cp_nonimg_form_id ;
113:
114: l_form c_get_form_values%ROWTYPE;
115: l_form_status igs_pe_nonimg_form.form_status%TYPE;
116: l_end_date DATE;
117: l_end_method igs_pe_typ_instances_all.end_method%TYPE;
118: lv_userid NUMBER;
119: l_person_type person_type%ROWTYPE;

Line 135: igs_pe_nonimg_form_pkg.update_row (

131: l_form_status := 'T';
132: ELSIF new_references.action_type = 'CP' THEN
133: l_form_status := 'E';
134: END IF;
135: igs_pe_nonimg_form_pkg.update_row (
136: x_rowid => l_form.rowid ,
137: x_nonimg_form_id => l_form.nonimg_form_id ,
138: x_person_id => l_form.person_id ,
139: x_print_form => l_form.print_form ,

Line 254: ELSIF NOT igs_pe_nonimg_form_pkg.get_pk_for_validation ( new_references.nonimg_form_id ) THEN

250:
251: IF (((old_references.nonimg_form_id = new_references.nonimg_form_id)) OR
252: ((new_references.nonimg_form_id IS NULL))) THEN
253: NULL;
254: ELSIF NOT igs_pe_nonimg_form_pkg.get_pk_for_validation ( new_references.nonimg_form_id ) THEN
255: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: END IF;

Line 334: PROCEDURE get_fk_igs_pe_nonimg_form ( x_nonimg_form_id IN NUMBER ) AS

330:
331: END get_uk_for_validation ;
332:
333:
334: PROCEDURE get_fk_igs_pe_nonimg_form ( x_nonimg_form_id IN NUMBER ) AS
335: /*
336: || Created By : [email protected]
337: || Created On : 28-NOV-2002
338: || Purpose : Validates the Foreign Keys for the table.

Line 364: END get_fk_igs_pe_nonimg_form;

360: RETURN;
361: END IF;
362: CLOSE cur_rowid;
363:
364: END get_fk_igs_pe_nonimg_form;
365:
366:
367: PROCEDURE before_dml (
368: p_action IN VARCHAR2,