APPS.IGS_AD_OS_SEC_EDU_QF_PKG dependencies on IGS_AD_OS_SEC_EDU_QF

Line 1: package body IGS_AD_OS_SEC_EDU_QF_PKG as

1: package body IGS_AD_OS_SEC_EDU_QF_PKG as
2: /* $Header: IGSAI41B.pls 115.4 2003/10/30 13:12:50 akadam ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_AD_OS_SEC_EDU_QF%RowType;

2: /* $Header: IGSAI41B.pls 115.4 2003/10/30 13:12:50 akadam ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AD_OS_SEC_EDU_QF%RowType;
7: new_references IGS_AD_OS_SEC_EDU_QF%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_AD_OS_SEC_EDU_QF%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AD_OS_SEC_EDU_QF%RowType;
7: new_references IGS_AD_OS_SEC_EDU_QF%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_AD_OS_SEC_EDU_QF

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

Line 124: IGS_AD_OS_SEC_EDU_PKG.GET_FK_IGS_AD_OS_SEC_EDU_QF (

120:
121: PROCEDURE Check_Child_Existance as
122: BEGIN
123:
124: IGS_AD_OS_SEC_EDU_PKG.GET_FK_IGS_AD_OS_SEC_EDU_QF (
125: old_references.os_scndry_edu_qualification
126: );
127:
128: END Check_Child_Existance;

Line 137: FROM IGS_AD_OS_SEC_EDU_QF

133: )return BOOLEAN as
134:
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM IGS_AD_OS_SEC_EDU_QF
138: WHERE os_scndry_edu_qualification = x_os_scndry_edu_qualification AND
139: closed_ind = NVL(x_closed_ind,closed_ind)
140: FOR UPDATE NOWAIT;
141:

Line 164: FROM IGS_AD_OS_SEC_EDU_QF

160: ) as
161:
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM IGS_AD_OS_SEC_EDU_QF
165: WHERE country_cd = x_country_cd ;
166:
167: lv_rowid cur_rowid%RowType;
168:

Line 264: cursor C is select ROWID from IGS_AD_OS_SEC_EDU_QF

260: X_COUNTRY_CD in VARCHAR2,
261: X_CLOSED_IND in VARCHAR2,
262: X_MODE in VARCHAR2 default 'R'
263: ) as
264: cursor C is select ROWID from IGS_AD_OS_SEC_EDU_QF
265: where OS_SCNDRY_EDU_QUALIFICATION = X_OS_SCNDRY_EDU_QUALIFICATION;
266: X_LAST_UPDATE_DATE DATE;
267: X_LAST_UPDATED_BY NUMBER;
268: X_LAST_UPDATE_LOGIN NUMBER;

Line 304: insert into IGS_AD_OS_SEC_EDU_QF (

300: x_last_update_login=> X_LAST_UPDATE_LOGIN
301: );
302:
303:
304: insert into IGS_AD_OS_SEC_EDU_QF (
305: OS_SCNDRY_EDU_QUALIFICATION,
306: DESCRIPTION,
307: COUNTRY_CD,
308: CLOSED_IND,

Line 353: from IGS_AD_OS_SEC_EDU_QF

349: cursor c1 is select
350: DESCRIPTION,
351: COUNTRY_CD,
352: CLOSED_IND
353: from IGS_AD_OS_SEC_EDU_QF
354: WHERE ROWID = X_ROWID for update nowait ;
355: tlinfo c1%rowtype;
356:
357: begin

Line 430: update IGS_AD_OS_SEC_EDU_QF set

426: x_last_update_login=> X_LAST_UPDATE_LOGIN
427: );
428:
429:
430: update IGS_AD_OS_SEC_EDU_QF set
431: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
432: COUNTRY_CD = NEW_REFERENCES.COUNTRY_CD,
433: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
434: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 458: cursor c1 is select rowid from IGS_AD_OS_SEC_EDU_QF

454: X_COUNTRY_CD in VARCHAR2,
455: X_CLOSED_IND in VARCHAR2,
456: X_MODE in VARCHAR2 default 'R'
457: ) as
458: cursor c1 is select rowid from IGS_AD_OS_SEC_EDU_QF
459: where OS_SCNDRY_EDU_QUALIFICATION = X_OS_SCNDRY_EDU_QUALIFICATION
460: ;
461:
462: begin

Line 496: delete from IGS_AD_OS_SEC_EDU_QF

492: p_action=>'DELETE',
493: x_rowid=> X_ROWID
494: );
495:
496: delete from IGS_AD_OS_SEC_EDU_QF
497: where ROWID = X_ROWID;
498: if (sql%notfound) then
499: raise no_data_found;
500: end if;

Line 510: end IGS_AD_OS_SEC_EDU_QF_PKG;

506:
507:
508: end DELETE_ROW;
509:
510: end IGS_AD_OS_SEC_EDU_QF_PKG;