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_DA_REQ_STDNTS_PKG dependencies on IGS_DA_REQ_STDNTS

Line 1: PACKAGE BODY igs_da_req_stdnts_pkg AS

1: PACKAGE BODY igs_da_req_stdnts_pkg AS
2: /* $Header: IGSKI49B.pls 120.0 2005/07/05 13:01:20 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_stdnts%ROWTYPE;

Line 5: old_references igs_da_req_stdnts%ROWTYPE;

1: PACKAGE BODY igs_da_req_stdnts_pkg AS
2: /* $Header: IGSKI49B.pls 120.0 2005/07/05 13:01:20 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_stdnts%ROWTYPE;
6: new_references igs_da_req_stdnts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_da_req_stdnts%ROWTYPE;

2: /* $Header: IGSKI49B.pls 120.0 2005/07/05 13:01:20 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_da_req_stdnts%ROWTYPE;
6: new_references igs_da_req_stdnts%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 12: x_igs_da_req_stdnts_id IN NUMBER,

8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,
11: x_batch_id IN NUMBER,
12: x_igs_da_req_stdnts_id IN NUMBER,
13: x_person_id IN NUMBER,
14: x_program_code IN VARCHAR2,
15: x_wif_program_code IN VARCHAR2,
16: x_special_program_code IN VARCHAR2,

Line 40: FROM igs_da_req_stdnts

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM igs_da_req_stdnts
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 62: new_references.igs_da_req_stdnts_id := x_igs_da_req_stdnts_id;

58: CLOSE cur_old_ref_values;
59:
60: -- Populate New Values.
61: new_references.batch_id := x_batch_id;
62: new_references.igs_da_req_stdnts_id := x_igs_da_req_stdnts_id;
63: new_references.person_id := x_person_id;
64: new_references.program_code := x_program_code;
65: new_references.wif_program_code := x_wif_program_code;
66: new_references.special_program_code := x_special_program_code;

Line 140: x_igs_da_req_stdnts_id IN NUMBER

136: END check_parent_existance;
137:
138:
139: FUNCTION get_pk_for_validation (
140: x_igs_da_req_stdnts_id IN NUMBER
141: ) RETURN BOOLEAN AS
142: /*
143: || Created By :
144: || Created On : 27-MAR-2003

Line 153: FROM igs_da_req_stdnts

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_da_req_stdnts
154: WHERE igs_da_req_stdnts_id = x_igs_da_req_stdnts_id
155: FOR UPDATE NOWAIT;
156:
157: lv_rowid cur_rowid%RowType;

Line 154: WHERE igs_da_req_stdnts_id = x_igs_da_req_stdnts_id

150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_da_req_stdnts
154: WHERE igs_da_req_stdnts_id = x_igs_da_req_stdnts_id
155: FOR UPDATE NOWAIT;
156:
157: lv_rowid cur_rowid%RowType;
158:

Line 188: FROM igs_da_req_stdnts

184: || (reverse chronological order - newest change first)
185: */
186: CURSOR cur_rowid IS
187: SELECT rowid
188: FROM igs_da_req_stdnts
189: WHERE ((program_code = x_course_cd))
190: OR ((wif_program_code = x_course_cd));
191:
192: lv_rowid cur_rowid%RowType;

Line 225: FROM igs_da_req_stdnts

221: || (reverse chronological order - newest change first)
222: */
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_da_req_stdnts
226: WHERE ((batch_id = x_batch_id) AND
227: (wif_id = x_wif_id));
228:
229: lv_rowid cur_rowid%RowType;

Line 312: x_igs_da_req_stdnts_id IN NUMBER,

