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_UNITASS_ITEM_PKG dependencies on IGS_AS_UNITASS_ITEM_ALL

Line 10: old_references igs_as_unitass_item_all%ROWTYPE;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to IGS_AS_VAL_UAI.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2 (25);
10: old_references igs_as_unitass_item_all%ROWTYPE;
11: new_references igs_as_unitass_item_all%ROWTYPE;
12: PROCEDURE set_column_values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 11: new_references igs_as_unitass_item_all%ROWTYPE;

7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2 (25);
10: old_references igs_as_unitass_item_all%ROWTYPE;
11: new_references igs_as_unitass_item_all%ROWTYPE;
12: PROCEDURE set_column_values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2 DEFAULT NULL,
15: x_unit_ass_item_id IN NUMBER DEFAULT NULL,

Line 52: FROM igs_as_unitass_item_all

48: x_final_weight_qty IN NUMBER DEFAULT NULL
49: ) AS
50: CURSOR cur_old_ref_values IS
51: SELECT *
52: FROM igs_as_unitass_item_all
53: WHERE ROWID = x_rowid;
54: BEGIN
55: l_rowid := x_rowid;
56: -- Code for setting the Old and New Reference Values.

Line 520: FROM igs_as_unitass_item_all

516: FUNCTION get_pk_for_validation (x_unit_ass_item_id IN NUMBER)
517: RETURN BOOLEAN AS
518: CURSOR cur_rowid IS
519: SELECT ROWID
520: FROM igs_as_unitass_item_all
521: WHERE unit_ass_item_id = x_unit_ass_item_id
522: FOR UPDATE NOWAIT;
523: l_rowid cur_rowid%ROWTYPE;
524: BEGIN

Line 547: FROM igs_as_unitass_item_all

543: )
544: RETURN BOOLEAN AS
545: CURSOR cur_rowid IS
546: SELECT ROWID
547: FROM igs_as_unitass_item_all
548: WHERE unit_cd = x_unit_cd
549: AND version_number = x_version_number
550: AND cal_type = x_cal_type
551: AND ci_sequence_number = x_ci_sequence_number

Line 589: FROM igs_as_unitass_item_all

585:
586: PROCEDURE get_fk_igs_as_assessmnt_itm (x_ass_id IN NUMBER) AS
587: CURSOR cur_rowid IS
588: SELECT ROWID
589: FROM igs_as_unitass_item_all
590: WHERE ass_id = x_ass_id;
591: lv_rowid cur_rowid%ROWTYPE;
592: BEGIN
593: OPEN cur_rowid;

Line 608: FROM igs_as_unitass_item_all

604:
605: PROCEDURE get_fk_igs_ca_type (x_cal_type IN VARCHAR2) AS
606: CURSOR cur_rowid IS
607: SELECT ROWID
608: FROM igs_as_unitass_item_all
609: WHERE exam_cal_type = x_cal_type;
610: lv_rowid cur_rowid%ROWTYPE;
611: BEGIN
612: OPEN cur_rowid;

Line 631: FROM igs_as_unitass_item_all

627: x_version_number IN NUMBER
628: ) AS
629: CURSOR cur_rowid IS
630: SELECT ROWID
631: FROM igs_as_unitass_item_all
632: WHERE grading_schema_cd = x_grading_schema_cd
633: AND version_number = x_version_number;
634: lv_rowid cur_rowid%ROWTYPE;
635: BEGIN

Line 654: FROM igs_as_unitass_item_all

650: x_sequence_number IN NUMBER
651: ) AS
652: CURSOR cur_rowid IS
653: SELECT ROWID
654: FROM igs_as_unitass_item_all
655: WHERE exam_cal_type = x_cal_type
656: AND exam_ci_sequence_number = x_sequence_number;
657: lv_rowid cur_rowid%ROWTYPE;
658: BEGIN

Line 700: FROM igs_as_unitass_item_all

696: x_ci_sequence_number IN NUMBER
697: ) AS
698: CURSOR cur_rowid IS
699: SELECT ROWID
700: FROM igs_as_unitass_item_all
701: WHERE unit_cd = x_unit_cd
702: AND version_number = x_version_number
703: AND cal_type = x_cal_type
704: AND ci_sequence_number = x_ci_sequence_number;

Line 724: FROM igs_as_unitass_item_all

720: x_unit_ass_item_group_id IN NUMBER
721: ) AS
722: CURSOR cur_rowid IS
723: SELECT ROWID
724: FROM igs_as_unitass_item_all
725: WHERE unit_ass_item_group_id = x_unit_ass_item_group_id;
726: lv_rowid cur_rowid%ROWTYPE;
727: BEGIN
728: OPEN cur_rowid;

Line 902: FROM igs_as_unitass_item_all

898: x_final_weight_qty IN NUMBER DEFAULT NULL
899: ) AS
900: CURSOR c IS
901: SELECT ROWID
902: FROM igs_as_unitass_item_all
903: WHERE unit_cd = x_unit_cd
904: AND version_number = x_version_number
905: AND cal_type = x_cal_type
906: AND ci_sequence_number = x_ci_sequence_number

Line 987: INSERT INTO igs_as_unitass_item_all

983: );
984: SELECT igs_as_unitass_item_s.NEXTVAL
985: INTO x_unit_ass_item_id
986: FROM DUAL;
987: INSERT INTO igs_as_unitass_item_all
988: (unit_ass_item_id, unit_cd,
989: version_number, cal_type,
990: ci_sequence_number, ass_id,
991: sequence_number, ci_start_dt,

Line 1092: FROM igs_as_unitass_item_all

1088: midterm_mandatory_type_code,
1089: midterm_weight_qty,
1090: final_mandatory_type_code,
1091: final_weight_qty
1092: FROM igs_as_unitass_item_all
1093: WHERE ROWID = x_rowid
1094: FOR UPDATE NOWAIT;
1095: tlinfo c1%ROWTYPE;
1096: BEGIN

Line 1302: UPDATE igs_as_unitass_item_all

1298: ELSE
1299: x_program_update_date := SYSDATE;
1300: END IF;
1301: END IF;
1302: UPDATE igs_as_unitass_item_all
1303: SET ci_start_dt = new_references.ci_start_dt,
1304: ci_end_dt = new_references.ci_end_dt,
1305: unit_class = new_references.unit_class,
1306: unit_mode = new_references.unit_mode,

Line 1373: FROM igs_as_unitass_item_all

1369: x_final_weight_qty IN NUMBER DEFAULT NULL
1370: ) AS
1371: CURSOR c1 IS
1372: SELECT ROWID
1373: FROM igs_as_unitass_item_all
1374: WHERE unit_cd = x_unit_cd
1375: AND version_number = x_version_number
1376: AND cal_type = x_cal_type
1377: AND ci_sequence_number = x_ci_sequence_number

Line 1458: DELETE FROM igs_as_unitass_item_all

1454:
1455: PROCEDURE delete_row (x_rowid IN VARCHAR2) AS
1456: BEGIN
1457: before_dml (p_action => 'DELETE', x_rowid => x_rowid);
1458: DELETE FROM igs_as_unitass_item_all
1459: WHERE ROWID = x_rowid;
1460: IF (SQL%NOTFOUND) THEN
1461: RAISE NO_DATA_FOUND;
1462: END IF;