APPS.IGS_FI_FD_SRC_RSTN_H_PKG dependencies on IGS_FI_FD_SRC_RSTN_H_ALL

Line 4: old_references IGS_FI_FD_SRC_RSTN_H_ALL%RowType;

1: package body IGS_FI_FD_SRC_RSTN_H_PKG as
2: /* $Header: IGSSI41B.pls 115.5 2002/11/29 03:47:10 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FD_SRC_RSTN_H_ALL%RowType;
5: new_references IGS_FI_FD_SRC_RSTN_H_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_FI_FD_SRC_RSTN_H_ALL%RowType;

1: package body IGS_FI_FD_SRC_RSTN_H_PKG as
2: /* $Header: IGSSI41B.pls 115.5 2002/11/29 03:47:10 nsidana ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_FI_FD_SRC_RSTN_H_ALL%RowType;
5: new_references IGS_FI_FD_SRC_RSTN_H_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_course_cd IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_FI_FD_SRC_RSTN_H_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_FD_SRC_RSTN_H_ALL
27: WHERE rowid = x_rowid;
28: BEGIN
29: l_rowid := x_rowid;
30: -- Code for setting the Old and New Reference Values.

Line 153: FROM IGS_FI_FD_SRC_RSTN_H_ALL

149: x_hist_start_dt IN DATE
150: ) RETURN BOOLEAN AS
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM IGS_FI_FD_SRC_RSTN_H_ALL
154: WHERE course_cd = x_course_cd
155: AND version_number = x_version_number
156: AND funding_source = x_funding_source
157: AND hist_start_dt = x_hist_start_dt

Line 177: FROM IGS_FI_FD_SRC_RSTN_H_ALL

173: x_version_number IN NUMBER
174: ) AS
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM IGS_FI_FD_SRC_RSTN_H_ALL
178: WHERE course_cd = x_course_cd
179: AND version_number = x_version_number ;
180: lv_rowid cur_rowid%RowType;
181: BEGIN

Line 198: FROM IGS_FI_FD_SRC_RSTN_H_ALL

194: x_funding_source IN VARCHAR2
195: ) AS
196: CURSOR cur_rowid IS
197: SELECT rowid
198: FROM IGS_FI_FD_SRC_RSTN_H_ALL
199: WHERE funding_source = x_funding_source ;
200: lv_rowid cur_rowid%RowType;
201: BEGIN
202: Open cur_rowid;

Line 290: cursor C is select ROWID from IGS_FI_FD_SRC_RSTN_H_ALL

286: X_RESTRICTED_IND in VARCHAR2,
287: X_ORG_ID in NUMBER,
288: X_MODE in VARCHAR2 default 'R'
289: ) as
290: cursor C is select ROWID from IGS_FI_FD_SRC_RSTN_H_ALL
291: where COURSE_CD = X_COURSE_CD
292: and HIST_START_DT = X_HIST_START_DT
293: and VERSION_NUMBER = X_VERSION_NUMBER
294: and FUNDING_SOURCE = X_FUNDING_SOURCE;

Line 335: insert into IGS_FI_FD_SRC_RSTN_H_ALL (

331: x_last_update_date=>X_LAST_UPDATE_DATE,
332: x_last_updated_by=>X_LAST_UPDATED_BY,
333: x_last_update_login=>X_LAST_UPDATE_LOGIN
334: );
335: insert into IGS_FI_FD_SRC_RSTN_H_ALL (
336: COURSE_CD,
337: VERSION_NUMBER,
338: FUNDING_SOURCE,
339: HIST_START_DT,

Line 390: from IGS_FI_FD_SRC_RSTN_H_ALL

386: HIST_END_DT,
387: HIST_WHO,
388: DFLT_IND,
389: RESTRICTED_IND
390: from IGS_FI_FD_SRC_RSTN_H_ALL
391: where ROWID=X_ROWID
392: for update nowait;
393: tlinfo c1%rowtype;
394: begin

Line 473: update IGS_FI_FD_SRC_RSTN_H_ALL set

469: x_last_update_date=>X_LAST_UPDATE_DATE,
470: x_last_updated_by=>X_LAST_UPDATED_BY,
471: x_last_update_login=>X_LAST_UPDATE_LOGIN
472: );
473: update IGS_FI_FD_SRC_RSTN_H_ALL set
474: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
475: HIST_WHO = NEW_REFERENCES.HIST_WHO,
476: DFLT_IND = NEW_REFERENCES.DFLT_IND,
477: RESTRICTED_IND = NEW_REFERENCES.RESTRICTED_IND,

Line 500: cursor c1 is select rowid from IGS_FI_FD_SRC_RSTN_H_ALL

496: X_RESTRICTED_IND in VARCHAR2,
497: X_ORG_ID in NUMBER,
498: X_MODE in VARCHAR2 default 'R'
499: ) as
500: cursor c1 is select rowid from IGS_FI_FD_SRC_RSTN_H_ALL
501: where COURSE_CD = X_COURSE_CD
502: and HIST_START_DT = X_HIST_START_DT
503: and VERSION_NUMBER = X_VERSION_NUMBER
504: and FUNDING_SOURCE = X_FUNDING_SOURCE

Line 549: delete from IGS_FI_FD_SRC_RSTN_H_ALL

545: p_action => 'DELETE',
546: x_rowid => X_ROWID
547: );
548:
549: delete from IGS_FI_FD_SRC_RSTN_H_ALL
550: where ROWID=X_ROWID;
551: if (sql%notfound) then
552: raise no_data_found;
553: end if;