APPS.IGS_AD_AUSE_ED_AS_TY_PKG dependencies on IGS_AD_AUSE_ED_AS_TY

Line 1: package body IGS_AD_AUSE_ED_AS_TY_PKG as

1: package body IGS_AD_AUSE_ED_AS_TY_PKG as
2: /* $Header: IGSAI49B.pls 115.5 2003/10/30 13:13:25 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_AUSE_ED_AS_TY%RowType;

Line 5: old_references IGS_AD_AUSE_ED_AS_TY%RowType;

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

Line 6: new_references IGS_AD_AUSE_ED_AS_TY%RowType;

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

Line 26: FROM IGS_AD_AUSE_ED_AS_TY

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

Line 169: IGS_AS_TYPGOV_SCORMP_PKG.get_fk_igs_ad_ause_ed_as_ty (

165:
166: PROCEDURE Check_Child_Existance AS
167: BEGIN
168:
169: IGS_AS_TYPGOV_SCORMP_PKG.get_fk_igs_ad_ause_ed_as_ty (
170: old_references.aus_scndry_edu_ass_type
171: );
172:
173: IGS_AD_AUS_SEC_EDU_PKG.get_fk_igs_ad_ause_ed_as_ty (

Line 173: IGS_AD_AUS_SEC_EDU_PKG.get_fk_igs_ad_ause_ed_as_ty (

169: IGS_AS_TYPGOV_SCORMP_PKG.get_fk_igs_ad_ause_ed_as_ty (
170: old_references.aus_scndry_edu_ass_type
171: );
172:
173: IGS_AD_AUS_SEC_EDU_PKG.get_fk_igs_ad_ause_ed_as_ty (
174: old_references.aus_scndry_edu_ass_type
175: );
176:
177: IGS_AD_AUS_SEC_ED_SU_PKG.get_fk_igs_ad_ause_ed_as_ty (

Line 177: IGS_AD_AUS_SEC_ED_SU_PKG.get_fk_igs_ad_ause_ed_as_ty (

173: IGS_AD_AUS_SEC_EDU_PKG.get_fk_igs_ad_ause_ed_as_ty (
174: old_references.aus_scndry_edu_ass_type
175: );
176:
177: IGS_AD_AUS_SEC_ED_SU_PKG.get_fk_igs_ad_ause_ed_as_ty (
178: old_references.aus_scndry_edu_ass_type
179: );
180:
181: END Check_Child_Existance;

Line 189: FROM IGS_AD_AUSE_ED_AS_TY

185: x_closed_ind IN VARCHAR2
186: )return BOOLEAN AS
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM IGS_AD_AUSE_ED_AS_TY
190: WHERE aus_scndry_edu_ass_type = x_aus_scndry_edu_ass_type AND
191: closed_ind = NVL(x_closed_ind,closed_ind)
192: FOR UPDATE NOWAIT;
193: lv_rowid cur_rowid%RowType;

Line 213: FROM IGS_AD_AUSE_ED_AS_TY

209: ) AS
210:
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM IGS_AD_AUSE_ED_AS_TY
214: WHERE tac_aus_scndry_edu_ass_type = x_tac_aus_scndry_edu_ass_type ;
215:
216: lv_rowid cur_rowid%RowType;
217:

Line 319: cursor C is select ROWID from IGS_AD_AUSE_ED_AS_TY

315: X_GOVT_REPORTED_IND in VARCHAR2,
316: X_CLOSED_IND in VARCHAR2,
317: X_MODE in VARCHAR2 default 'R'
318: ) AS
319: cursor C is select ROWID from IGS_AD_AUSE_ED_AS_TY
320: where AUS_SCNDRY_EDU_ASS_TYPE = X_AUS_SCNDRY_EDU_ASS_TYPE;
321: X_LAST_UPDATE_DATE DATE;
322: X_LAST_UPDATED_BY NUMBER;
323: X_LAST_UPDATE_LOGIN NUMBER;

Line 360: insert into IGS_AD_AUSE_ED_AS_TY (

356: x_last_updated_by=>X_LAST_UPDATED_BY,
357: x_last_update_login=>X_LAST_UPDATE_LOGIN
358: );
359:
360: insert into IGS_AD_AUSE_ED_AS_TY (
361: AUS_SCNDRY_EDU_ASS_TYPE,
362: DESCRIPTION,
363: TAC_AUS_SCNDRY_EDU_ASS_TYPE,
364: STATE_CD,

Line 415: from IGS_AD_AUSE_ED_AS_TY

411: TAC_AUS_SCNDRY_EDU_ASS_TYPE,
412: STATE_CD,
413: GOVT_REPORTED_IND,
414: CLOSED_IND
415: from IGS_AD_AUSE_ED_AS_TY
416: where ROWID = X_ROWID for update nowait;
417: tlinfo c1%rowtype;
418:
419: begin

Line 499: update IGS_AD_AUSE_ED_AS_TY set

495: x_last_updated_by=>X_LAST_UPDATED_BY,
496: x_last_update_login=>X_LAST_UPDATE_LOGIN
497: );
498:
499: update IGS_AD_AUSE_ED_AS_TY set
500: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
501: TAC_AUS_SCNDRY_EDU_ASS_TYPE = NEW_REFERENCES.TAC_AUS_SCNDRY_EDU_ASS_TYPE,
502: STATE_CD = NEW_REFERENCES.STATE_CD,
503: GOVT_REPORTED_IND = NEW_REFERENCES.GOVT_REPORTED_IND,

Line 530: cursor c1 is select rowid from IGS_AD_AUSE_ED_AS_TY

526: X_GOVT_REPORTED_IND in VARCHAR2,
527: X_CLOSED_IND in VARCHAR2,
528: X_MODE in VARCHAR2 default 'R'
529: ) AS
530: cursor c1 is select rowid from IGS_AD_AUSE_ED_AS_TY
531: where AUS_SCNDRY_EDU_ASS_TYPE = X_AUS_SCNDRY_EDU_ASS_TYPE
532: ;
533: begin
534: open c1;

Line 570: delete from IGS_AD_AUSE_ED_AS_TY

566: Before_DML (
567: p_action => 'DELETE',
568: x_rowid => X_ROWID);
569:
570: delete from IGS_AD_AUSE_ED_AS_TY
571: where ROWID = X_ROWID;
572: if (sql%notfound) then
573: raise no_data_found;
574: end if;

Line 582: end IGS_AD_AUSE_ED_AS_TY_PKG;

578: x_rowid => X_ROWID);
579:
580: end DELETE_ROW;
581:
582: end IGS_AD_AUSE_ED_AS_TY_PKG;