APPS.IGS_FI_GOVT_FUND_SRC_PKG dependencies on IGS_FI_GOVT_FUND_SRC

Line 1: package body IGS_FI_GOVT_FUND_SRC_PKG AS

1: package body IGS_FI_GOVT_FUND_SRC_PKG AS
2: /* $Header: IGSSI50B.pls 115.3 2002/11/29 03:49:40 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_GOVT_FUND_SRC%RowType;
5: new_references IGS_FI_GOVT_FUND_SRC%RowType;

Line 4: old_references IGS_FI_GOVT_FUND_SRC%RowType;

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

Line 5: new_references IGS_FI_GOVT_FUND_SRC%RowType;

1: package body IGS_FI_GOVT_FUND_SRC_PKG AS
2: /* $Header: IGSSI50B.pls 115.3 2002/11/29 03:49:40 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_GOVT_FUND_SRC%RowType;
5: new_references IGS_FI_GOVT_FUND_SRC%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_govt_funding_source IN NUMBER DEFAULT NULL,

Line 20: FROM IGS_FI_GOVT_FUND_SRC

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

Line 53: -- ON IGS_FI_GOVT_FUND_SRC

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

Line 95: IGS_FI_FUND_SRC_PKG.GET_FK_IGS_FI_GOVT_FUND_SRC (

91: END IF;
92: END Check_Constraints;
93: PROCEDURE Check_Child_Existance AS
94: BEGIN
95: IGS_FI_FUND_SRC_PKG.GET_FK_IGS_FI_GOVT_FUND_SRC (
96: old_references.GOVT_FUNDING_SOURCE
97: );
98: END Check_Child_Existance;
99: FUNCTION Get_PK_For_Validation (

Line 104: FROM IGS_FI_GOVT_FUND_SRC

100: x_govt_funding_source IN NUMBER
101: ) RETURN BOOLEAN AS
102: CURSOR cur_rowid IS
103: SELECT rowid
104: FROM IGS_FI_GOVT_FUND_SRC
105: WHERE govt_funding_source = x_govt_funding_source
106: FOR UPDATE NOWAIT;
107: lv_rowid cur_rowid%RowType;
108: BEGIN

Line 184: cursor C is select ROWID from IGS_FI_GOVT_FUND_SRC

180: X_DESCRIPTION in VARCHAR2,
181: X_CLOSED_IND in VARCHAR2,
182: X_MODE in VARCHAR2 default 'R'
183: ) AS
184: cursor C is select ROWID from IGS_FI_GOVT_FUND_SRC
185: where GOVT_FUNDING_SOURCE = X_GOVT_FUNDING_SOURCE;
186: X_LAST_UPDATE_DATE DATE;
187: X_LAST_UPDATED_BY NUMBER;
188: X_LAST_UPDATE_LOGIN NUMBER;

Line 220: insert into IGS_FI_GOVT_FUND_SRC (

216: x_last_update_date=>X_LAST_UPDATE_DATE,
217: x_last_updated_by=>X_LAST_UPDATED_BY,
218: x_last_update_login=>X_LAST_UPDATE_LOGIN
219: );
220: insert into IGS_FI_GOVT_FUND_SRC (
221: GOVT_FUNDING_SOURCE,
222: DESCRIPTION,
223: CLOSED_IND,
224: CREATION_DATE,

Line 256: from IGS_FI_GOVT_FUND_SRC

252: ) AS
253: cursor c1 is select
254: DESCRIPTION,
255: CLOSED_IND
256: from IGS_FI_GOVT_FUND_SRC
257: where ROWID=X_ROWID
258: for update nowait;
259: tlinfo c1%rowtype;
260: begin

Line 323: update IGS_FI_GOVT_FUND_SRC set

319: x_last_update_date=>X_LAST_UPDATE_DATE,
320: x_last_updated_by=>X_LAST_UPDATED_BY,
321: x_last_update_login=>X_LAST_UPDATE_LOGIN
322: );
323: update IGS_FI_GOVT_FUND_SRC set
324: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
325: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
326: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
327: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 342: cursor c1 is select rowid from IGS_FI_GOVT_FUND_SRC

338: X_DESCRIPTION in VARCHAR2,
339: X_CLOSED_IND in VARCHAR2,
340: X_MODE in VARCHAR2 default 'R'
341: ) AS
342: cursor c1 is select rowid from IGS_FI_GOVT_FUND_SRC
343: where GOVT_FUNDING_SOURCE = X_GOVT_FUNDING_SOURCE
344: ;
345: begin
346: open c1;

Line 374: delete from IGS_FI_GOVT_FUND_SRC

370: Before_DML (
371: p_action => 'DELETE',
372: x_rowid => X_ROWID
373: );
374: delete from IGS_FI_GOVT_FUND_SRC
375: where ROWID=X_ROWID;
376: if (sql%notfound) then
377: raise no_data_found;
378: end if;

Line 380: end IGS_FI_GOVT_FUND_SRC_PKG;

376: if (sql%notfound) then
377: raise no_data_found;
378: end if;
379: end DELETE_ROW;
380: end IGS_FI_GOVT_FUND_SRC_PKG;