APPS.IGS_FI_HECS_PAY_OPTN_PKG dependencies on IGS_FI_HECS_PAY_OPTN

Line 1: package body IGS_FI_HECS_PAY_OPTN_PKG AS

1: package body IGS_FI_HECS_PAY_OPTN_PKG AS
2: /* $Header: IGSSI54B.pls 115.3 2002/11/29 03:50:52 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_HECS_PAY_OPTN%RowType;
5: new_references IGS_FI_HECS_PAY_OPTN%RowType;

Line 4: old_references IGS_FI_HECS_PAY_OPTN%RowType;

1: package body IGS_FI_HECS_PAY_OPTN_PKG AS
2: /* $Header: IGSSI54B.pls 115.3 2002/11/29 03:50:52 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_HECS_PAY_OPTN%RowType;
5: new_references IGS_FI_HECS_PAY_OPTN%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_HECS_PAY_OPTN%RowType;

1: package body IGS_FI_HECS_PAY_OPTN_PKG AS
2: /* $Header: IGSSI54B.pls 115.3 2002/11/29 03:50:52 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_HECS_PAY_OPTN%RowType;
5: new_references IGS_FI_HECS_PAY_OPTN%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_hecs_payment_option IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_FI_HECS_PAY_OPTN

18: x_last_update_login IN NUMBER DEFAULT NULL
19: ) AS
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_FI_HECS_PAY_OPTN
23: WHERE rowid = x_rowid;
24: BEGIN
25: l_rowid := x_rowid;
26: -- Code for setting the Old and New Reference Values.

Line 119: IGS_AD_CT_HECS_PAYOP_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (

115: END IF;
116: END Check_Parent_Existance;
117: PROCEDURE Check_Child_Existance AS
118: BEGIN
119: IGS_AD_CT_HECS_PAYOP_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
120: old_references.hecs_payment_option
121: );
122: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
123: old_references.hecs_payment_option

Line 122: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (

118: BEGIN
119: IGS_AD_CT_HECS_PAYOP_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
120: old_references.hecs_payment_option
121: );
122: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
123: old_references.hecs_payment_option
124: );
125: IGS_EN_STDNTPSHECSOP_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
126: old_references.hecs_payment_option

Line 125: IGS_EN_STDNTPSHECSOP_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (

121: );
122: IGS_AD_PS_APPL_INST_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
123: old_references.hecs_payment_option
124: );
125: IGS_EN_STDNTPSHECSOP_PKG.GET_FK_IGS_FI_HECS_PAY_OPTN (
126: old_references.hecs_payment_option
127: );
128: END Check_Child_Existance;
129: FUNCTION Get_PK_For_Validation (

Line 134: FROM IGS_FI_HECS_PAY_OPTN

130: x_hecs_payment_option IN VARCHAR2
131: ) RETURN BOOLEAN AS
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM IGS_FI_HECS_PAY_OPTN
135: WHERE hecs_payment_option = x_hecs_payment_option
136: FOR UPDATE NOWAIT;
137: lv_rowid cur_rowid%RowType;
138: BEGIN

Line 154: FROM IGS_FI_HECS_PAY_OPTN

150: x_govt_hecs_payment_option IN VARCHAR2
151: ) AS
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM IGS_FI_HECS_PAY_OPTN
155: WHERE govt_hecs_payment_option = x_govt_hecs_payment_option ;
156: lv_rowid cur_rowid%RowType;
157: BEGIN
158: Open cur_rowid;

Line 240: cursor C is select ROWID from IGS_FI_HECS_PAY_OPTN

236: X_EXPIRE_AFTR_ACDMC_PERD_IND in VARCHAR2,
237: X_CLOSED_IND in VARCHAR2,
238: X_MODE in VARCHAR2 default 'R'
239: ) AS
240: cursor C is select ROWID from IGS_FI_HECS_PAY_OPTN
241: where HECS_PAYMENT_OPTION = X_HECS_PAYMENT_OPTION;
242: X_LAST_UPDATE_DATE DATE;
243: X_LAST_UPDATED_BY NUMBER;
244: X_LAST_UPDATE_LOGIN NUMBER;

Line 278: insert into IGS_FI_HECS_PAY_OPTN (

274: x_last_update_date=>X_LAST_UPDATE_DATE,
275: x_last_updated_by=>X_LAST_UPDATED_BY,
276: x_last_update_login=>X_LAST_UPDATE_LOGIN
277: );
278: insert into IGS_FI_HECS_PAY_OPTN (
279: HECS_PAYMENT_OPTION,
280: GOVT_HECS_PAYMENT_OPTION,
281: DESCRIPTION,
282: EXPIRE_AFTR_ACDMC_PERD_IND,

Line 322: from IGS_FI_HECS_PAY_OPTN

318: GOVT_HECS_PAYMENT_OPTION,
319: DESCRIPTION,
320: EXPIRE_AFTR_ACDMC_PERD_IND,
321: CLOSED_IND
322: from IGS_FI_HECS_PAY_OPTN
323: where ROWID=X_ROWID
324: for update nowait;
325: tlinfo c1%rowtype;
326: begin

Line 397: update IGS_FI_HECS_PAY_OPTN set

393: x_last_update_date=>X_LAST_UPDATE_DATE,
394: x_last_updated_by=>X_LAST_UPDATED_BY,
395: x_last_update_login=>X_LAST_UPDATE_LOGIN
396: );
397: update IGS_FI_HECS_PAY_OPTN set
398: GOVT_HECS_PAYMENT_OPTION = NEW_REFERENCES.GOVT_HECS_PAYMENT_OPTION,
399: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
400: EXPIRE_AFTR_ACDMC_PERD_IND = NEW_REFERENCES.EXPIRE_AFTR_ACDMC_PERD_IND,
401: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 420: cursor c1 is select rowid from IGS_FI_HECS_PAY_OPTN

416: X_EXPIRE_AFTR_ACDMC_PERD_IND in VARCHAR2,
417: X_CLOSED_IND in VARCHAR2,
418: X_MODE in VARCHAR2 default 'R'
419: ) AS
420: cursor c1 is select rowid from IGS_FI_HECS_PAY_OPTN
421: where HECS_PAYMENT_OPTION = X_HECS_PAYMENT_OPTION
422: ;
423: begin
424: open c1;

Line 456: delete from IGS_FI_HECS_PAY_OPTN

452: Before_DML (
453: p_action => 'DELETE',
454: x_rowid => X_ROWID
455: );
456: delete from IGS_FI_HECS_PAY_OPTN
457: where ROWID=X_ROWID;
458: if (sql%notfound) then
459: raise no_data_found;
460: end if;

Line 462: end IGS_FI_HECS_PAY_OPTN_PKG;

458: if (sql%notfound) then
459: raise no_data_found;
460: end if;
461: end DELETE_ROW;
462: end IGS_FI_HECS_PAY_OPTN_PKG;