APPS.IGS_EN_SVS_AUTH_PKG dependencies on IGS_EN_SVS_AUTH

Line 1: PACKAGE BODY igs_en_svs_auth_pkg AS

1: PACKAGE BODY igs_en_svs_auth_pkg AS
2: /* $Header: IGSEI66B.pls 120.1 2006/05/02 01:42:09 amuthu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_svs_auth%ROWTYPE;

Line 5: old_references igs_en_svs_auth%ROWTYPE;

1: PACKAGE BODY igs_en_svs_auth_pkg AS
2: /* $Header: IGSEI66B.pls 120.1 2006/05/02 01:42:09 amuthu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_svs_auth%ROWTYPE;
6: new_references igs_en_svs_auth%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_svs_auth%ROWTYPE;

2: /* $Header: IGSEI66B.pls 120.1 2006/05/02 01:42:09 amuthu noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_svs_auth%ROWTYPE;
6: new_references igs_en_svs_auth%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM igs_en_svs_auth

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM igs_en_svs_auth
38: WHERE rowid = x_rowid;
39:
40: CURSOR c_max_auth_no (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
41: SELECT SEVIS_AUTHORIZATION_NO

Line 42: FROM igs_en_svs_auth esa1

38: WHERE rowid = x_rowid;
39:
40: CURSOR c_max_auth_no (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
41: SELECT SEVIS_AUTHORIZATION_NO
42: FROM igs_en_svs_auth esa1
43: WHERE person_id = cp_person_id
44: AND SEVIS_AUTHORIZATION_NO = (SELECT max(SEVIS_AUTHORIZATION_NO)
45: FROM igs_en_svs_auth esa2
46: WHERE esa2.person_id = esa1.person_id)

Line 45: FROM igs_en_svs_auth esa2

41: SELECT SEVIS_AUTHORIZATION_NO
42: FROM igs_en_svs_auth esa1
43: WHERE person_id = cp_person_id
44: AND SEVIS_AUTHORIZATION_NO = (SELECT max(SEVIS_AUTHORIZATION_NO)
45: FROM igs_en_svs_auth esa2
46: WHERE esa2.person_id = esa1.person_id)
47: FOR UPDATE;
48:
49:

Line 50: l_sevis_authorization_no igs_en_svs_auth.SEVIS_AUTHORIZATION_NO%TYPE;

46: WHERE esa2.person_id = esa1.person_id)
47: FOR UPDATE;
48:
49:
50: l_sevis_authorization_no igs_en_svs_auth.SEVIS_AUTHORIZATION_NO%TYPE;
51:
52: BEGIN
53:
54: l_rowid := x_rowid;

Line 121: fnd_message.set_name ('IGS', 'IGS_EN_SVS_AUTH_CD_REPEAT');

117: new_references.sevis_authorization_code,
118: new_references.start_dt
119: )
120: ) THEN
121: fnd_message.set_name ('IGS', 'IGS_EN_SVS_AUTH_CD_REPEAT');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: END IF;

Line 164: igs_en_svs_auth_cal_pkg.get_fk_igs_en_svs_auth (

160: || (reverse chronological order - newest change first)
161: */
162: BEGIN
163:
164: igs_en_svs_auth_cal_pkg.get_fk_igs_en_svs_auth (
165: old_references.sevis_auth_id
166: );
167:
168: END check_child_existance;

Line 185: FROM igs_en_svs_auth

181: || (reverse chronological order - newest change first)
182: */
183: CURSOR cur_rowid IS
184: SELECT rowid
185: FROM igs_en_svs_auth
186: WHERE sevis_auth_id = x_sevis_auth_id
187: FOR UPDATE NOWAIT;
188:
189: lv_rowid cur_rowid%RowType;

Line 222: FROM igs_en_svs_auth

