APPS.IGS_FI_FUND_SRC_HIST_PKG dependencies on IGS_FI_FUND_SRC_HIST_ALL

Line 5: old_references IGS_FI_FUND_SRC_HIST_ALL%RowType;

1: package body IGS_FI_FUND_SRC_HIST_PKG AS
2: /* $Header: IGSSI43B.pls 115.6 2002/11/29 03:47:54 nsidana ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FUND_SRC_HIST_ALL%RowType;
6: new_references IGS_FI_FUND_SRC_HIST_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_FI_FUND_SRC_HIST_ALL%RowType;

2: /* $Header: IGSSI43B.pls 115.6 2002/11/29 03:47:54 nsidana ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_FI_FUND_SRC_HIST_ALL%RowType;
6: new_references IGS_FI_FUND_SRC_HIST_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_funding_source IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_FI_FUND_SRC_HIST_ALL

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

Line 102: FROM IGS_FI_FUND_SRC_HIST_ALL

98: x_hist_start_dt IN DATE
99: ) RETURN BOOLEAN AS
100: CURSOR cur_rowid IS
101: SELECT rowid
102: FROM IGS_FI_FUND_SRC_HIST_ALL
103: WHERE funding_source = x_funding_source
104: AND hist_start_dt = x_hist_start_dt
105: FOR UPDATE NOWAIT;
106: lv_rowid cur_rowid%RowType;

Line 214: cursor C is select ROWID from IGS_FI_FUND_SRC_HIST_ALL

210: X_CLOSED_IND in VARCHAR2,
211: X_ORG_ID in NUMBER,
212: X_MODE in VARCHAR2 default 'R'
213: ) is
214: cursor C is select ROWID from IGS_FI_FUND_SRC_HIST_ALL
215: where FUNDING_SOURCE = X_FUNDING_SOURCE
216: and HIST_START_DT = X_HIST_START_DT;
217: X_LAST_UPDATE_DATE DATE;
218: X_LAST_UPDATED_BY NUMBER;

Line 257: insert into IGS_FI_FUND_SRC_HIST_ALL (

253: x_last_update_date=>X_LAST_UPDATE_DATE,
254: x_last_updated_by=>X_LAST_UPDATED_BY,
255: x_last_update_login=>X_LAST_UPDATE_LOGIN
256: );
257: insert into IGS_FI_FUND_SRC_HIST_ALL (
258: FUNDING_SOURCE,
259: HIST_START_DT,
260: HIST_END_DT,
261: HIST_WHO,

Line 314: from IGS_FI_FUND_SRC_HIST_ALL

310: HIST_WHO,
311: DESCRIPTION,
312: GOVT_FUNDING_SOURCE,
313: CLOSED_IND
314: from IGS_FI_FUND_SRC_HIST_ALL
315: where ROWID=X_ROWID
316: for update nowait;
317: tlinfo c1%rowtype;
318: begin

Line 398: update IGS_FI_FUND_SRC_HIST_ALL set

394: x_last_update_date=>X_LAST_UPDATE_DATE,
395: x_last_updated_by=>X_LAST_UPDATED_BY,
396: x_last_update_login=>X_LAST_UPDATE_LOGIN
397: );
398: update IGS_FI_FUND_SRC_HIST_ALL set
399: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
400: HIST_WHO = NEW_REFERENCES.HIST_WHO,
401: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
402: GOVT_FUNDING_SOURCE = NEW_REFERENCES.GOVT_FUNDING_SOURCE,

Line 429: cursor c1 is select rowid from IGS_FI_FUND_SRC_HIST_ALL

425: X_CLOSED_IND in VARCHAR2,
426: X_ORG_ID in NUMBER,
427: X_MODE in VARCHAR2 default 'R'
428: ) is
429: cursor c1 is select rowid from IGS_FI_FUND_SRC_HIST_ALL
430: where FUNDING_SOURCE = X_FUNDING_SOURCE
431: and HIST_START_DT = X_HIST_START_DT
432: ;
433: begin

Line 472: delete from IGS_FI_FUND_SRC_HIST_ALL

468: Before_DML(
469: p_action => 'DELETE',
470: x_rowid => X_ROWID
471: );
472: delete from IGS_FI_FUND_SRC_HIST_ALL
473: where ROWID=X_ROWID;
474: if (sql%notfound) then
475: raise no_data_found;
476: end if;