308: PROCEDURE before_dml (
309: p_action IN VARCHAR2,
310: x_rowid IN VARCHAR2,
311: x_batch_id IN NUMBER,
312: x_igs_da_req_stdnts_id IN NUMBER,
313: x_person_id IN NUMBER,
314: x_program_code IN VARCHAR2,
315: x_wif_program_code IN VARCHAR2,
316: x_special_program_code IN VARCHAR2,

Line 344: x_igs_da_req_stdnts_id,

340: set_column_values (
341: p_action,
342: x_rowid,
343: x_batch_id,
344: x_igs_da_req_stdnts_id,
345: x_person_id,
346: x_program_code,
347: x_wif_program_code,
348: x_special_program_code,

Line 364: new_references.igs_da_req_stdnts_id

360:
361: IF (p_action = 'INSERT') THEN
362: -- Call all the procedures related to Before Insert.
363: IF ( get_pk_for_validation(
364: new_references.igs_da_req_stdnts_id
365: )
366: ) THEN
367: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
368: igs_ge_msg_stack.add;

Line 378: new_references.igs_da_req_stdnts_id

374: check_parent_existance;
375: ELSIF (p_action = 'VALIDATE_INSERT') THEN
376: -- Call all the procedures related to Before Insert.
377: IF ( get_pk_for_validation (
378: new_references.igs_da_req_stdnts_id
379: )
380: ) THEN
381: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
382: igs_ge_msg_stack.add;

Line 393: x_igs_da_req_stdnts_id IN OUT NOCOPY NUMBER,

389:
390: PROCEDURE insert_row (
391: x_rowid IN OUT NOCOPY VARCHAR2,
392: x_batch_id IN NUMBER,
393: x_igs_da_req_stdnts_id IN OUT NOCOPY NUMBER,
394: x_person_id IN NUMBER,
395: x_program_code IN VARCHAR2,
396: x_wif_program_code IN VARCHAR2,
397: x_special_program_code IN VARCHAR2,

Line 436: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.INSERT_ROW');

432: x_last_update_login := -1;
433: END IF;
434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.INSERT_ROW');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:

Line 441: -- x_igs_da_req_stdnts_id := NULL;

437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
441: -- x_igs_da_req_stdnts_id := NULL;
442:
443: before_dml(
444: p_action => 'INSERT',
445: x_rowid => x_rowid,

Line 447: x_igs_da_req_stdnts_id => x_igs_da_req_stdnts_id,

443: before_dml(
444: p_action => 'INSERT',
445: x_rowid => x_rowid,
446: x_batch_id => x_batch_id,
447: x_igs_da_req_stdnts_id => x_igs_da_req_stdnts_id,
448: x_person_id => x_person_id,
449: x_program_code => x_program_code,
450: x_wif_program_code => x_wif_program_code,
451: x_special_program_code => x_special_program_code,

Line 470: INSERT INTO igs_da_req_stdnts (

466:
467: BeforeInsert(TRUE,FALSE);
468:
469:
470: INSERT INTO igs_da_req_stdnts (
471: batch_id,
472: igs_da_req_stdnts_id,
473: person_id,
474: program_code,

Line 472: igs_da_req_stdnts_id,

468:
469:
470: INSERT INTO igs_da_req_stdnts (
471: batch_id,
472: igs_da_req_stdnts_id,
473: person_id,
474: program_code,
475: wif_program_code,
476: special_program_code,

Line 489: igs_da_req_stdnts_s.NEXTVAL,

485: last_update_login,
486: error_code
487: ) VALUES (
488: new_references.batch_id,
489: igs_da_req_stdnts_s.NEXTVAL,
490: new_references.person_id,
491: new_references.program_code,
492: new_references.wif_program_code,
493: new_references.special_program_code,

Line 504: ) RETURNING ROWID, igs_da_req_stdnts_id INTO x_rowid, x_igs_da_req_stdnts_id;

500: x_last_update_date,
501: x_last_updated_by,
502: x_last_update_login,
503: new_references.error_code
504: ) RETURNING ROWID, igs_da_req_stdnts_id INTO x_rowid, x_igs_da_req_stdnts_id;
505:
506: END insert_row;
507:
508:

Line 512: x_igs_da_req_stdnts_id IN NUMBER,

508:
509: PROCEDURE lock_row (
510: x_rowid IN VARCHAR2,
511: x_batch_id IN NUMBER,
512: x_igs_da_req_stdnts_id IN NUMBER,
513: x_person_id IN NUMBER,
514: x_program_code IN VARCHAR2,
515: x_wif_program_code IN VARCHAR2,
516: x_special_program_code IN VARCHAR2,

Line 544: FROM igs_da_req_stdnts

540: program_major_code,
541: report_text,
542: wif_id,
543: error_code
544: FROM igs_da_req_stdnts
545: WHERE rowid = x_rowid
546: FOR UPDATE NOWAIT;
547:
548: tlinfo c1%ROWTYPE;

Line 589: x_igs_da_req_stdnts_id IN NUMBER,

585:
586: PROCEDURE update_row (
587: x_rowid IN VARCHAR2,
588: x_batch_id IN NUMBER,
589: x_igs_da_req_stdnts_id IN NUMBER,
590: x_person_id IN NUMBER,
591: x_program_code IN VARCHAR2,
592: x_wif_program_code IN VARCHAR2,
593: x_special_program_code IN VARCHAR2,

Line 631: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW');

627: x_last_update_login := -1;
628: END IF;
629: ELSE
630: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
631: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW');
632: igs_ge_msg_stack.add;
633: app_exception.raise_exception;
634: END IF;
635:

Line 636: -- x_igs_da_req_stdnts_id := NULL;

632: igs_ge_msg_stack.add;
633: app_exception.raise_exception;
634: END IF;
635:
636: -- x_igs_da_req_stdnts_id := NULL;
637:
638: before_dml(
639: p_action => 'UPDATE',
640: x_rowid => x_rowid,

Line 642: x_igs_da_req_stdnts_id => x_igs_da_req_stdnts_id,

638: before_dml(
639: p_action => 'UPDATE',
640: x_rowid => x_rowid,
641: x_batch_id => x_batch_id,
642: x_igs_da_req_stdnts_id => x_igs_da_req_stdnts_id,
643: x_person_id => x_person_id,
644: x_program_code => x_program_code,
645: x_wif_program_code => x_wif_program_code,
646: x_special_program_code => x_special_program_code,

Line 659: UPDATE igs_da_req_stdnts

655: x_last_update_login => x_last_update_login,
656: x_error_code => x_error_code
657: );
658:
659: UPDATE igs_da_req_stdnts
660: SET
661: batch_id = new_references.batch_id,
662: person_id = new_references.person_id,
663: program_code = new_references.program_code,

Line 686: x_igs_da_req_stdnts_id IN OUT NOCOPY NUMBER,

682:
683: PROCEDURE add_row (
684: x_rowid IN OUT NOCOPY VARCHAR2,
685: x_batch_id IN NUMBER,
686: x_igs_da_req_stdnts_id IN OUT NOCOPY NUMBER,
687: x_person_id IN NUMBER,
688: x_program_code IN VARCHAR2,
689: x_wif_program_code IN VARCHAR2,
690: x_special_program_code IN VARCHAR2,

Line 709: FROM igs_da_req_stdnts

705: || (reverse chronological order - newest change first)
706: */
707: CURSOR c1 IS
708: SELECT rowid
709: FROM igs_da_req_stdnts
710: WHERE igs_da_req_stdnts_id = x_igs_da_req_stdnts_id;
711:
712: BEGIN
713:

Line 710: WHERE igs_da_req_stdnts_id = x_igs_da_req_stdnts_id;

706: */
707: CURSOR c1 IS
708: SELECT rowid
709: FROM igs_da_req_stdnts
710: WHERE igs_da_req_stdnts_id = x_igs_da_req_stdnts_id;
711:
712: BEGIN
713:
714: OPEN c1;

Line 722: x_igs_da_req_stdnts_id,

718:
719: insert_row (
720: x_rowid,
721: x_batch_id,
722: x_igs_da_req_stdnts_id,
723: x_person_id,
724: x_program_code,
725: x_wif_program_code,
726: x_special_program_code,

Line 741: x_igs_da_req_stdnts_id,

737:
738: update_row (
739: x_rowid,
740: x_batch_id,
741: x_igs_da_req_stdnts_id,
742: x_person_id,
743: x_program_code,
744: x_wif_program_code,
745: x_special_program_code,

Line 776: DELETE FROM igs_da_req_stdnts

772: p_action => 'DELETE',
773: x_rowid => x_rowid
774: );
775:
776: DELETE FROM igs_da_req_stdnts
777: WHERE rowid = x_rowid;
778:
779: IF (SQL%NOTFOUND) THEN
780: RAISE NO_DATA_FOUND;

Line 786: END igs_da_req_stdnts_pkg;

782:
783: END delete_row;
784:
785:
786: END igs_da_req_stdnts_pkg;