APPS.IGS_AD_CT_HECS_PAYOP_PKG dependencies on IGS_AD_CT_HECS_PAYOP

Line 1: package body IGS_AD_CT_HECS_PAYOP_PKG AS

1: package body IGS_AD_CT_HECS_PAYOP_PKG AS
2: /* $Header: IGSAI14B.pls 115.6 2003/10/30 13:19:08 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CT_HECS_PAYOP%RowType;

Line 5: old_references IGS_AD_CT_HECS_PAYOP%RowType;

1: package body IGS_AD_CT_HECS_PAYOP_PKG AS
2: /* $Header: IGSAI14B.pls 115.6 2003/10/30 13:19:08 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CT_HECS_PAYOP%RowType;
6: new_references IGS_AD_CT_HECS_PAYOP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_CT_HECS_PAYOP%RowType;

2: /* $Header: IGSAI14B.pls 115.6 2003/10/30 13:19:08 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_CT_HECS_PAYOP%RowType;
6: new_references IGS_AD_CT_HECS_PAYOP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_AD_CT_HECS_PAYOP

18: ) AS
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AD_CT_HECS_PAYOP
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 148: FROM IGS_AD_CT_HECS_PAYOP

144: x_hecs_payment_option IN VARCHAR2)
145: RETURN BOOLEAN AS
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM IGS_AD_CT_HECS_PAYOP
149: WHERE admission_cat = x_admission_cat
150: AND hecs_payment_option = x_hecs_payment_option
151: FOR UPDATE NOWAIT;
152: lv_rowid cur_rowid%RowType;

Line 171: FROM IGS_AD_CT_HECS_PAYOP

167: ) AS
168:
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM IGS_AD_CT_HECS_PAYOP
172: WHERE admission_cat = x_admission_cat ;
173:
174: lv_rowid cur_rowid%RowType;
175:

Line 197: FROM IGS_AD_CT_HECS_PAYOP

193: ) AS
194:
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM IGS_AD_CT_HECS_PAYOP
198: WHERE hecs_payment_option = x_hecs_payment_option ;
199:
200: lv_rowid cur_rowid%RowType;
201:

Line 300: cursor C is select ROWID from IGS_AD_CT_HECS_PAYOP

296: X_ADMISSION_CAT in VARCHAR2,
297: X_HECS_PAYMENT_OPTION in VARCHAR2,
298: X_MODE in VARCHAR2 default 'R'
299: ) AS
300: cursor C is select ROWID from IGS_AD_CT_HECS_PAYOP
301: where ADMISSION_CAT = X_ADMISSION_CAT
302: and HECS_PAYMENT_OPTION = X_HECS_PAYMENT_OPTION;
303: X_LAST_UPDATE_DATE DATE;
304: X_LAST_UPDATED_BY NUMBER;

Line 338: insert into IGS_AD_CT_HECS_PAYOP (

334: x_last_updated_by=>X_LAST_UPDATED_BY,
335: x_last_update_login=>X_LAST_UPDATE_LOGIN
336: );
337:
338: insert into IGS_AD_CT_HECS_PAYOP (
339: ADMISSION_CAT,
340: HECS_PAYMENT_OPTION,
341: CREATION_DATE,
342: CREATED_BY,

Line 376: from IGS_AD_CT_HECS_PAYOP

372: X_ADMISSION_CAT in VARCHAR2,
373: X_HECS_PAYMENT_OPTION in VARCHAR2
374: ) AS
375: cursor c1 is select ROWID
376: from IGS_AD_CT_HECS_PAYOP
377: where ROWID = X_ROWID for update nowait;
378: tlinfo c1%rowtype;
379:
380: begin

Line 404: delete from IGS_AD_CT_HECS_PAYOP

400: Before_DML (
401: p_action => 'DELETE',
402: x_rowid => X_ROWID);
403:
404: delete from IGS_AD_CT_HECS_PAYOP
405: where ROWID = X_ROWID;
406: if (sql%notfound) then
407: raise no_data_found;
408: end if;

Line 416: end IGS_AD_CT_HECS_PAYOP_PKG;

412: x_rowid => X_ROWID);
413:
414: end DELETE_ROW;
415:
416: end IGS_AD_CT_HECS_PAYOP_PKG;