APPS.IGS_AD_AUS_SEC_ED_SU_PKG dependencies on IGS_AD_AUS_SEC_ED_SU

Line 1: package body IGS_AD_AUS_SEC_ED_SU_PKG as

1: package body IGS_AD_AUS_SEC_ED_SU_PKG as
2: /* $Header: IGSAI68B.pls 115.5 2003/10/30 13:21:55 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUS_SEC_ED_SU%RowType;

Line 5: old_references IGS_AD_AUS_SEC_ED_SU%RowType;

1: package body IGS_AD_AUS_SEC_ED_SU_PKG as
2: /* $Header: IGSAI68B.pls 115.5 2003/10/30 13:21:55 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUS_SEC_ED_SU%RowType;
6: new_references IGS_AD_AUS_SEC_ED_SU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_AUS_SEC_ED_SU%RowType;

2: /* $Header: IGSAI68B.pls 115.5 2003/10/30 13:21:55 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUS_SEC_ED_SU%RowType;
6: new_references IGS_AD_AUS_SEC_ED_SU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 30: FROM IGS_AD_AUS_SEC_ED_SU

26: ) AS
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_AD_AUS_SEC_ED_SU
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:

Line 202: FROM IGS_AD_AUS_SEC_ED_SU

198: )return BOOLEAN AS
199:
200: CURSOR cur_rowid IS
201: SELECT rowid
202: FROM IGS_AD_AUS_SEC_ED_SU
203: WHERE person_id = x_person_id
204: AND ase_sequence_number = x_ase_sequence_number
205: AND subject_result_yr = x_subject_result_yr
206: AND subject_cd = x_subject_cd

Line 231: FROM IGS_AD_AUS_SEC_ED_SU

227: ) AS
228:
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM IGS_AD_AUS_SEC_ED_SU
232: WHERE subject_ass_type = x_aus_scndry_edu_ass_type ;
233:
234: lv_rowid cur_rowid%RowType;
235:

Line 258: FROM IGS_AD_AUS_SEC_ED_SU

254: ) AS
255:
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM IGS_AD_AUS_SEC_ED_SU
259: WHERE person_id = x_person_id
260: AND ase_sequence_number = x_sequence_number ;
261:
262: lv_rowid cur_rowid%RowType;

Line 378: cursor C is select ROWID from IGS_AD_AUS_SEC_ED_SU

374: X_SUBJECT_ASS_TYPE in VARCHAR2,
375: X_NOTES in VARCHAR2,
376: X_MODE in VARCHAR2 default 'R'
377: ) AS
378: cursor C is select ROWID from IGS_AD_AUS_SEC_ED_SU
379: where PERSON_ID = X_PERSON_ID
380: and ASE_SEQUENCE_NUMBER = X_ASE_SEQUENCE_NUMBER
381: and SUBJECT_RESULT_YR = X_SUBJECT_RESULT_YR
382: and SUBJECT_CD = X_SUBJECT_CD;

Line 441: insert into IGS_AD_AUS_SEC_ED_SU (

437: x_last_updated_by=>X_LAST_UPDATED_BY,
438: x_last_update_login=>X_LAST_UPDATE_LOGIN
439: );
440:
441: insert into IGS_AD_AUS_SEC_ED_SU (
442: PERSON_ID,
443: ASE_SEQUENCE_NUMBER,
444: SUBJECT_RESULT_YR,
445: SUBJECT_CD,

Line 517: from IGS_AD_AUS_SEC_ED_SU

513: SUBJECT_MARK_LEVEL,
514: SUBJECT_WEIGHTING,
515: SUBJECT_ASS_TYPE,
516: NOTES
517: from IGS_AD_AUS_SEC_ED_SU
518: where ROWID = X_ROWID for update nowait;
519: tlinfo c1%rowtype;
520:
521: begin

Line 635: update IGS_AD_AUS_SEC_ED_SU set

631: else
632: X_PROGRAM_UPDATE_DATE := SYSDATE;
633: end if;
634: end if;
635: update IGS_AD_AUS_SEC_ED_SU set
636: SUBJECT_DESC = NEW_REFERENCES.SUBJECT_DESC,
637: SUBJECT_MARK = NEW_REFERENCES.SUBJECT_MARK,
638: SUBJECT_MARK_LEVEL = NEW_REFERENCES.SUBJECT_MARK_LEVEL,
639: SUBJECT_WEIGHTING = NEW_REFERENCES.SUBJECT_WEIGHTING,

Line 676: cursor c1 is select rowid from IGS_AD_AUS_SEC_ED_SU

672: X_SUBJECT_ASS_TYPE in VARCHAR2,
673: X_NOTES in VARCHAR2,
674: X_MODE in VARCHAR2 default 'R'
675: ) AS
676: cursor c1 is select rowid from IGS_AD_AUS_SEC_ED_SU
677: where PERSON_ID = X_PERSON_ID
678: and ASE_SEQUENCE_NUMBER = X_ASE_SEQUENCE_NUMBER
679: and SUBJECT_RESULT_YR = X_SUBJECT_RESULT_YR
680: and SUBJECT_CD = X_SUBJECT_CD

Line 727: delete from IGS_AD_AUS_SEC_ED_SU

723: Before_DML (
724: p_action => 'DELETE',
725: x_rowid => X_ROWID);
726:
727: delete from IGS_AD_AUS_SEC_ED_SU
728: where ROWID = X_ROWID;
729: if (sql%notfound) then
730: raise no_data_found;
731: end if;

Line 738: end IGS_AD_AUS_SEC_ED_SU_PKG;

734: p_action => 'DELETE',
735: x_rowid => X_ROWID);
736: end DELETE_ROW;
737:
738: end IGS_AD_AUS_SEC_ED_SU_PKG;