APPS.IGS_PS_FLD_STDY_HIST_PKG dependencies on IGS_PS_FLD_STDY_HIST_ALL

Line 5: old_references IGS_PS_FLD_STDY_HIST_ALL%RowType;

1: package body IGS_PS_FLD_STDY_HIST_PKG as
2: /* $Header: IGSPI55B.pls 120.1 2006/07/25 15:06:56 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FLD_STDY_HIST_ALL%RowType;
6: new_references IGS_PS_FLD_STDY_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_FLD_STDY_HIST_ALL%RowType;

2: /* $Header: IGSPI55B.pls 120.1 2006/07/25 15:06:56 sommukhe noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FLD_STDY_HIST_ALL%RowType;
6: new_references IGS_PS_FLD_STDY_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PS_FLD_STDY_HIST_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PS_FLD_STDY_HIST_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 123: FROM IGS_PS_FLD_STDY_HIST_ALL

119: ) RETURN BOOLEAN AS
120:
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM IGS_PS_FLD_STDY_HIST_ALL
124: WHERE field_of_study = x_field_of_study
125: AND hist_start_dt = x_hist_start_dt
126: FOR UPDATE NOWAIT;
127:

Line 236: cursor C is select ROWID from IGS_PS_FLD_STDY_HIST_ALL

232: X_MODE in VARCHAR2 default 'R',
233: X_ORG_ID in NUMBER,
234: X_FOS_TYPE_CODE VARCHAR2
235: ) as
236: cursor C is select ROWID from IGS_PS_FLD_STDY_HIST_ALL
237: where FIELD_OF_STUDY = X_FIELD_OF_STUDY
238: and HIST_START_DT = X_HIST_START_DT;
239: X_LAST_UPDATE_DATE DATE;
240: X_LAST_UPDATED_BY NUMBER;

Line 280: insert into IGS_PS_FLD_STDY_HIST_ALL (

276: x_org_id => igs_ge_gen_003.get_org_id,
277: x_fos_type_code => X_FOS_TYPE_CODE
278: );
279:
280: insert into IGS_PS_FLD_STDY_HIST_ALL (
281: FIELD_OF_STUDY,
282: HIST_START_DT,
283: HIST_END_DT,
284: HIST_WHO,

Line 344: from IGS_PS_FLD_STDY_HIST_ALL

340: DESCRIPTION,
341: GOVT_FIELD_OF_STUDY,
342: CLOSED_IND
343:
344: from IGS_PS_FLD_STDY_HIST_ALL
345: where ROWID = X_ROWID for update nowait;
346: tlinfo c1%rowtype;
347:
348: begin

Line 434: update IGS_PS_FLD_STDY_HIST_ALL set

430: x_last_updated_by => X_LAST_UPDATED_BY,
431: x_last_update_login => X_LAST_UPDATE_LOGIN,
432: x_fos_type_code => X_FOS_TYPE_CODE
433: );
434: update IGS_PS_FLD_STDY_HIST_ALL set
435: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
436: HIST_WHO = NEW_REFERENCES.HIST_WHO,
437: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
438: GOVT_FIELD_OF_STUDY = NEW_REFERENCES.GOVT_FIELD_OF_STUDY,

Line 469: cursor c1 is select rowid from IGS_PS_FLD_STDY_HIST_ALL

465: X_MODE in VARCHAR2 default 'R',
466: X_ORG_ID in NUMBER,
467: X_FOS_TYPE_CODE in VARCHAR2
468: ) as
469: cursor c1 is select rowid from IGS_PS_FLD_STDY_HIST_ALL
470: where FIELD_OF_STUDY = X_FIELD_OF_STUDY
471: and HIST_START_DT = X_HIST_START_DT
472: ;
473: begin

Line 514: delete from IGS_PS_FLD_STDY_HIST_ALL

510: begin
511: Before_DML( p_action => 'DELETE',
512: x_rowid => X_ROWID
513: );
514: delete from IGS_PS_FLD_STDY_HIST_ALL
515: where ROWID = X_ROWID;
516: if (sql%notfound) then
517: raise no_data_found;
518: end if;