APPS.IGS_EN_SU_ATTEMPT_H_PKG dependencies on IGS_EN_SU_ATTEMPT_H_ALL

Line 5: old_references IGS_EN_SU_ATTEMPT_H_ALL%RowType;

1: package body IGS_EN_SU_ATTEMPT_H_PKG AS
2: /* $Header: IGSEI37B.pls 120.1 2006/05/10 00:27:48 bdeviset noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_SU_ATTEMPT_H_ALL%RowType;
6: new_references IGS_EN_SU_ATTEMPT_H_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_EN_SU_ATTEMPT_H_ALL%RowType;

2: /* $Header: IGSEI37B.pls 120.1 2006/05/10 00:27:48 bdeviset noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_EN_SU_ATTEMPT_H_ALL%RowType;
6: new_references IGS_EN_SU_ATTEMPT_H_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 65: FROM IGS_EN_SU_ATTEMPT_H_ALL

61: x_core_indicator_code IN VARCHAR2 DEFAULT NULL
62: ) AS
63: CURSOR cur_old_ref_values IS
64: SELECT *
65: FROM IGS_EN_SU_ATTEMPT_H_ALL
66: WHERE rowid = x_rowid;
67: BEGIN
68: l_rowid := x_rowid;
69: -- Code for setting the Old and New Reference Values.

Line 192: FROM IGS_EN_SU_ATTEMPT_H_ALL

188: x_uoo_id IN NUMBER
189: ) RETURN BOOLEAN AS
190: CURSOR cur_rowid IS
191: SELECT rowid
192: FROM IGS_EN_SU_ATTEMPT_H_ALL
193: WHERE person_id = x_person_id
194: AND course_cd = x_course_cd
195: AND hist_start_dt = x_hist_start_dt
196: AND uoo_id = x_uoo_id

Line 216: FROM IGS_EN_SU_ATTEMPT_H_ALL

212: x_course_cd IN VARCHAR2
213: ) AS
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM IGS_EN_SU_ATTEMPT_H_ALL
217: WHERE person_id = x_person_id
218: AND course_cd = x_course_cd ;
219: lv_rowid cur_rowid%RowType;
220: BEGIN

Line 242: FROM IGS_EN_SU_ATTEMPT_H_ALL

238: ) AS
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_EN_SU_ATTEMPT_H_ALL
243: WHERE person_id = x_person_id
244: AND course_cd = x_course_cd
245: AND uoo_id = x_uoo_id;
246:

Line 334: FROM IGS_EN_SU_ATTEMPT_H_ALL

330: CURSOR c_hist_end_dt(cp_person_id IN NUMBER,
331: cp_course_cd IN VARCHAR2,
332: cp_uoo_id IN NUMBER) IS
333: SELECT HIST_END_DT
334: FROM IGS_EN_SU_ATTEMPT_H_ALL
335: WHERE person_id = cp_person_id
336: AND course_cd = cp_course_cd
337: AND uoo_id = cp_uoo_id
338: ORDER BY HIST_END_DT DESC

Line 341: l_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE;

337: AND uoo_id = cp_uoo_id
338: ORDER BY HIST_END_DT DESC
339: FOR UPDATE;
340:
341: l_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE;
342:
343: BEGIN
344: Set_Column_Values (
345: p_action,

Line 510: cursor C is select ROWID from IGS_EN_SU_ATTEMPT_H_ALL

506: X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
507: X_UOO_ID IN NUMBER,
508: X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
509: ) AS
510: cursor C is select ROWID from IGS_EN_SU_ATTEMPT_H_ALL
511: where PERSON_ID = X_PERSON_ID
512: and COURSE_CD = X_COURSE_CD
513: and HIST_START_DT = new_references.HIST_START_DT
514: and UOO_ID = X_UOO_ID;

Line 593: insert into IGS_EN_SU_ATTEMPT_H_ALL (

589: x_deg_aud_detail_id => X_DEG_AUD_DETAIL_ID,
590: x_uoo_id => X_UOO_ID,
591: x_core_indicator_code => X_CORE_INDICATOR_CODE
592: );
593: insert into IGS_EN_SU_ATTEMPT_H_ALL (
594: ELO_DESCRIPTION,
595: SUP_UNIT_CD,
596: SUP_VERSION_NUMBER,
597: ALTERNATIVE_TITLE,

Line 799: from IGS_EN_SU_ATTEMPT_H_ALL

795: FAILED_UNIT_RULE,
796: DEG_AUD_DETAIL_ID,
797: UOO_ID,
798: CORE_INDICATOR_CODE
799: from IGS_EN_SU_ATTEMPT_H_ALL
800: where PERSON_ID = X_PERSON_ID
801: and COURSE_CD = X_COURSE_CD
802: and HIST_START_DT = X_HIST_START_DT
803: and UOO_ID = X_UOO_ID

Line 1080: update IGS_EN_SU_ATTEMPT_H_ALL set

1076: x_deg_aud_detail_id => X_DEG_AUD_DETAIL_ID,
1077: x_uoo_id => X_UOO_ID,
1078: x_core_indicator_code => X_CORE_INDICATOR_CODE
1079: );
1080: update IGS_EN_SU_ATTEMPT_H_ALL set
1081: ELO_DESCRIPTION = new_references.ELO_DESCRIPTION,
1082: SUP_UNIT_CD = new_references.SUP_UNIT_CD,
1083: SUP_VERSION_NUMBER = new_references.SUP_VERSION_NUMBER,
1084: ALTERNATIVE_TITLE = new_references.ALTERNATIVE_TITLE,

Line 1181: cursor c1 is select rowid from IGS_EN_SU_ATTEMPT_H_ALL

1177: X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
1178: X_UOO_ID IN NUMBER,
1179: X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
1180: ) as
1181: cursor c1 is select rowid from IGS_EN_SU_ATTEMPT_H_ALL
1182: where PERSON_ID = X_PERSON_ID
1183: and COURSE_CD = X_COURSE_CD
1184: and HIST_START_DT = X_HIST_START_DT
1185: and UOO_ID = X_UOO_ID;

Line 1305: delete from IGS_EN_SU_ATTEMPT_H_ALL

1301: Before_DML(
1302: p_action => 'DELETE',
1303: x_rowid => X_ROWID
1304: );
1305: delete from IGS_EN_SU_ATTEMPT_H_ALL
1306: where ROWID=X_ROWID;
1307: if (sql%notfound) then
1308: raise no_data_found;
1309: end if;