APPS.IGS_FI_GOV_HEC_PA_OP_PKG dependencies on IGS_FI_GOV_HEC_PA_OP

Line 1: package body IGS_FI_GOV_HEC_PA_OP_PKG AS

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

Line 4: old_references IGS_FI_GOV_HEC_PA_OP%RowType;

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

Line 5: new_references IGS_FI_GOV_HEC_PA_OP%RowType;

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

Line 22: FROM IGS_FI_GOV_HEC_PA_OP

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

Line 129: IGS_FI_FEE_AS_RATE_PKG.GET_FK_IGS_FI_GOV_HEC_PA_OP (

125: END IF;
126: END Check_Parent_Existance;
127: PROCEDURE Check_Child_Existance AS
128: BEGIN
129: IGS_FI_FEE_AS_RATE_PKG.GET_FK_IGS_FI_GOV_HEC_PA_OP (
130: old_references.govt_hecs_payment_option
131: );
132: IGS_FI_HECS_PAY_OPTN_PKG.GET_FK_IGS_FI_GOV_HEC_PA_OP (
133: old_references.govt_hecs_payment_option

Line 132: IGS_FI_HECS_PAY_OPTN_PKG.GET_FK_IGS_FI_GOV_HEC_PA_OP (

128: BEGIN
129: IGS_FI_FEE_AS_RATE_PKG.GET_FK_IGS_FI_GOV_HEC_PA_OP (
130: old_references.govt_hecs_payment_option
131: );
132: IGS_FI_HECS_PAY_OPTN_PKG.GET_FK_IGS_FI_GOV_HEC_PA_OP (
133: old_references.govt_hecs_payment_option
134: );
135: END Check_Child_Existance;
136: FUNCTION Get_PK_For_Validation (

Line 141: FROM IGS_FI_GOV_HEC_PA_OP

137: x_govt_hecs_payment_option IN VARCHAR2
138: ) RETURN BOOLEAN AS
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM IGS_FI_GOV_HEC_PA_OP
142: WHERE govt_hecs_payment_option = x_govt_hecs_payment_option
143: FOR UPDATE NOWAIT;
144: lv_rowid cur_rowid%RowType;
145: BEGIN

Line 161: FROM IGS_FI_GOV_HEC_PA_OP

157: x_s_hecs_payment_type IN VARCHAR2
158: ) AS
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM IGS_FI_GOV_HEC_PA_OP
162: WHERE s_hecs_payment_type = x_s_hecs_payment_type ;
163: lv_rowid cur_rowid%RowType;
164: BEGIN
165: Open cur_rowid;

Line 247: cursor C is select ROWID from IGS_FI_GOV_HEC_PA_OP

243: X_ALLOW_DISCOUNT_IND in VARCHAR2,
244: X_CLOSED_IND in VARCHAR2,
245: X_MODE in VARCHAR2 default 'R'
246: ) AS
247: cursor C is select ROWID from IGS_FI_GOV_HEC_PA_OP
248: where GOVT_HECS_PAYMENT_OPTION = X_GOVT_HECS_PAYMENT_OPTION;
249: X_LAST_UPDATE_DATE DATE;
250: X_LAST_UPDATED_BY NUMBER;
251: X_LAST_UPDATE_LOGIN NUMBER;

Line 285: insert into IGS_FI_GOV_HEC_PA_OP (

281: x_last_update_date=>X_LAST_UPDATE_DATE,
282: x_last_updated_by=>X_LAST_UPDATED_BY,
283: x_last_update_login=>X_LAST_UPDATE_LOGIN
284: );
285: insert into IGS_FI_GOV_HEC_PA_OP (
286: GOVT_HECS_PAYMENT_OPTION,
287: DESCRIPTION,
288: S_HECS_PAYMENT_TYPE,
289: ALLOW_DISCOUNT_IND,

Line 329: from IGS_FI_GOV_HEC_PA_OP

325: DESCRIPTION,
326: S_HECS_PAYMENT_TYPE,
327: ALLOW_DISCOUNT_IND,
328: CLOSED_IND
329: from IGS_FI_GOV_HEC_PA_OP
330: where ROWID=X_ROWID
331: for update nowait;
332: tlinfo c1%rowtype;
333: begin

Line 402: update IGS_FI_GOV_HEC_PA_OP set

398: x_last_update_date=>X_LAST_UPDATE_DATE,
399: x_last_updated_by=>X_LAST_UPDATED_BY,
400: x_last_update_login=>X_LAST_UPDATE_LOGIN
401: );
402: update IGS_FI_GOV_HEC_PA_OP set
403: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
404: S_HECS_PAYMENT_TYPE = NEW_REFERENCES.S_HECS_PAYMENT_TYPE,
405: ALLOW_DISCOUNT_IND = NEW_REFERENCES.ALLOW_DISCOUNT_IND,
406: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 425: cursor c1 is select rowid from IGS_FI_GOV_HEC_PA_OP

421: X_ALLOW_DISCOUNT_IND in VARCHAR2,
422: X_CLOSED_IND in VARCHAR2,
423: X_MODE in VARCHAR2 default 'R'
424: ) AS
425: cursor c1 is select rowid from IGS_FI_GOV_HEC_PA_OP
426: where GOVT_HECS_PAYMENT_OPTION = X_GOVT_HECS_PAYMENT_OPTION
427: ;
428: begin
429: open c1;

Line 461: delete from IGS_FI_GOV_HEC_PA_OP

457: Before_DML (
458: p_action => 'DELETE',
459: x_rowid => X_ROWID
460: );
461: delete from IGS_FI_GOV_HEC_PA_OP
462: where ROWID=X_ROWID;
463: if (sql%notfound) then
464: raise no_data_found;
465: end if;

Line 467: end IGS_FI_GOV_HEC_PA_OP_PKG;

463: if (sql%notfound) then
464: raise no_data_found;
465: end if;
466: end DELETE_ROW;
467: end IGS_FI_GOV_HEC_PA_OP_PKG;