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_EN_SPA_TERMS_PKG dependencies on IGS_EN_SPA_TERMS

Line 1: PACKAGE BODY igs_en_spa_terms_pkg AS

1: PACKAGE BODY igs_en_spa_terms_pkg AS
2: /* $Header: IGSEI76B.pls 120.8 2005/10/07 03:06:20 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_spa_terms%ROWTYPE;

Line 5: old_references igs_en_spa_terms%ROWTYPE;

1: PACKAGE BODY igs_en_spa_terms_pkg AS
2: /* $Header: IGSEI76B.pls 120.8 2005/10/07 03:06:20 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_spa_terms%ROWTYPE;
6: new_references igs_en_spa_terms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_spa_terms%ROWTYPE;

2: /* $Header: IGSEI76B.pls 120.8 2005/10/07 03:06:20 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_spa_terms%ROWTYPE;
6: new_references igs_en_spa_terms%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 65: FROM igs_en_spa_terms

61: */
62:
63: CURSOR cur_old_ref_values IS
64: SELECT *
65: FROM igs_en_spa_terms
66: WHERE rowid = x_rowid;
67:
68: BEGIN
69:

Line 234: FROM IGS_EN_SPA_TERMS

230: ||
231: */
232: CURSOR cur_rowid IS
233: SELECT ROWID
234: FROM IGS_EN_SPA_TERMS
235: WHERE TERM_CAL_TYPE = X_CAL_TYPE AND
236: TERM_SEQUENCE_NUMBER = X_SEQUENCE_NUMBER ;
237: lv_rowid cur_rowid%ROWTYPE;
238:

Line 267: FROM IGS_EN_SPA_TERMS

263: || (reverse chronological order - newest change first)
264: */
265: CURSOR cur_rowid IS
266: SELECT ROWID
267: FROM IGS_EN_SPA_TERMS
268: WHERE person_id = x_person_id
269: AND program_cd = x_course_cd ;
270: lv_rowid cur_rowid%ROWTYPE;
271: BEGIN

Line 298: FROM IGS_EN_SPA_TERMS

294: || (reverse chronological order - newest change first)
295: */
296: CURSOR cur_rowid IS
297: SELECT ROWID
298: FROM IGS_EN_SPA_TERMS
299: WHERE CLASS_STANDING_ID = X_IGS_PR_CLASS_STD_ID;
300:
301: lv_cur cur_rowid%ROWTYPE;
302:

Line 330: FROM IGS_EN_SPA_TERMS

326: || (reverse chronological order - newest change first)
327: */
328: CURSOR cur_rowid IS
329: SELECT ROWID
330: FROM IGS_EN_SPA_TERMS
331: WHERE fee_cat = x_fee_cat ;
332: lv_rowid cur_rowid%ROWTYPE;
333: BEGIN
334: OPEN cur_rowid;

Line 360: FROM IGS_EN_SPA_TERMS

356: || (reverse chronological order - newest change first)
357: */
358: CURSOR cur_rowid IS
359: SELECT ROWID
360: FROM IGS_EN_SPA_TERMS
361: WHERE coo_id = x_coo_id;
362: lv_rowid cur_rowid%ROWTYPE;
363: BEGIN
364: OPEN cur_rowid;

Line 391: FROM igs_en_spa_terms

387: || (reverse chronological order - newest change first)
388: */
389: CURSOR cur_rowid IS
390: SELECT rowid
391: FROM igs_en_spa_terms
392: WHERE term_record_id = x_term_record_id
393: FOR UPDATE NOWAIT;
394:
395: lv_rowid cur_rowid%RowType;

Line 430: FROM igs_en_spa_terms

426: */
427:
428: CURSOR cur_rowid is
429: SELECT rowid
430: FROM igs_en_spa_terms
431: WHERE x_person_id = person_id AND
432: x_program_cd = program_cd AND
433: x_term_cal_type = term_cal_type AND
434: x_term_sequence_number = term_sequence_number

Line 783: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.INSERT_ROW');

779: x_program_update_date := sysdate;
780: END IF;
781: ELSE
782: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
783: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.INSERT_ROW');
784: igs_ge_msg_stack.add;
785: app_exception.raise_exception;
786: END IF;
787:

Line 839: INSERT INTO igs_en_spa_terms (

835:
836: IF (x_mode = 'S') THEN
837: igs_sc_gen_001.set_ctx('R');
838: END IF;
839: INSERT INTO igs_en_spa_terms (
840: term_record_id,
841: person_id,
842: program_cd,
843: program_version,

Line 886: igs_en_spa_terms_s.NEXTVAL,

882: program_application_id,
883: program_update_date,
884: plan_sht_status
885: ) VALUES (
886: igs_en_spa_terms_s.NEXTVAL,
887: new_references.person_id,
888: new_references.program_cd,
889: new_references.program_version,
890: new_references.acad_cal_type,

Line 1038: FROM igs_en_spa_terms

1034: attribute18,
1035: attribute19,
1036: attribute20,
1037: plan_sht_status
1038: FROM igs_en_spa_terms
1039: WHERE rowid = x_rowid
1040: FOR UPDATE NOWAIT;
1041:
1042: tlinfo c1%ROWTYPE;

Line 1180: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.UPDATE_ROW');

1176: x_last_update_login := -1;
1177: END IF;
1178: ELSE
1179: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1180: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.UPDATE_ROW');
1181: igs_ge_msg_stack.add;
1182: app_exception.raise_exception;
1183: END IF;
1184:

Line 1248: UPDATE igs_en_spa_terms

1244:
1245: IF (x_mode = 'S') THEN
1246: igs_sc_gen_001.set_ctx('R');
1247: END IF;
1248: UPDATE igs_en_spa_terms
1249: SET
1250: person_id = new_references.person_id,
1251: program_cd = new_references.program_cd,
1252: program_version = new_references.program_version,

Line 1372: FROM igs_en_spa_terms

1368: || (reverse chronological order - newest change first)
1369: */
1370: CURSOR c1 IS
1371: SELECT rowid
1372: FROM igs_en_spa_terms
1373: WHERE term_record_id = x_term_record_id;
1374:
1375: BEGIN
1376:

Line 1493: DELETE FROM igs_en_spa_terms

1489:
1490: IF (x_mode = 'S') THEN
1491: igs_sc_gen_001.set_ctx('R');
1492: END IF;
1493: DELETE FROM igs_en_spa_terms
1494: WHERE rowid = x_rowid;
1495:
1496: IF (SQL%NOTFOUND) THEN
1497: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1517: END igs_en_spa_terms_pkg;

1513: BEGIN
1514: igs_en_plan_units_pkg.get_fk_igs_en_stdnt_ps_att(x_person_id,x_course_cd);
1515: END check_child_existence;
1516:
1517: END igs_en_spa_terms_pkg;