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.

APPS.IGS_FI_FUND_SRC_PKG dependencies on IGS_FI_FUND_SRC_ALL

Line 4: old_references IGS_FI_FUND_SRC_ALL%RowType;

1: package body IGS_FI_FUND_SRC_PKG AS
2: /* $Header: IGSSI42B.pls 115.9 2003/01/06 15:18:02 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FUND_SRC_ALL%RowType;
5: new_references IGS_FI_FUND_SRC_ALL%RowType;
6: PROCEDURE beforerowdelete;
7:
8: PROCEDURE Set_Column_Values (

Line 5: new_references IGS_FI_FUND_SRC_ALL%RowType;

1: package body IGS_FI_FUND_SRC_PKG AS
2: /* $Header: IGSSI42B.pls 115.9 2003/01/06 15:18:02 smvk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FUND_SRC_ALL%RowType;
5: new_references IGS_FI_FUND_SRC_ALL%RowType;
6: PROCEDURE beforerowdelete;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 24: FROM IGS_FI_FUND_SRC_ALL

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

Line 61: -- ON IGS_FI_FUND_SRC_ALL

57:
58: -- Trigger description :-
59: -- "OSS_TST".trg_fs_br_iud
60: -- BEFORE INSERT OR DELETE OR UPDATE
61: -- ON IGS_FI_FUND_SRC_ALL
62: -- FOR EACH ROW
63: PROCEDURE BeforeRowInsertUpdateDelete1(
64: p_inserting IN BOOLEAN DEFAULT FALSE,
65: p_updating IN BOOLEAN DEFAULT FALSE,

Line 69: v_description IGS_FI_FUND_SRC_ALL.description%TYPE;

65: p_updating IN BOOLEAN DEFAULT FALSE,
66: p_deleting IN BOOLEAN DEFAULT FALSE
67: ) AS
68: v_message_name varchar2(30);
69: v_description IGS_FI_FUND_SRC_ALL.description%TYPE;
70: v_govt_funding_source IGS_FI_FUND_SRC_ALL.govt_funding_source%TYPE;
71: v_closed_ind IGS_FI_FUND_SRC_ALL.closed_ind%TYPE;
72: lv_org_id IGS_FI_FUND_SRC_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
73: x_rowid VARCHAR2(25);

Line 70: v_govt_funding_source IGS_FI_FUND_SRC_ALL.govt_funding_source%TYPE;

66: p_deleting IN BOOLEAN DEFAULT FALSE
67: ) AS
68: v_message_name varchar2(30);
69: v_description IGS_FI_FUND_SRC_ALL.description%TYPE;
70: v_govt_funding_source IGS_FI_FUND_SRC_ALL.govt_funding_source%TYPE;
71: v_closed_ind IGS_FI_FUND_SRC_ALL.closed_ind%TYPE;
72: lv_org_id IGS_FI_FUND_SRC_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
73: x_rowid VARCHAR2(25);
74: CURSOR SFFSH_CUR IS

Line 71: v_closed_ind IGS_FI_FUND_SRC_ALL.closed_ind%TYPE;

67: ) AS
68: v_message_name varchar2(30);
69: v_description IGS_FI_FUND_SRC_ALL.description%TYPE;
70: v_govt_funding_source IGS_FI_FUND_SRC_ALL.govt_funding_source%TYPE;
71: v_closed_ind IGS_FI_FUND_SRC_ALL.closed_ind%TYPE;
72: lv_org_id IGS_FI_FUND_SRC_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
73: x_rowid VARCHAR2(25);
74: CURSOR SFFSH_CUR IS
75: SELECT Rowid

Line 211: FROM IGS_FI_FUND_SRC_ALL

207: x_funding_source IN VARCHAR2
208: ) RETURN BOOLEAN AS
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM IGS_FI_FUND_SRC_ALL
212: WHERE funding_source = x_funding_source;
213: lv_rowid cur_rowid%RowType;
214: BEGIN
215: Open cur_rowid;

Line 231: FROM IGS_FI_FUND_SRC_ALL

227: x_govt_funding_source IN NUMBER
228: ) AS
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM IGS_FI_FUND_SRC_ALL
232: WHERE govt_funding_source = x_govt_funding_source ;
233: lv_rowid cur_rowid%RowType;
234: BEGIN
235: Open cur_rowid;

Line 326: cursor C is select ROWID from IGS_FI_FUND_SRC_ALL

322: --Who when What
323: --sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id in call to
324: -- before_dml as part of SWCR006 build.
325: ---------------------------------------------------------------------------------------*/
326: cursor C is select ROWID from IGS_FI_FUND_SRC_ALL
327: where FUNDING_SOURCE = X_FUNDING_SOURCE;
328: X_LAST_UPDATE_DATE DATE;
329: X_LAST_UPDATED_BY NUMBER;
330: X_LAST_UPDATE_LOGIN NUMBER;

Line 364: insert into IGS_FI_FUND_SRC_ALL (

360: x_last_update_date=>X_LAST_UPDATE_DATE,
361: x_last_updated_by=>X_LAST_UPDATED_BY,
362: x_last_update_login=>X_LAST_UPDATE_LOGIN
363: );
364: insert into IGS_FI_FUND_SRC_ALL (
365: FUNDING_SOURCE,
366: DESCRIPTION,
367: GOVT_FUNDING_SOURCE,
368: CLOSED_IND,

Line 407: from IGS_FI_FUND_SRC_ALL

403: cursor c1 is select
404: DESCRIPTION,
405: GOVT_FUNDING_SOURCE,
406: CLOSED_IND
407: from IGS_FI_FUND_SRC_ALL
408: where ROWID=X_ROWID
409: for update nowait;
410: tlinfo c1%rowtype;
411: begin

Line 479: update IGS_FI_FUND_SRC_ALL set

475: x_last_update_date=>X_LAST_UPDATE_DATE,
476: x_last_updated_by=>X_LAST_UPDATED_BY,
477: x_last_update_login=>X_LAST_UPDATE_LOGIN
478: );
479: update IGS_FI_FUND_SRC_ALL set
480: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
481: GOVT_FUNDING_SOURCE = NEW_REFERENCES.GOVT_FUNDING_SOURCE,
482: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
483: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 503: cursor c1 is select rowid from IGS_FI_FUND_SRC_ALL

499: X_ORG_ID in NUMBER default NULL,
500: X_MODE in VARCHAR2 default 'R'
501:
502: ) as
503: cursor c1 is select rowid from IGS_FI_FUND_SRC_ALL
504: where FUNDING_SOURCE = X_FUNDING_SOURCE
505: ;
506: begin
507: open c1;

Line 541: delete from IGS_FI_FUND_SRC_ALL

537: Before_DML (
538: p_action => 'DELETE',
539: x_rowid => X_ROWID
540: );
541: delete from IGS_FI_FUND_SRC_ALL
542: where ROWID=X_ROWID;
543: if (sql%notfound) then
544: raise no_data_found;
545: end if;