APPS.IGS_PE_EV_FORM_PKG dependencies on IGS_PE_EV_FORM

Line 1: PACKAGE BODY igs_pe_ev_form_pkg AS

1: PACKAGE BODY igs_pe_ev_form_pkg AS
2: /* $Header: IGSNI51B.pls 120.2 2006/02/17 06:54:11 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_ev_form%ROWTYPE;

Line 5: old_references igs_pe_ev_form%ROWTYPE;

1: PACKAGE BODY igs_pe_ev_form_pkg AS
2: /* $Header: IGSNI51B.pls 120.2 2006/02/17 06:54:11 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_ev_form%ROWTYPE;
6: new_references igs_pe_ev_form%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_ev_form%ROWTYPE;

2: /* $Header: IGSNI51B.pls 120.2 2006/02/17 06:54:11 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_ev_form%ROWTYPE;
6: new_references igs_pe_ev_form%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 70: FROM igs_pe_ev_form

66: */
67:
68: CURSOR cur_old_ref_values IS
69: SELECT *
70: FROM igs_pe_ev_form
71: WHERE rowid = x_rowid;
72:
73: BEGIN
74:

Line 246: igs_pe_ev_form_stat_pkg.get_fk_igs_pe_ev_form (

242: || (reverse chronological order - newest change first)
243: */
244: BEGIN
245:
246: igs_pe_ev_form_stat_pkg.get_fk_igs_pe_ev_form (
247: old_references.ev_form_id
248: );
249:
250: END check_child_existance;

Line 293: FROM igs_pe_ev_form

289: || (reverse chronological order - newest change first)
290: */
291: CURSOR cur_rowid IS
292: SELECT rowid
293: FROM igs_pe_ev_form
294: WHERE ev_form_id = x_ev_form_id
295: FOR UPDATE NOWAIT;
296:
297: lv_rowid cur_rowid%RowType;

Line 595: INSERT INTO igs_pe_ev_form (

591:
592: IF (x_mode = 'S') THEN
593: igs_sc_gen_001.set_ctx('R');
594: END IF;
595: INSERT INTO igs_pe_ev_form (
596: ev_form_id,
597: person_id,
598: print_form,
599: form_effective_date,

Line 643: igs_pe_ev_form_s.NEXTVAL,

639: no_show_flag,
640: other_govt_name,
641: SEVIS_SCHOOL_IDENTIFIER
642: ) VALUES (
643: igs_pe_ev_form_s.NEXTVAL,
644: new_references.person_id,
645: new_references.print_form,
646: new_references.form_effective_date,
647: new_references.form_status,

Line 808: FROM igs_pe_ev_form

804: intl_org2_othr_name,
805: no_show_flag,
806: other_govt_name,
807: SEVIS_SCHOOL_IDENTIFIER
808: FROM igs_pe_ev_form
809: WHERE rowid = x_rowid
810: FOR UPDATE NOWAIT;
811:
812: tlinfo c1%ROWTYPE;

Line 1014: UPDATE igs_pe_ev_form

1010:
1011: IF (x_mode = 'S') THEN
1012: igs_sc_gen_001.set_ctx('R');
1013: END IF;
1014: UPDATE igs_pe_ev_form
1015: SET
1016: person_id = new_references.person_id,
1017: print_form = new_references.print_form,
1018: form_effective_date = new_references.form_effective_date,

Line 1146: FROM igs_pe_ev_form

1142: || (reverse chronological order - newest change first)
1143: */
1144: CURSOR c1 IS
1145: SELECT rowid
1146: FROM igs_pe_ev_form
1147: WHERE ev_form_id = x_ev_form_id;
1148:
1149: BEGIN
1150:

Line 1277: DELETE FROM igs_pe_ev_form

1273:
1274: IF (x_mode = 'S') THEN
1275: igs_sc_gen_001.set_ctx('R');
1276: END IF;
1277: DELETE FROM igs_pe_ev_form
1278: WHERE rowid = x_rowid;
1279:
1280: IF (SQL%NOTFOUND) THEN
1281: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1296: END igs_pe_ev_form_pkg;

1292:
1293: END delete_row;
1294:
1295:
1296: END igs_pe_ev_form_pkg;