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_PS_UNITASS_ITEM_PKG dependencies on IGS_PS_UNITASS_ITEM

Line 1: PACKAGE BODY igs_ps_unitass_item_pkg AS

1: PACKAGE BODY igs_ps_unitass_item_pkg AS
2: /* $Header: IGSPI0KB.pls 120.1 2006/09/20 07:27:13 sepalani noship $ */
3: -- Bug# 1956374 , procedure assp_val_ai_exists,assp_val_uai_uapi,assp_val_uai_uniqref reference is changed
4: l_rowid VARCHAR2 (25);
5: old_references igs_ps_unitass_item%ROWTYPE;

Line 5: old_references igs_ps_unitass_item%ROWTYPE;

1: PACKAGE BODY igs_ps_unitass_item_pkg AS
2: /* $Header: IGSPI0KB.pls 120.1 2006/09/20 07:27:13 sepalani noship $ */
3: -- Bug# 1956374 , procedure assp_val_ai_exists,assp_val_uai_uapi,assp_val_uai_uniqref reference is changed
4: l_rowid VARCHAR2 (25);
5: old_references igs_ps_unitass_item%ROWTYPE;
6: new_references igs_ps_unitass_item%ROWTYPE;
7: lv_cal_type VARCHAR2 (10);
8: lv_unit_cd VARCHAR2 (10);
9: lv_version_number NUMBER;

Line 6: new_references igs_ps_unitass_item%ROWTYPE;

2: /* $Header: IGSPI0KB.pls 120.1 2006/09/20 07:27:13 sepalani noship $ */
3: -- Bug# 1956374 , procedure assp_val_ai_exists,assp_val_uai_uapi,assp_val_uai_uniqref reference is changed
4: l_rowid VARCHAR2 (25);
5: old_references igs_ps_unitass_item%ROWTYPE;
6: new_references igs_ps_unitass_item%ROWTYPE;
7: lv_cal_type VARCHAR2 (10);
8: lv_unit_cd VARCHAR2 (10);
9: lv_version_number NUMBER;
10: lv_ci_sequence_number NUMBER;

Line 53: FROM igs_ps_unitass_item

49: (reverse chronological order - newest change first)
50: ***************************************************************/
51: CURSOR cur_old_ref_values IS
52: SELECT *
53: FROM igs_ps_unitass_item
54: WHERE ROWID = x_rowid;
55: BEGIN
56: l_rowid := x_rowid;
57: -- Code for setting the Old and New Reference Values.

Line 399: FROM igs_ps_unitass_item

395: -- ADDED BY DDEY FOR BUG # 2162831
396: PROCEDURE get_fk_igs_as_grd_schema (x_grading_schema_cd IN VARCHAR2, x_version_number IN NUMBER) AS
397: CURSOR cur_rowid IS
398: SELECT ROWID
399: FROM igs_ps_unitass_item
400: WHERE grading_schema_cd = x_grading_schema_cd
401: AND gs_version_number = x_version_number;
402: lv_rowid cur_rowid%ROWTYPE;
403: BEGIN

Line 419: FROM igs_ps_unitass_item

415:
416: PROCEDURE get_fk_igs_as_us_ai_group (x_us_ass_item_group_id IN NUMBER) AS
417: CURSOR cur_rowid IS
418: SELECT ROWID
419: FROM igs_ps_unitass_item
420: WHERE us_ass_item_group_id = x_us_ass_item_group_id;
421: lv_rowid cur_rowid%ROWTYPE;
422: BEGIN
423: OPEN cur_rowid;

Line 448: FROM igs_ps_unitass_item

444: (reverse chronological order - newest change first)
445: ***************************************************************/
446: CURSOR cur_rowid IS
447: SELECT ROWID
448: FROM igs_ps_unitass_item
449: WHERE unit_section_ass_item_id = x_unit_section_ass_item_id
450: FOR UPDATE NOWAIT;
451: lv_rowid cur_rowid%ROWTYPE;
452: BEGIN

Line 483: FROM igs_ps_unitass_item

