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_AS_SU_ATMPT_ITM_PKG dependencies on IGS_AS_SU_ATMPT_ITM

Line 1: PACKAGE BODY IGS_AS_SU_ATMPT_ITM_PKG AS

1: PACKAGE BODY IGS_AS_SU_ATMPT_ITM_PKG AS
2: /* $Header: IGSDI08B.pls 120.0 2005/07/05 13:08:56 appldev noship $ */
3: -- Bug No. 1956374 Procedure assp_val_suaai_ins reference is changed
4: l_rowid VARCHAR2 (25);
5: l_altered_creation_dt DATE;

Line 6: old_references igs_as_su_atmpt_itm%ROWTYPE;

2: /* $Header: IGSDI08B.pls 120.0 2005/07/05 13:08:56 appldev noship $ */
3: -- Bug No. 1956374 Procedure assp_val_suaai_ins reference is changed
4: l_rowid VARCHAR2 (25);
5: l_altered_creation_dt DATE;
6: old_references igs_as_su_atmpt_itm%ROWTYPE;
7: new_references igs_as_su_atmpt_itm%ROWTYPE;
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 7: new_references igs_as_su_atmpt_itm%ROWTYPE;

3: -- Bug No. 1956374 Procedure assp_val_suaai_ins reference is changed
4: l_rowid VARCHAR2 (25);
5: l_altered_creation_dt DATE;
6: old_references igs_as_su_atmpt_itm%ROWTYPE;
7: new_references igs_as_su_atmpt_itm%ROWTYPE;
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_person_id IN NUMBER DEFAULT NULL,

Line 70: FROM igs_as_su_atmpt_itm

66: x_penalty_applied_flag IN VARCHAR2 DEFAULT NULL
67: ) AS
68: CURSOR cur_old_ref_values IS
69: SELECT *
70: FROM igs_as_su_atmpt_itm
71: WHERE ROWID = x_rowid;
72: BEGIN
73: l_rowid := x_rowid;
74: -- Code for setting the Old and New Reference Values.

Line 264: -- ON igs_as_su_atmpt_itm

260: END beforerowinsertupdate1;
261: -- Trigger description :-
262: -- "OSS_TST".trg_suaai_ar_iu
263: -- AFTER INSERT OR UPDATE
264: -- ON igs_as_su_atmpt_itm
265: -- FOR EACH ROW
266: PROCEDURE assp_ins_suaai_out_hist AS
267: -- This is the local procedure which inserts a record into history table.
268: l_rowid VARCHAR2 (25);

Line 350: -- ON igs_as_su_atmpt_itm

