APPS.IGS_AS_SC_ATMPT_ENR_PKG dependencies on IGS_AS_SC_ATMPT_ENR

Line 1: package body IGS_AS_SC_ATMPT_ENR_PKG AS

1: package body IGS_AS_SC_ATMPT_ENR_PKG AS
2: /* $Header: IGSDI18B.pls 120.0 2005/07/05 12:17:44 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATMPT_ENR%RowType;

Line 5: old_references IGS_AS_SC_ATMPT_ENR%RowType;

1: package body IGS_AS_SC_ATMPT_ENR_PKG AS
2: /* $Header: IGSDI18B.pls 120.0 2005/07/05 12:17:44 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATMPT_ENR%RowType;
6: new_references IGS_AS_SC_ATMPT_ENR%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_ATMPT_ENR%RowType;

2: /* $Header: IGSDI18B.pls 120.0 2005/07/05 12:17:44 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATMPT_ENR%RowType;
6: new_references IGS_AS_SC_ATMPT_ENR%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 27: FROM IGS_AS_SC_ATMPT_ENR

23: x_last_update_login IN NUMBER DEFAULT NULL
24: ) AS
25: CURSOR cur_old_ref_values IS
26: SELECT *
27: FROM IGS_AS_SC_ATMPT_ENR
28: WHERE rowid = x_rowid;
29: BEGIN
30: l_rowid := x_rowid;
31: -- Code for setting the Old and New Reference Values.

Line 113: FROM IGS_AS_SC_ATMPT_ENR

109: x_ci_sequence_number IN NUMBER
110: ) RETURN BOOLEAN AS
111: CURSOR cur_rowid IS
112: SELECT rowid
113: FROM IGS_AS_SC_ATMPT_ENR
114: WHERE person_id = x_person_id
115: AND course_cd = x_course_cd
116: AND CAL_TYPE = x_cal_type
117: AND ci_sequence_number = x_ci_sequence_number

Line 137: FROM IGS_AS_SC_ATMPT_ENR

133: x_sequence_number IN NUMBER
134: ) AS
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM IGS_AS_SC_ATMPT_ENR
138: WHERE CAL_TYPE = x_cal_type
139: AND ci_sequence_number = x_sequence_number ;
140: lv_rowid cur_rowid%RowType;
141: BEGIN

Line 159: FROM IGS_AS_SC_ATMPT_ENR

155: x_enrolment_cat IN VARCHAR2
156: ) AS
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM IGS_AS_SC_ATMPT_ENR
160: WHERE ENROLMENT_CAT = x_enrolment_cat ;
161: lv_rowid cur_rowid%RowType;
162: BEGIN
163: Open cur_rowid;

Line 181: FROM IGS_AS_SC_ATMPT_ENR

177: x_course_cd IN VARCHAR2
178: ) AS
179: CURSOR cur_rowid IS
180: SELECT rowid
181: FROM IGS_AS_SC_ATMPT_ENR
182: WHERE person_id = x_person_id
183: AND course_cd = x_course_cd ;
184: lv_rowid cur_rowid%RowType;
185: BEGIN

Line 288: cursor C is select ROWID from IGS_AS_SC_ATMPT_ENR

284: X_ENR_PCKG_PROD_DT in DATE,
285: X_ENR_FORM_RECEIVED_DT in DATE,
286: X_MODE in VARCHAR2 default 'R'
287: ) AS
288: cursor C is select ROWID from IGS_AS_SC_ATMPT_ENR
289: where PERSON_ID = X_PERSON_ID
290: and COURSE_CD = X_COURSE_CD
291: and CAL_TYPE = X_CAL_TYPE
292: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER;

Line 351: insert into IGS_AS_SC_ATMPT_ENR (

347: );
348: IF (x_mode = 'S') THEN
349: igs_sc_gen_001.set_ctx('R');
350: END IF;
351: insert into IGS_AS_SC_ATMPT_ENR (
352: PERSON_ID,
353: COURSE_CD,
354: CAL_TYPE,
355: CI_SEQUENCE_NUMBER,

Line 434: from IGS_AS_SC_ATMPT_ENR

430: ENROLLED_DT,
431: ENR_FORM_DUE_DT,
432: ENR_PCKG_PROD_DT,
433: ENR_FORM_RECEIVED_DT
434: from IGS_AS_SC_ATMPT_ENR
435: where ROWID = X_ROWID for update nowait;
436: tlinfo c1%rowtype;
437: begin
438: open c1;

Line 543: update IGS_AS_SC_ATMPT_ENR set

539: end if;
540: IF (x_mode = 'S') THEN
541: igs_sc_gen_001.set_ctx('R');
542: END IF;
543: update IGS_AS_SC_ATMPT_ENR set
544: ENROLMENT_CAT = NEW_REFERENCES.ENROLMENT_CAT,
545: ENROLLED_DT = NEW_REFERENCES.ENROLLED_DT,
546: ENR_FORM_DUE_DT = NEW_REFERENCES.ENR_FORM_DUE_DT,
547: ENR_PCKG_PROD_DT = NEW_REFERENCES.ENR_PCKG_PROD_DT,

Line 595: cursor c1 is select rowid from IGS_AS_SC_ATMPT_ENR

591: X_ENR_PCKG_PROD_DT in DATE,
592: X_ENR_FORM_RECEIVED_DT in DATE,
593: X_MODE in VARCHAR2 default 'R'
594: ) AS
595: cursor c1 is select rowid from IGS_AS_SC_ATMPT_ENR
596: where PERSON_ID = X_PERSON_ID
597: and COURSE_CD = X_COURSE_CD
598: and CAL_TYPE = X_CAL_TYPE
599: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 645: delete from IGS_AS_SC_ATMPT_ENR

641: );
642: IF (x_mode = 'S') THEN
643: igs_sc_gen_001.set_ctx('R');
644: END IF;
645: delete from IGS_AS_SC_ATMPT_ENR
646: where ROWID = X_ROWID;
647: if (sql%notfound) then
648: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
649: igs_ge_msg_stack.add;

Line 701: end IGS_AS_SC_ATMPT_ENR_PKG;

697: END IF;
698: END IF;
699: END Check_Constraints;
700:
701: end IGS_AS_SC_ATMPT_ENR_PKG;