APPS.IGS_AS_SU_SETATMPT_H_PKG dependencies on IGS_AS_SU_SETATMPT_H_ALL

Line 6: old_references IGS_AS_SU_SETATMPT_H_ALL%RowType;

2: /* $Header: IGSDI28B.pls 115.7 2002/11/28 23:17:56 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AS_SU_SETATMPT_H_ALL%RowType;
7: new_references IGS_AS_SU_SETATMPT_H_ALL%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 7: new_references IGS_AS_SU_SETATMPT_H_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AS_SU_SETATMPT_H_ALL%RowType;
7: new_references IGS_AS_SU_SETATMPT_H_ALL%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_org_id IN NUMBER DEFAULT NULL,

Line 43: FROM IGS_AS_SU_SETATMPT_H_ALL

39: x_last_update_login IN NUMBER DEFAULT NULL
40: ) AS
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_AS_SU_SETATMPT_H_ALL
44: WHERE rowid = x_rowid;
45: BEGIN
46: l_rowid := x_rowid;
47: -- Code for setting the Old and New Reference Values.

Line 105: FROM IGS_AS_SU_SETATMPT_H_ALL

101: x_hist_start_dt IN DATE
102: ) RETURN BOOLEAN AS
103: CURSOR cur_rowid IS
104: SELECT rowid
105: FROM IGS_AS_SU_SETATMPT_H_ALL
106: WHERE person_id = x_person_id
107: AND course_cd = x_course_cd
108: AND unit_set_cd = x_unit_set_cd
109: AND sequence_number = x_sequence_number

Line 257: cursor C is select ROWID from IGS_AS_SU_SETATMPT_H_ALL

253: X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
254: X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL,
255: X_MODE in VARCHAR2 default 'R'
256: ) AS
257: cursor C is select ROWID from IGS_AS_SU_SETATMPT_H_ALL
258: where PERSON_ID = X_PERSON_ID
259: and COURSE_CD = X_COURSE_CD
260: and UNIT_SET_CD = X_UNIT_SET_CD
261: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 320: insert into IGS_AS_SU_SETATMPT_H_ALL (

316: x_last_updated_by=>X_LAST_UPDATED_BY,
317: x_last_update_login=>X_LAST_UPDATE_LOGIN
318: );
319: --
320: insert into IGS_AS_SU_SETATMPT_H_ALL (
321: ORG_ID,
322: PERSON_ID,
323: COURSE_CD,
324: UNIT_SET_CD,

Line 435: from IGS_AS_SU_SETATMPT_H_ALL

431: RQRMNTS_COMPLETE_DT,
432: S_COMPLETED_SOURCE_TYPE,
433: CATALOG_CAL_TYPE ,
434: CATALOG_SEQ_NUM
435: from IGS_AS_SU_SETATMPT_H_ALL
436: where ROWID = X_ROWID for update nowait;
437: tlinfo c1%rowtype;
438: begin
439: open c1;

Line 591: update IGS_AS_SU_SETATMPT_H_ALL set

587: x_last_updated_by=>X_LAST_UPDATED_BY,
588: x_last_update_login=>X_LAST_UPDATE_LOGIN
589: );
590: --
591: update IGS_AS_SU_SETATMPT_H_ALL set
592: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
593: HIST_WHO = NEW_REFERENCES.HIST_WHO,
594: US_VERSION_NUMBER = NEW_REFERENCES.US_VERSION_NUMBER,
595: SELECTION_DT = NEW_REFERENCES.SELECTION_DT,

Line 647: cursor c1 is select rowid from IGS_AS_SU_SETATMPT_H_ALL

643: X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
644: X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL,
645: X_MODE in VARCHAR2 default 'R'
646: ) AS
647: cursor c1 is select rowid from IGS_AS_SU_SETATMPT_H_ALL
648: where PERSON_ID = X_PERSON_ID
649: and COURSE_CD = X_COURSE_CD
650: and UNIT_SET_CD = X_UNIT_SET_CD
651: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 725: delete from IGS_AS_SU_SETATMPT_H_ALL

721: p_action => 'DELETE',
722: x_rowid => X_ROWID
723: );
724: --
725: delete from IGS_AS_SU_SETATMPT_H_ALL
726: where ROWID = X_ROWID;
727: if (sql%notfound) theN
728: raise no_data_found;
729: end if;