346: END afterrowinsertupdate2;
347: -- Trigger description :-
348: -- "OSS_TST".trg_suaai_as_iu
349: -- AFTER INSERT OR UPDATE
350: -- ON igs_as_su_atmpt_itm
351: PROCEDURE check_parent_existance AS
352: BEGIN
353: IF (((old_references.ass_id = new_references.ass_id))
354: OR ((new_references.ass_id IS NULL))

Line 397: igs_as_std_exm_instn_pkg.get_fk_igs_as_su_atmpt_itm (

393: BEGIN
394: FOR igs_as_spl_cons_appl_rec IN cur_igs_as_spl_cons_appl LOOP
395: igs_as_spl_cons_appl_pkg.delete_row (x_rowid => igs_as_spl_cons_appl_rec.ROWID);
396: END LOOP;
397: igs_as_std_exm_instn_pkg.get_fk_igs_as_su_atmpt_itm (
398: old_references.course_cd,
399: old_references.person_id,
400: old_references.ass_id,
401: old_references.creation_dt,

Line 421: FROM igs_as_su_atmpt_itm

417: )
418: RETURN BOOLEAN AS
419: CURSOR cur_rowid IS
420: SELECT ROWID
421: FROM igs_as_su_atmpt_itm
422: WHERE course_cd = x_course_cd
423: AND person_id = x_person_id
424: AND ass_id = x_ass_id
425: AND creation_dt = x_creation_dt

Line 444: FROM igs_as_su_atmpt_itm

440:
441: PROCEDURE get_fk_igs_as_assessmnt_itm (x_ass_id IN NUMBER) IS
442: CURSOR cur_rowid IS
443: SELECT ROWID
444: FROM igs_as_su_atmpt_itm
445: WHERE ass_id = x_ass_id;
446: lv_rowid cur_rowid%ROWTYPE;
447: BEGIN
448: OPEN cur_rowid;

Line 471: FROM igs_as_su_atmpt_itm

467:
468: PROCEDURE get_fk_igs_as_sua_ai_group (x_sua_ass_item_group_id IN NUMBER) AS
469: CURSOR cur_rowid IS
470: SELECT ROWID
471: FROM igs_as_su_atmpt_itm
472: WHERE sua_ass_item_group_id = x_sua_ass_item_group_id;
473: lv_rowid cur_rowid%ROWTYPE;
474: BEGIN
475: OPEN cur_rowid;

Line 490: FROM igs_as_su_atmpt_itm

486:
487: PROCEDURE get_fk_igs_tr_item (x_tracking_id IN NUMBER) AS
488: CURSOR cur_rowid IS
489: SELECT ROWID
490: FROM igs_as_su_atmpt_itm
491: WHERE tracking_id = x_tracking_id;
492: lv_rowid cur_rowid%ROWTYPE;
493: BEGIN
494: OPEN cur_rowid;

Line 514: FROM igs_as_su_atmpt_itm

510: x_grade IN VARCHAR2
511: ) AS
512: CURSOR cur_rowid IS
513: SELECT ROWID
514: FROM igs_as_su_atmpt_itm
515: WHERE grading_schema_cd = x_grading_schema_cd
516: AND gs_version_number = x_gs_version_number
517: AND grade = x_grade;
518: lv_rowid cur_rowid%ROWTYPE;

Line 536: FROM igs_as_su_atmpt_itm

532: -- Added by DDEY as a part of enhancement bug # 2162831
533: PROCEDURE get_fk_igs_lookups_view (x_outcome_comment_code IN VARCHAR2) AS
534: CURSOR cur_rowid IS
535: SELECT ROWID
536: FROM igs_as_su_atmpt_itm
537: WHERE outcome_comment_code = x_outcome_comment_code;
538: lv_rowid cur_rowid%ROWTYPE;
539: BEGIN
540: OPEN cur_rowid;

Line 791: FROM igs_as_su_atmpt_itm

787: x_penalty_applied_flag IN VARCHAR2
788: ) AS
789: CURSOR c IS
790: SELECT ROWID
791: FROM igs_as_su_atmpt_itm
792: WHERE person_id = x_person_id
793: AND course_cd = x_course_cd
794: AND ass_id = x_ass_id
795: AND creation_dt = l_altered_creation_dt

Line 903: INSERT INTO igs_as_su_atmpt_itm

899:
900: IF (x_mode = 'S') THEN
901: igs_sc_gen_001.set_ctx('R');
902: END IF;
903: INSERT INTO igs_as_su_atmpt_itm
904: (person_id, course_cd, unit_cd, cal_type,
905: ci_sequence_number, ass_id, creation_dt,
906: attempt_number, outcome_dt, override_due_dt,
907: tracking_id, logical_delete_dt, s_default_ind,

Line 1070: FROM igs_as_su_atmpt_itm

1066: final_weight_qty,
1067: submitted_date,
1068: waived_flag,
1069: penalty_applied_flag
1070: FROM igs_as_su_atmpt_itm
1071: WHERE ROWID = x_rowid
1072: FOR UPDATE NOWAIT;
1073: tlinfo c1%ROWTYPE;
1074: BEGIN

Line 1464: UPDATE igs_as_su_atmpt_itm

1460: END IF;
1461: IF (x_mode = 'S') THEN
1462: igs_sc_gen_001.set_ctx('R');
1463: END IF;
1464: UPDATE igs_as_su_atmpt_itm
1465: SET attempt_number = new_references.attempt_number,
1466: outcome_dt = new_references.outcome_dt,
1467: override_due_dt = new_references.override_due_dt,
1468: tracking_id = new_references.tracking_id,

Line 1599: FROM igs_as_su_atmpt_itm

1595: x_penalty_applied_flag IN VARCHAR2
1596: ) AS
1597: CURSOR c1 IS
1598: SELECT ROWID
1599: FROM igs_as_su_atmpt_itm
1600: WHERE person_id = x_person_id
1601: AND course_cd = x_course_cd
1602: AND ass_id = x_ass_id
1603: AND creation_dt = x_creation_dt

Line 1732: DELETE FROM igs_as_su_atmpt_itm

1728: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
1729: IF (x_mode = 'S') THEN
1730: igs_sc_gen_001.set_ctx('R');
1731: END IF;
1732: DELETE FROM igs_as_su_atmpt_itm
1733: WHERE ROWID = x_rowid;
1734: IF (SQL%NOTFOUND) THEN
1735: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1736: igs_ge_msg_stack.add;

Line 1793: END igs_as_su_atmpt_itm_pkg;

1789: app_exception.raise_exception;
1790: END IF;
1791: END IF;
1792: END check_constraints;
1793: END igs_as_su_atmpt_itm_pkg;