APPS.IGS_AS_ASSESSMNT_ITM_PKG dependencies on IGS_AS_ASSESSMNT_ITM_ALL

Line 5: old_references IGS_AS_ASSESSMNT_ITM_ALL%RowType;

1: package body IGS_AS_ASSESSMNT_ITM_PKG as
2: /* $Header: IGSDI38B.pls 115.10 2003/02/24 11:58:23 anilk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSMNT_ITM_ALL%RowType;
6: new_references IGS_AS_ASSESSMNT_ITM_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AS_ASSESSMNT_ITM_ALL%RowType;

2: /* $Header: IGSDI38B.pls 115.10 2003/02/24 11:58:23 anilk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSMNT_ITM_ALL%RowType;
6: new_references IGS_AS_ASSESSMNT_ITM_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 61: FROM IGS_AS_ASSESSMNT_ITM_ALL

57: ) as
58:
59: CURSOR cur_old_ref_values IS
60: SELECT *
61: FROM IGS_AS_ASSESSMNT_ITM_ALL
62: WHERE rowid = x_rowid;
63:
64: BEGIN
65:

Line 340: FROM IGS_AS_ASSESSMNT_ITM_ALL

336: x_ass_id IN NUMBER
337: ) RETURN BOOLEAN AS
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM IGS_AS_ASSESSMNT_ITM_ALL
341: WHERE ass_id = x_ass_id;
342:
343: lv_rowid cur_rowid%RowType;
344:

Line 365: FROM IGS_AS_ASSESSMNT_ITM_ALL

361: ) as
362:
363: CURSOR cur_rowid IS
364: SELECT rowid
365: FROM IGS_AS_ASSESSMNT_ITM_ALL
366: WHERE assessment_type = x_assessment_type ;
367:
368: lv_rowid cur_rowid%RowType;
369:

Line 576: cursor C is select ROWID from IGS_AS_ASSESSMNT_ITM_all

572: X_MODE in VARCHAR2 default 'R',
573: -- anilk, bug#2784198
574: x_closed_ind IN VARCHAR2
575: ) as
576: cursor C is select ROWID from IGS_AS_ASSESSMNT_ITM_all
577: where ASS_ID = X_ASS_ID;
578: X_LAST_UPDATE_DATE DATE;
579: X_LAST_UPDATED_BY NUMBER;
580: X_LAST_UPDATE_LOGIN NUMBER;

Line 651: insert into IGS_AS_ASSESSMNT_ITM_ALL (

647: -- anilk, bug#2784198
648: x_closed_ind => x_closed_ind
649:
650: );
651: insert into IGS_AS_ASSESSMNT_ITM_ALL (
652: ORG_ID,
653: ASS_ID,
654: ASSESSMENT_TYPE,
655: DESCRIPTION,

Line 841: from IGS_AS_ASSESSMNT_ITM_ALL

837: attribute19,
838: attribute20,
839: -- anilk, bug#2784198
840: closed_ind
841: from IGS_AS_ASSESSMNT_ITM_ALL
842:
843: where ROWID = X_ROWID for update nowait;
844: tlinfo c1%rowtype;
845:

Line 1053: update IGS_AS_ASSESSMNT_ITM_ALL set

1049: -- anilk, bug#2784198
1050: x_closed_ind => x_closed_ind
1051: );
1052:
1053: update IGS_AS_ASSESSMNT_ITM_ALL set
1054: ASSESSMENT_TYPE = NEW_REFERENCES.ASSESSMENT_TYPE,
1055: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
1056: EXAM_SHORT_PAPER_NAME = NEW_REFERENCES.EXAM_SHORT_PAPER_NAME,
1057: EXAM_PAPER_NAME = NEW_REFERENCES.EXAM_PAPER_NAME,

Line 1148: cursor c1 is select rowid from IGS_AS_ASSESSMNT_ITM_ALL

1144: X_MODE in VARCHAR2 default 'R',
1145: -- anilk, bug#2784198
1146: x_closed_ind IN VARCHAR2
1147: ) as
1148: cursor c1 is select rowid from IGS_AS_ASSESSMNT_ITM_ALL
1149: where ASS_ID = X_ASS_ID
1150: ;
1151: begin
1152: open c1;