479: (reverse chronological order - newest change first)
480: ***************************************************************/
481: CURSOR cur_rowid IS
482: SELECT ROWID
483: FROM igs_ps_unitass_item
484: WHERE ass_id = x_ass_id
485: AND sequence_number = x_sequence_number
486: AND uoo_id = x_uoo_id
487: AND ((l_rowid IS NULL)

Line 688: FROM igs_ps_unitass_item

684: (reverse chronological order - newest change first)
685: ***************************************************************/
686: CURSOR c IS
687: SELECT ROWID
688: FROM igs_ps_unitass_item
689: WHERE unit_section_ass_item_id = x_unit_section_ass_item_id;
690: x_last_update_date DATE;
691: x_last_updated_by NUMBER;
692: x_last_update_login NUMBER;

Line 727: SELECT igs_ps_unitass_item_s.NEXTVAL

723: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
724: igs_ge_msg_stack.ADD;
725: app_exception.raise_exception;
726: END IF;
727: SELECT igs_ps_unitass_item_s.NEXTVAL
728: INTO x_unit_section_ass_item_id
729: FROM DUAL;
730: SELECT igs_ps_unitass_item_seq_num_s.NEXTVAL
731: INTO x_sequence_number

Line 730: SELECT igs_ps_unitass_item_seq_num_s.NEXTVAL

726: END IF;
727: SELECT igs_ps_unitass_item_s.NEXTVAL
728: INTO x_unit_section_ass_item_id
729: FROM DUAL;
730: SELECT igs_ps_unitass_item_seq_num_s.NEXTVAL
731: INTO x_sequence_number
732: FROM DUAL;
733: before_dml (
734: p_action => 'INSERT',

Line 764: INSERT INTO igs_ps_unitass_item

760: x_midterm_weight_qty => x_midterm_weight_qty,
761: x_final_mandatory_type_code => x_final_mandatory_type_code,
762: x_final_weight_qty => x_final_weight_qty
763: );
764: INSERT INTO igs_ps_unitass_item
765: (unit_section_ass_item_id, uoo_id, ass_id,
766: sequence_number, ci_start_dt, ci_end_dt,
767: due_dt, REFERENCE, dflt_item_ind,
768: logical_delete_dt, action_dt, exam_cal_type,

Line 859: FROM igs_ps_unitass_item

855: midterm_mandatory_type_code,
856: midterm_weight_qty,
857: final_mandatory_type_code,
858: final_weight_qty
859: FROM igs_ps_unitass_item
860: WHERE ROWID = x_rowid
861: FOR UPDATE NOWAIT;
862: tlinfo c1%ROWTYPE;
863: BEGIN

Line 1067: UPDATE igs_ps_unitass_item

1063: x_midterm_weight_qty => x_midterm_weight_qty,
1064: x_final_mandatory_type_code => x_final_mandatory_type_code,
1065: x_final_weight_qty => x_final_weight_qty
1066: );
1067: UPDATE igs_ps_unitass_item
1068: SET uoo_id = new_references.uoo_id,
1069: ass_id = new_references.ass_id,
1070: sequence_number = new_references.sequence_number,
1071: ci_start_dt = new_references.ci_start_dt,

Line 1140: FROM igs_ps_unitass_item

1136: (reverse chronological order - newest change first)
1137: ***************************************************************/
1138: CURSOR c1 IS
1139: SELECT ROWID
1140: FROM igs_ps_unitass_item
1141: WHERE unit_section_ass_item_id = x_unit_section_ass_item_id;
1142: BEGIN
1143: OPEN c1;
1144: FETCH c1 INTO x_rowid;

Line 1216: DELETE FROM igs_ps_unitass_item

1212: (reverse chronological order - newest change first)
1213: ***************************************************************/
1214: BEGIN
1215: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
1216: DELETE FROM igs_ps_unitass_item
1217: WHERE ROWID = x_rowid;
1218: IF (SQL%NOTFOUND) THEN
1219: RAISE NO_DATA_FOUND;
1220: END IF;

Line 1223: END igs_ps_unitass_item_pkg;

1219: RAISE NO_DATA_FOUND;
1220: END IF;
1221: after_dml (p_action => 'DELETE', x_rowid => x_rowid);
1222: END delete_row;
1223: END igs_ps_unitass_item_pkg;