eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_GV_DSP_HEC_CN_PKG dependencies on IGS_FI_GV_DSP_HEC_CN

Line 1: package body IGS_FI_GV_DSP_HEC_CN_PKG AS

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

Line 4: old_references IGS_FI_GV_DSP_HEC_CN%RowType;

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

Line 5: new_references IGS_FI_GV_DSP_HEC_CN%RowType;

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

Line 21: FROM IGS_FI_GV_DSP_HEC_CN

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

Line 55: -- ON IGS_FI_GV_DSP_HEC_CN

51: new_references.last_update_login := x_last_update_login;
52: END Set_Column_Values;
53: -- Trigger description :-
54: -- BEFORE INSERT OR UPDATE
55: -- ON IGS_FI_GV_DSP_HEC_CN
56: -- FOR EACH ROW
57: PROCEDURE BeforeRowInsertUpdate1(
58: p_inserting IN BOOLEAN DEFAULT FALSE,
59: p_updating IN BOOLEAN DEFAULT FALSE,

Line 87: -- ON IGS_FI_GV_DSP_HEC_CN

83: END IF;
84: END BeforeRowInsertUpdate1;
85: -- Trigger description :-
86: -- AFTER INSERT OR UPDATE
87: -- ON IGS_FI_GV_DSP_HEC_CN
88: PROCEDURE AfterStmtInsertUpdate3(
89: p_inserting IN BOOLEAN DEFAULT FALSE,
90: p_updating IN BOOLEAN DEFAULT FALSE,
91: p_deleting IN BOOLEAN DEFAULT FALSE

Line 181: FROM IGS_FI_GV_DSP_HEC_CN

177: x_start_dt IN DATE
178: ) RETURN BOOLEAN AS
179: CURSOR cur_rowid IS
180: SELECT rowid
181: FROM IGS_FI_GV_DSP_HEC_CN
182: WHERE govt_discipline_group_cd = x_govt_discipline_group_cd
183: AND govt_hecs_cntrbtn_band = x_govt_hecs_cntrbtn_band
184: AND start_dt = x_start_dt
185: FOR UPDATE NOWAIT;

Line 204: FROM IGS_FI_GV_DSP_HEC_CN

200: x_start_dt IN DATE
201: ) RETURN BOOLEAN AS
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM IGS_FI_GV_DSP_HEC_CN
205: WHERE govt_discipline_group_cd = x_govt_discipline_group_cd
206: AND start_dt = x_start_dt
207: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
208: FOR UPDATE NOWAIT;

Line 226: FROM IGS_FI_GV_DSP_HEC_CN

222: x_govt_discipline_group_cd IN VARCHAR2
223: ) AS
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM IGS_FI_GV_DSP_HEC_CN
227: WHERE govt_discipline_group_cd = x_govt_discipline_group_cd ;
228: lv_rowid cur_rowid%RowType;
229: BEGIN
230: Open cur_rowid;

Line 246: FROM IGS_FI_GV_DSP_HEC_CN

242: x_govt_hecs_cntrbtn_band IN NUMBER
243: ) AS
244: CURSOR cur_rowid IS
245: SELECT rowid
246: FROM IGS_FI_GV_DSP_HEC_CN
247: WHERE govt_hecs_cntrbtn_band = x_govt_hecs_cntrbtn_band ;
248: lv_rowid cur_rowid%RowType;
249: BEGIN
250: Open cur_rowid;

Line 351: cursor C is select ROWID from IGS_FI_GV_DSP_HEC_CN

347: X_START_DT in DATE,
348: X_END_DT in DATE,
349: X_MODE in VARCHAR2 default 'R'
350: ) AS
351: cursor C is select ROWID from IGS_FI_GV_DSP_HEC_CN
352: where GOVT_DISCIPLINE_GROUP_CD = X_GOVT_DISCIPLINE_GROUP_CD
353: and GOVT_HECS_CNTRBTN_BAND = X_GOVT_HECS_CNTRBTN_BAND
354: and START_DT = X_START_DT;
355: X_LAST_UPDATE_DATE DATE;

Line 390: insert into IGS_FI_GV_DSP_HEC_CN (

386: x_last_update_date=>X_LAST_UPDATE_DATE,
387: x_last_updated_by=>X_LAST_UPDATED_BY,
388: x_last_update_login=>X_LAST_UPDATE_LOGIN
389: );
390: insert into IGS_FI_GV_DSP_HEC_CN (
391: GOVT_DISCIPLINE_GROUP_CD,
392: GOVT_HECS_CNTRBTN_BAND,
393: START_DT,
394: END_DT,

Line 432: from IGS_FI_GV_DSP_HEC_CN

428: X_END_DT in DATE
429: ) AS
430: cursor c1 is select
431: END_DT
432: from IGS_FI_GV_DSP_HEC_CN
433: where ROWID=X_ROWID
434: for update nowait;
435: tlinfo c1%rowtype;
436: begin

Line 502: update IGS_FI_GV_DSP_HEC_CN set

498: x_last_update_date=>X_LAST_UPDATE_DATE,
499: x_last_updated_by=>X_LAST_UPDATED_BY,
500: x_last_update_login=>X_LAST_UPDATE_LOGIN
501: );
502: update IGS_FI_GV_DSP_HEC_CN set
503: END_DT = NEW_REFERENCES.END_DT,
504: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
505: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
506: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 525: cursor c1 is select rowid from IGS_FI_GV_DSP_HEC_CN

521: X_START_DT in DATE,
522: X_END_DT in DATE,
523: X_MODE in VARCHAR2 default 'R'
524: ) AS
525: cursor c1 is select rowid from IGS_FI_GV_DSP_HEC_CN
526: where GOVT_DISCIPLINE_GROUP_CD = X_GOVT_DISCIPLINE_GROUP_CD
527: and GOVT_HECS_CNTRBTN_BAND = X_GOVT_HECS_CNTRBTN_BAND
528: and START_DT = X_START_DT
529: ;

Line 561: delete from IGS_FI_GV_DSP_HEC_CN

557: BEFORE_DML (
558: p_action => 'DELETE',
559: x_rowid => X_ROWID
560: );
561: delete from IGS_FI_GV_DSP_HEC_CN
562: where ROWID=X_ROWID;
563: if (sql%notfound) then
564: raise no_data_found;
565: end if;

Line 567: end IGS_FI_GV_DSP_HEC_CN_PKG;

563: if (sql%notfound) then
564: raise no_data_found;
565: end if;
566: end DELETE_ROW;
567: end IGS_FI_GV_DSP_HEC_CN_PKG;