APPS.IGS_PS_REF_CD_HIST_PKG dependencies on IGS_PS_REF_CD_HIST_ALL

Line 5: old_references IGS_PS_REF_CD_HIST_ALL%RowType;

1: package body IGS_PS_REF_CD_HIST_PKG AS
2: /* $Header: IGSPI30B.pls 115.6 2003/05/09 06:26:09 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_REF_CD_HIST_ALL%RowType;
6: new_references IGS_PS_REF_CD_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_REF_CD_HIST_ALL%RowType;

2: /* $Header: IGSPI30B.pls 115.6 2003/05/09 06:26:09 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_REF_CD_HIST_ALL%RowType;
6: new_references IGS_PS_REF_CD_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_REF_CD_HIST_ALL

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

Line 165: FROM IGS_PS_REF_CD_HIST_ALL

161: ) RETURN BOOLEAN AS
162:
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM IGS_PS_REF_CD_HIST_ALL
166: WHERE course_cd = x_course_cd
167: AND version_number = x_version_number
168: AND reference_cd_type = x_reference_cd_type
169: AND reference_cd = x_reference_cd

Line 195: FROM IGS_PS_REF_CD_HIST_ALL

191: ) AS
192:
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM IGS_PS_REF_CD_HIST_ALL
196: WHERE course_cd = x_course_cd
197: AND version_number = x_version_number ;
198:
199: lv_rowid cur_rowid%RowType;

Line 222: FROM IGS_PS_REF_CD_HIST_ALL

218: ) AS
219:
220: CURSOR cur_rowid IS
221: SELECT rowid
222: FROM IGS_PS_REF_CD_HIST_ALL
223: WHERE reference_cd_type = x_reference_cd_type ;
224:
225: lv_rowid cur_rowid%RowType;
226:

Line 346: cursor C is select ROWID from IGS_PS_REF_CD_HIST_ALL

342: X_DESCRIPTION in VARCHAR2,
343: X_MODE in VARCHAR2 default 'R',
344: X_ORG_ID IN NUMBER
345: ) AS
346: cursor C is select ROWID from IGS_PS_REF_CD_HIST_ALL
347: where COURSE_CD = X_COURSE_CD
348: and REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE
349: and REFERENCE_CD = X_REFERENCE_CD
350: and HIST_START_DT = X_HIST_START_DT

Line 393: insert into IGS_PS_REF_CD_HIST_ALL (

389: x_last_update_login => X_LAST_UPDATE_LOGIN ,
390: x_org_id => igs_ge_gen_003.get_org_id
391: );
392:
393: insert into IGS_PS_REF_CD_HIST_ALL (
394: COURSE_CD,
395: VERSION_NUMBER,
396: REFERENCE_CD_TYPE,
397: REFERENCE_CD,

Line 453: from IGS_PS_REF_CD_HIST_ALL

449: cursor c1 is select
450: HIST_END_DT,
451: HIST_WHO,
452: DESCRIPTION
453: from IGS_PS_REF_CD_HIST_ALL
454: where ROWID = X_ROWID
455: for update nowait;
456: tlinfo c1%rowtype;
457:

Line 537: update IGS_PS_REF_CD_HIST_ALL set

533: x_last_updated_by => X_LAST_UPDATED_BY ,
534: x_last_update_login => X_LAST_UPDATE_LOGIN
535: );
536:
537: update IGS_PS_REF_CD_HIST_ALL set
538: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
539: HIST_WHO = NEW_REFERENCES.HIST_WHO,
540: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
541: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 568: cursor c1 is select rowid from IGS_PS_REF_CD_HIST_ALL

564: X_DESCRIPTION in VARCHAR2,
565: X_MODE in VARCHAR2 default 'R',
566: X_ORG_ID in NUMBER
567: ) AS
568: cursor c1 is select rowid from IGS_PS_REF_CD_HIST_ALL
569: where COURSE_CD = X_COURSE_CD
570: and REFERENCE_CD_TYPE = X_REFERENCE_CD_TYPE
571: and REFERENCE_CD = X_REFERENCE_CD
572: and HIST_START_DT = X_HIST_START_DT

Line 617: delete from IGS_PS_REF_CD_HIST_ALL

613: Before_DML (
614: p_action => 'DELETE',
615: x_rowid => X_ROWID
616: );
617: delete from IGS_PS_REF_CD_HIST_ALL
618: where ROWID = X_ROWID;
619: if (sql%notfound) then
620: raise no_data_found;
621: end if;