APPS.IGS_AS_SC_ATTEMPT_H_PKG dependencies on IGS_AS_SC_ATTEMPT_H_ALL

Line 5: old_references IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE;

1: PACKAGE BODY IGS_AS_SC_ATTEMPT_H_PKG AS
2: /* $Header: IGSDI19B.pls 115.13 2003/12/04 13:07:26 rvangala ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE;
6: new_references IGS_AS_SC_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_AS_SC_ATTEMPT_H_ALL%ROWTYPE;

2: /* $Header: IGSDI19B.pls 115.13 2003/12/04 13:07:26 rvangala ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE;
6: new_references IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_org_id IN NUMBER DEFAULT NULL,

Line 75: FROM IGS_AS_SC_ATTEMPT_H_ALL

71: x_igs_pr_class_std_id IN NUMBER DEFAULT NULL
72: ) AS
73: CURSOR cur_old_ref_values IS
74: SELECT *
75: FROM IGS_AS_SC_ATTEMPT_H_ALL
76: WHERE ROWID = x_rowid;
77: BEGIN
78: l_rowid := x_rowid;
79: -- Code for setting the Old and New Reference Values.

Line 459: FROM IGS_AS_SC_ATTEMPT_H_ALL

455: x_hist_start_dt IN DATE
456: ) RETURN BOOLEAN AS
457: CURSOR cur_rowid IS
458: SELECT ROWID
459: FROM IGS_AS_SC_ATTEMPT_H_ALL
460: WHERE person_id = x_person_id
461: AND course_cd = x_course_cd
462: AND hist_start_dt = x_hist_start_dt
463: FOR UPDATE NOWAIT;

Line 711: CURSOR C IS SELECT ROWID FROM IGS_AS_SC_ATTEMPT_H_ALL

707: X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
708: X_COO_ID IN NUMBER DEFAULT NULL,
709: X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
710: ) AS
711: CURSOR C IS SELECT ROWID FROM IGS_AS_SC_ATTEMPT_H_ALL
712: WHERE PERSON_ID = X_PERSON_ID
713: AND COURSE_CD = X_COURSE_CD
714: AND HIST_START_DT = X_HIST_START_DT;
715: X_LAST_UPDATE_DATE DATE;

Line 803: INSERT INTO IGS_AS_SC_ATTEMPT_H_ALL (

799: x_manual_ovr_cmpl_dt_ind => X_MANUAL_OVR_CMPL_DT_IND,
800: x_coo_id => X_COO_ID,
801: x_igs_pr_class_std_id => X_IGS_PR_CLASS_STD_ID
802: );
803: INSERT INTO IGS_AS_SC_ATTEMPT_H_ALL (
804: ORG_ID,
805: PERSON_ID,
806: COURSE_CD,
807: HIST_START_DT,

Line 1052: FROM IGS_AS_SC_ATTEMPT_H_ALL

1048: OVERRIDE_CMPL_DT,
1049: MANUAL_OVR_CMPL_DT_IND,
1050: COO_ID,
1051: IGS_PR_CLASS_STD_ID
1052: FROM IGS_AS_SC_ATTEMPT_H_ALL
1053: WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
1054: tlinfo c1%ROWTYPE;
1055: BEGIN
1056: OPEN c1;

Line 1377: UPDATE IGS_AS_SC_ATTEMPT_H_ALL SET

1373: x_manual_ovr_cmpl_dt_ind => X_MANUAL_OVR_CMPL_DT_IND,
1374: x_coo_id => X_COO_ID,
1375: X_igs_pr_class_std_id => X_IGS_PR_CLASS_STD_ID
1376: );
1377: UPDATE IGS_AS_SC_ATTEMPT_H_ALL SET
1378: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
1379: HIST_WHO = NEW_REFERENCES.HIST_WHO,
1380: VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
1381: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,

Line 1501: CURSOR c1 IS SELECT ROWID FROM IGS_AS_SC_ATTEMPT_H_ALL

1497: X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
1498: X_COO_ID IN NUMBER DEFAULT NULL,
1499: X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
1500: ) AS
1501: CURSOR c1 IS SELECT ROWID FROM IGS_AS_SC_ATTEMPT_H_ALL
1502: WHERE PERSON_ID = X_PERSON_ID
1503: AND COURSE_CD = X_COURSE_CD
1504: AND HIST_START_DT = X_HIST_START_DT
1505: ;

Line 1643: DELETE FROM IGS_AS_SC_ATTEMPT_H_ALL

1639: Before_DML(
1640: p_action => 'DELETE',
1641: x_rowid => X_ROWID
1642: );
1643: DELETE FROM IGS_AS_SC_ATTEMPT_H_ALL
1644: WHERE ROWID = X_ROWID;
1645: IF (SQL%NOTFOUND) THEN
1646: RAISE NO_DATA_FOUND;
1647: END IF;