APPS.IGS_AD_TER_ED_UNI_AT_PKG dependencies on IGS_AD_TER_ED_UNI_AT

Line 1: package body IGS_AD_TER_ED_UNI_AT_PKG as

1: package body IGS_AD_TER_ED_UNI_AT_PKG as
2: /* $Header: IGSAI51B.pls 115.4 2002/11/28 22:08:07 nsidana ship $ */
3: -- Bg No 1956374 , Procedure admp_val_teua_sret reference is changed
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_AD_TER_ED_UNI_AT%RowType;

2: /* $Header: IGSAI51B.pls 115.4 2002/11/28 22:08:07 nsidana ship $ */
3: -- Bg No 1956374 , Procedure admp_val_teua_sret reference is changed
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AD_TER_ED_UNI_AT%RowType;
7: new_references IGS_AD_TER_ED_UNI_AT%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_AD_TER_ED_UNI_AT%RowType;

3: -- Bg No 1956374 , Procedure admp_val_teua_sret reference is changed
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AD_TER_ED_UNI_AT%RowType;
7: new_references IGS_AD_TER_ED_UNI_AT%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_AD_TER_ED_UNI_AT

27: ) as
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_AD_TER_ED_UNI_AT
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 238: FROM IGS_AD_TER_ED_UNI_AT

234: )return BOOLEAN AS
235:
236: CURSOR cur_rowid IS
237: SELECT rowid
238: FROM IGS_AD_TER_ED_UNI_AT
239: WHERE person_id = x_person_id
240: AND te_sequence_number = x_te_sequence_number
241: AND unit_cd = x_unit_cd
242: AND sequence_number = x_sequence_number

Line 267: FROM IGS_AD_TER_ED_UNI_AT

263: ) AS
264:
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM IGS_AD_TER_ED_UNI_AT
268: WHERE discipline_group_cd = x_discipline_group_cd ;
269:
270: lv_rowid cur_rowid%RowType;
271:

Line 294: FROM IGS_AD_TER_ED_UNI_AT

290: ) AS
291:
292: CURSOR cur_rowid IS
293: SELECT rowid
294: FROM IGS_AD_TER_ED_UNI_AT
295: WHERE person_id = x_person_id
296: AND te_sequence_number = x_sequence_number ;
297:
298: lv_rowid cur_rowid%RowType;

Line 421: cursor C is select ROWID from IGS_AD_TER_ED_UNI_AT

417: X_GRADE in VARCHAR2,
418: X_DISCIPLINE_GROUP_CD in VARCHAR2,
419: X_MODE in VARCHAR2 default 'R'
420: ) As
421: cursor C is select ROWID from IGS_AD_TER_ED_UNI_AT
422: where PERSON_ID = X_PERSON_ID
423: and TE_SEQUENCE_NUMBER = X_TE_SEQUENCE_NUMBER
424: and UNIT_CD = X_UNIT_CD
425: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 468: insert into IGS_AD_TER_ED_UNI_AT (

464: x_last_updated_by => X_LAST_UPDATED_BY,
465: x_last_update_login => X_LAST_UPDATE_LOGIN
466: );
467:
468: insert into IGS_AD_TER_ED_UNI_AT (
469: PERSON_ID,
470: TE_SEQUENCE_NUMBER,
471: UNIT_CD,
472: SEQUENCE_NUMBER,

Line 536: from IGS_AD_TER_ED_UNI_AT

532: TITLE,
533: CREDIT_POINTS,
534: GRADE,
535: DISCIPLINE_GROUP_CD
536: from IGS_AD_TER_ED_UNI_AT
537: where ROWID = X_ROWID for update nowait;
538: tlinfo c1%rowtype;
539:
540: begin

Line 632: update IGS_AD_TER_ED_UNI_AT set

628: x_last_updated_by => X_LAST_UPDATED_BY,
629: x_last_update_login => X_LAST_UPDATE_LOGIN
630: );
631:
632: update IGS_AD_TER_ED_UNI_AT set
633: ENROLLED_YR = NEW_REFERENCES.ENROLLED_YR,
634: RESULT_TYPE = NEW_REFERENCES.RESULT_TYPE,
635: TITLE = NEW_REFERENCES.TITLE,
636: CREDIT_POINTS = NEW_REFERENCES.CREDIT_POINTS,

Line 668: cursor c1 is select rowid from IGS_AD_TER_ED_UNI_AT

664: X_GRADE in VARCHAR2,
665: X_DISCIPLINE_GROUP_CD in VARCHAR2,
666: X_MODE in VARCHAR2 default 'R'
667: ) As
668: cursor c1 is select rowid from IGS_AD_TER_ED_UNI_AT
669: where PERSON_ID = X_PERSON_ID
670: and TE_SEQUENCE_NUMBER = X_TE_SEQUENCE_NUMBER
671: and UNIT_CD = X_UNIT_CD
672: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 719: delete from IGS_AD_TER_ED_UNI_AT

715: p_action => 'DELETE',
716: x_rowid => X_ROWID
717: );
718:
719: delete from IGS_AD_TER_ED_UNI_AT
720: where ROWID = X_ROWID;
721: if (sql%notfound) then
722: raise no_data_found;
723: end if;

Line 731: end IGS_AD_TER_ED_UNI_AT_PKG;

727: x_rowid => X_ROWID
728: );
729: end DELETE_ROW;
730:
731: end IGS_AD_TER_ED_UNI_AT_PKG;