APPS.IGS_PS_VER_HIST_PKG dependencies on IGS_PS_VER_HIST_ALL

Line 5: old_references IGS_PS_VER_HIST_ALL%RowType;

1: package body IGS_PS_VER_HIST_PKG AS
2: /* $Header: IGSPI43B.pls 120.0 2005/06/01 16:14:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_VER_HIST_ALL%RowType;
6: new_references IGS_PS_VER_HIST_ALL%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_VER_HIST_ALL%RowType;

2: /* $Header: IGSPI43B.pls 120.0 2005/06/01 16:14:29 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_VER_HIST_ALL%RowType;
6: new_references IGS_PS_VER_HIST_ALL%RowType;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 80: FROM IGS_PS_VER_HIST_ALL

76: ----------------------------------------------------------------------------*/
77:
78: CURSOR cur_old_ref_values IS
79: SELECT *
80: FROM IGS_PS_VER_HIST_ALL
81: WHERE rowid = x_rowid;
82:
83: BEGIN
84:

Line 354: FROM IGS_PS_VER_HIST_ALL

350: ) RETURN BOOLEAN AS
351:
352: CURSOR cur_rowid IS
353: SELECT rowid
354: FROM IGS_PS_VER_HIST_ALL
355: WHERE course_cd = x_course_cd
356: AND version_number = x_version_number
357: AND hist_start_dt = x_hist_start_dt
358: FOR UPDATE NOWAIT;

Line 615: CURSOR C IS SELECT ROWID FROM IGS_PS_VER_HIST_ALL

611: || vvutukur 19_oct-2002 Enh#2608227.removed references to std_ft_completion_time,std_pt_completion_time
612: || as these columns are obsolete.Also removed DEFAULT keyword to avoid gscc File.Pkg.22
613: || warnings.
614: ----------------------------------------------------------------------------*/
615: CURSOR C IS SELECT ROWID FROM IGS_PS_VER_HIST_ALL
616: WHERE COURSE_CD = X_COURSE_CD
617: AND VERSION_NUMBER = X_VERSION_NUMBER
618: AND HIST_START_DT = X_HIST_START_DT;
619: X_LAST_UPDATE_DATE DATE;

Line 698: INSERT INTO IGS_PS_VER_HIST_ALL (

694: x_org_id => igs_ge_gen_003.get_org_id,
695: x_annual_instruction_time => x_annual_instruction_time
696: );
697:
698: INSERT INTO IGS_PS_VER_HIST_ALL (
699: course_cd,
700: version_number,
701: hist_start_dt,
702: hist_end_dt,

Line 929: FROM IGS_PS_VER_HIST_ALL

925: state_financial_aid,
926: primary_program_rank,
927: max_wlst_per_stud,
928: annual_instruction_time
929: FROM IGS_PS_VER_HIST_ALL
930: WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
931: tlinfo c1%rowtype;
932:
933: BEGIN

Line 1223: UPDATE IGS_PS_VER_HIST_ALL SET

1219: x_last_update_login => X_LAST_UPDATE_LOGIN,
1220: x_annual_instruction_time => x_annual_instruction_time
1221: );
1222:
1223: UPDATE IGS_PS_VER_HIST_ALL SET
1224: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
1225: HIST_WHO = NEW_REFERENCES.HIST_WHO,
1226: START_DT = NEW_REFERENCES.START_DT,
1227: REVIEW_DT = NEW_REFERENCES.REVIEW_DT,

Line 1348: CURSOR C1 IS SELECT rowid FROM IGS_PS_VER_HIST_ALL

1344: || vvutukur 19_oct-2002 Enh#2608227.removed references to std_ft_completion_time,std_pt_completion_time
1345: || as these columns are obsolete.Also removed DEFAULT keyword to avoid gscc File.Pkg.22
1346: || warnings.
1347: ----------------------------------------------------------------------------*/
1348: CURSOR C1 IS SELECT rowid FROM IGS_PS_VER_HIST_ALL
1349: WHERE COURSE_CD = X_COURSE_CD
1350: AND VERSION_NUMBER = X_VERSION_NUMBER
1351: AND HIST_START_DT = X_HIST_START_DT
1352: ;

Line 1473: DELETE FROM IGS_PS_VER_HIST_ALL

1469: before_dml( p_action => 'DELETE',
1470: x_rowid => x_rowid
1471: );
1472:
1473: DELETE FROM IGS_PS_VER_HIST_ALL
1474: WHERE ROWID = X_ROWID;
1475: if (sql%notfound) then
1476: raise no_data_found;
1477: end if;