APPS.IGS_EN_CAT_PRC_STEP_PKG dependencies on IGS_EN_CAT_PRC_STEP_ALL

Line 10: old_references IGS_EN_CAT_PRC_STEP_ALL%RowType;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_ge_gen_004.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_EN_CAT_PRC_STEP_ALL%RowType;
11: new_references IGS_EN_CAT_PRC_STEP_ALL%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,

Line 11: new_references IGS_EN_CAT_PRC_STEP_ALL%RowType;

7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_EN_CAT_PRC_STEP_ALL%RowType;
11: new_references IGS_EN_CAT_PRC_STEP_ALL%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,
15: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_EN_CAT_PRC_STEP_ALL

27: ) AS
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_EN_CAT_PRC_STEP_ALL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 84: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_CAT_PRC_STEP_ALL') THEN

80: ) AS
81: v_message_name varchar2(30);
82: BEGIN
83: -- If trigger has not been disabled, perform required processing
84: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_CAT_PRC_STEP_ALL') THEN
85: IF p_inserting THEN
86: -- Validate the system enrolment step type
87: IF IGS_EN_VAL_ECPS.enrp_val_ecps_sest(
88: new_references.s_enrolment_step_type,

Line 209: FROM IGS_EN_CAT_PRC_STEP_ALL

205: ) RETURN BOOLEAN AS
206:
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM IGS_EN_CAT_PRC_STEP_ALL
210: WHERE enrolment_cat = x_enrolment_cat
211: AND s_student_comm_type = x_s_student_comm_type
212: AND enr_method_type = x_enr_method_type
213: AND s_enrolment_step_type = x_s_enrolment_step_type

Line 240: FROM IGS_EN_CAT_PRC_STEP_ALL

236: ) AS
237:
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM IGS_EN_CAT_PRC_STEP_ALL
241: WHERE enrolment_cat = x_enrolment_cat
242: AND s_student_comm_type = x_s_student_comm_type
243: AND enr_method_type = x_enr_method_type ;
244:

Line 268: FROM IGS_EN_CAT_PRC_STEP_ALL

264: ) AS
265:
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM IGS_EN_CAT_PRC_STEP_ALL
269: WHERE s_enrolment_step_type = x_s_enrolment_step_type ;
270:
271: lv_rowid cur_rowid%RowType;
272:

Line 394: cursor C is select ROWID from IGS_EN_CAT_PRC_STEP_ALL

390: X_STEP_ORDER_NUM in NUMBER,
391: X_MODE in VARCHAR2 default 'R',
392: x_org_id IN NUMBER
393: ) AS
394: cursor C is select ROWID from IGS_EN_CAT_PRC_STEP_ALL
395: where ENROLMENT_CAT = X_ENROLMENT_CAT
396: and S_STUDENT_COMM_TYPE = X_S_STUDENT_COMM_TYPE
397: and ENR_METHOD_TYPE = X_ENR_METHOD_TYPE
398: and S_ENROLMENT_STEP_TYPE = X_S_ENROLMENT_STEP_TYPE;

Line 436: insert into IGS_EN_CAT_PRC_STEP_ALL (

432: x_last_updated_by => X_LAST_UPDATED_BY,
433: x_last_update_login => X_LAST_UPDATE_LOGIN,
434: x_org_id => igs_ge_gen_003.get_org_id
435: );
436: insert into IGS_EN_CAT_PRC_STEP_ALL (
437: ENROLMENT_CAT,
438: S_STUDENT_COMM_TYPE,
439: ENR_METHOD_TYPE,
440: S_ENROLMENT_STEP_TYPE,

Line 488: from IGS_EN_CAT_PRC_STEP_ALL

484: ) AS
485: cursor c1 is select
486: STEP_ORDER_NUM,
487: MANDATORY_STEP_IND
488: from IGS_EN_CAT_PRC_STEP_ALL
489: where ROWID = X_ROWID for update nowait;
490: tlinfo c1%rowtype;
491:
492: begin

Line 562: update IGS_EN_CAT_PRC_STEP_ALL set

558: x_last_update_date => X_LAST_UPDATE_DATE,
559: x_last_updated_by => X_LAST_UPDATED_BY,
560: x_last_update_login => X_LAST_UPDATE_LOGIN
561: );
562: update IGS_EN_CAT_PRC_STEP_ALL set
563: STEP_ORDER_NUM = NEW_REFERENCES.STEP_ORDER_NUM,
564: MANDATORY_STEP_IND = NEW_REFERENCES.MANDATORY_STEP_IND,
565: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
566: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 588: cursor c1 is select rowid from IGS_EN_CAT_PRC_STEP_ALL

584: X_STEP_ORDER_NUM in NUMBER,
585: X_MODE in VARCHAR2 default 'R',
586: x_org_id IN NUMBER
587: ) AS
588: cursor c1 is select rowid from IGS_EN_CAT_PRC_STEP_ALL
589: where ENROLMENT_CAT = X_ENROLMENT_CAT
590: and S_STUDENT_COMM_TYPE = X_S_STUDENT_COMM_TYPE
591: and ENR_METHOD_TYPE = X_ENR_METHOD_TYPE
592: and S_ENROLMENT_STEP_TYPE = X_S_ENROLMENT_STEP_TYPE

Line 630: delete from IGS_EN_CAT_PRC_STEP_ALL

626: Before_DML (
627: p_action => 'DELETE',
628: x_rowid => X_ROWID
629: );
630: delete from IGS_EN_CAT_PRC_STEP_ALL
631: where ROWID = X_ROWID;
632: if (sql%notfound) then
633: raise no_data_found;
634: end if;