APPS.IGS_AD_AUSE_ED_OT_SC_PKG dependencies on IGS_AD_AUSE_ED_OT_SC

Line 1: package body IGS_AD_AUSE_ED_OT_SC_PKG as

1: package body IGS_AD_AUSE_ED_OT_SC_PKG as
2: /* $Header: IGSAI50B.pls 115.4 2002/11/28 22:07:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUSE_ED_OT_SC%RowType;

Line 5: old_references IGS_AD_AUSE_ED_OT_SC%RowType;

1: package body IGS_AD_AUSE_ED_OT_SC_PKG as
2: /* $Header: IGSAI50B.pls 115.4 2002/11/28 22:07:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUSE_ED_OT_SC%RowType;
6: new_references IGS_AD_AUSE_ED_OT_SC%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_AUSE_ED_OT_SC%RowType;

2: /* $Header: IGSAI50B.pls 115.4 2002/11/28 22:07:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUSE_ED_OT_SC%RowType;
6: new_references IGS_AD_AUSE_ED_OT_SC%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_AD_AUSE_ED_OT_SC

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_AD_AUSE_ED_OT_SC
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 348: FROM IGS_AD_AUSE_ED_OT_SC

344: x_score_type IN VARCHAR2
345: )return BOOLEAN AS
346: CURSOR cur_rowid IS
347: SELECT rowid
348: FROM IGS_AD_AUSE_ED_OT_SC
349: WHERE person_id = x_person_id
350: AND ase_sequence_number = x_ase_sequence_number
351: AND result_obtained_yr = x_result_obtained_yr
352: AND score_type = x_score_type

Line 420: FROM IGS_AD_AUSE_ED_OT_SC

416: ) AS
417:
418: CURSOR cur_rowid IS
419: SELECT rowid
420: FROM IGS_AD_AUSE_ED_OT_SC
421: WHERE person_id = x_person_id
422: AND ase_sequence_number = x_sequence_number ;
423:
424: lv_rowid cur_rowid%RowType;

Line 523: cursor C is select ROWID from IGS_AD_AUSE_ED_OT_SC

519: X_SCORE_TYPE in VARCHAR2,
520: X_SCORE in VARCHAR2,
521: X_MODE in VARCHAR2 default 'R'
522: ) AS
523: cursor C is select ROWID from IGS_AD_AUSE_ED_OT_SC
524: where PERSON_ID = X_PERSON_ID
525: and ASE_SEQUENCE_NUMBER = X_ASE_SEQUENCE_NUMBER
526: and RESULT_OBTAINED_YR = X_RESULT_OBTAINED_YR
527: and SCORE_TYPE = X_SCORE_TYPE;

Line 565: insert into IGS_AD_AUSE_ED_OT_SC (

561: x_last_updated_by=>X_LAST_UPDATED_BY,
562: x_last_update_login=>X_LAST_UPDATE_LOGIN
563: );
564:
565: insert into IGS_AD_AUSE_ED_OT_SC (
566: PERSON_ID,
567: ASE_SEQUENCE_NUMBER,
568: RESULT_OBTAINED_YR,
569: SCORE_TYPE,

Line 614: from IGS_AD_AUSE_ED_OT_SC

610: X_SCORE in VARCHAR2
611: ) AS
612: cursor c1 is select
613: SCORE
614: from IGS_AD_AUSE_ED_OT_SC
615: where ROWID = X_ROWID for update nowait;
616: tlinfo c1%rowtype;
617:
618: begin

Line 688: update IGS_AD_AUSE_ED_OT_SC set

684: x_last_updated_by=>X_LAST_UPDATED_BY,
685: x_last_update_login=>X_LAST_UPDATE_LOGIN
686: );
687:
688: update IGS_AD_AUSE_ED_OT_SC set
689: SCORE = NEW_REFERENCES.SCORE,
690: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
691: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
692: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 714: cursor c1 is select rowid from IGS_AD_AUSE_ED_OT_SC

710: X_SCORE_TYPE in VARCHAR2,
711: X_SCORE in VARCHAR2,
712: X_MODE in VARCHAR2 default 'R'
713: ) AS
714: cursor c1 is select rowid from IGS_AD_AUSE_ED_OT_SC
715: where PERSON_ID = X_PERSON_ID
716: and ASE_SEQUENCE_NUMBER = X_ASE_SEQUENCE_NUMBER
717: and RESULT_OBTAINED_YR = X_RESULT_OBTAINED_YR
718: and SCORE_TYPE = X_SCORE_TYPE

Line 755: delete from IGS_AD_AUSE_ED_OT_SC

751: Before_DML (
752: p_action => 'DELETE',
753: x_rowid => X_ROWID);
754:
755: delete from IGS_AD_AUSE_ED_OT_SC
756: where ROWID = X_ROWID;
757: if (sql%notfound) then
758: raise no_data_found;
759: end if;

Line 767: end IGS_AD_AUSE_ED_OT_SC_PKG;

763: x_rowid => X_ROWID);
764:
765: end DELETE_ROW;
766:
767: end IGS_AD_AUSE_ED_OT_SC_PKG;