218: || (reverse chronological order - newest change first)
219: */
220: CURSOR cur_rowid IS
221: SELECT rowid
222: FROM igs_en_svs_auth
223: WHERE person_id = x_person_id
224: AND sevis_authorization_code = x_sevis_authorization_code
225: AND start_dt = x_start_dt
226: AND cancel_flag <> 'Y'

Line 251: FROM IGS_EN_SVS_AUTH_CAL sac

247: ) AS
248:
249: CURSOR c_auth_cal IS
250: SELECT sac.rowid row_id
251: FROM IGS_EN_SVS_AUTH_CAL sac
252: WHERE sevis_auth_id = x_sevis_auth_id;
253:
254:
255: BEGIN

Line 259: IGS_EN_SVS_AUTH_CAL_PKG.DELETE_ROW(c_auth_cal_rec.row_id);

255: BEGIN
256:
257: FOR c_auth_cal_rec in c_auth_cal LOOP
258:
259: IGS_EN_SVS_AUTH_CAL_PKG.DELETE_ROW(c_auth_cal_rec.row_id);
260:
261: END LOOP;
262:
263:

Line 431: fnd_message.set_token ('ROUTINE', 'IGS_EN_SVS_AUTH_PKG.INSERT_ROW');

427: x_program_update_date := SYSDATE;
428: END IF;
429: ELSE
430: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
431: fnd_message.set_token ('ROUTINE', 'IGS_EN_SVS_AUTH_PKG.INSERT_ROW');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435:

Line 456: INSERT INTO igs_en_svs_auth (

452: x_last_updated_by => x_last_updated_by,
453: x_last_update_login => x_last_update_login
454: );
455:
456: INSERT INTO igs_en_svs_auth (
457: sevis_authorization_code,
458: start_dt,
459: end_dt,
460: comments,

Line 479: igs_en_svs_auth_s.NEXTVAL,

475: new_references.sevis_authorization_code,
476: new_references.start_dt,
477: new_references.end_dt,
478: new_references.comments,
479: igs_en_svs_auth_s.NEXTVAL,
480: new_references.sevis_authorization_no,
481: new_references.person_id,
482: new_references.cancel_flag,
483: x_last_update_date,

Line 527: FROM igs_en_svs_auth

523: comments,
524: sevis_authorization_no,
525: person_id,
526: cancel_flag
527: FROM igs_en_svs_auth
528: WHERE rowid = x_rowid
529: FOR UPDATE NOWAIT;
530:
531: tlinfo c1%ROWTYPE;

Line 613: fnd_message.set_token ('ROUTINE', 'IGS_EN_SVS_AUTH_PKG.UPDATE_ROW');

609: x_last_update_login := -1;
610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: fnd_message.set_token ('ROUTINE', 'IGS_EN_SVS_AUTH_PKG.UPDATE_ROW');
614: igs_ge_msg_stack.add;
615: app_exception.raise_exception;
616: END IF;
617:

Line 650: UPDATE igs_en_svs_auth

646: x_program_update_date := SYSDATE;
647: END IF;
648: END IF;
649:
650: UPDATE igs_en_svs_auth
651: SET
652: sevis_authorization_code = new_references.sevis_authorization_code,
653: start_dt = new_references.start_dt,
654: end_dt = new_references.end_dt,

Line 698: FROM igs_en_svs_auth

694: || (reverse chronological order - newest change first)
695: */
696: CURSOR c1 IS
697: SELECT rowid
698: FROM igs_en_svs_auth
699: WHERE sevis_auth_id = x_sevis_auth_id;
700:
701: BEGIN
702:

Line 759: DELETE FROM igs_en_svs_auth

755: p_action => 'DELETE',
756: x_rowid => x_rowid
757: );
758:
759: DELETE FROM igs_en_svs_auth
760: WHERE rowid = x_rowid;
761:
762: IF (SQL%NOTFOUND) THEN
763: RAISE NO_DATA_FOUND;

Line 769: END igs_en_svs_auth_pkg;

765:
766: END delete_row;
767:
768:
769: END igs_en_svs_auth_pkg;