PACKAGE: APPS.IGS_EN_CAT_PRC_DTL_PKG

Source

1 package IGS_EN_CAT_PRC_DTL_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSEI15S.pls 115.5 2003/06/11 06:22:56 rnirwani ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ENROLMENT_CAT in VARCHAR2,
6   X_S_STUDENT_COMM_TYPE in VARCHAR2,
7   X_ENR_METHOD_TYPE in VARCHAR2,
8   X_PERSON_ADD_ALLOW_IND in VARCHAR2,
9   X_COURSE_ADD_ALLOW_IND in VARCHAR2,
10   X_MODE in VARCHAR2 default 'R',
11   X_ENFORCE_DATE_ALIAS  IN VARCHAR2 DEFAULT NULL,
12   X_CONFIG_MIN_CP_VALDN IN VARCHAR2 DEFAULT NULL
13   );
14 procedure LOCK_ROW (
15   X_ROWID in  VARCHAR2,
16   X_ENROLMENT_CAT in VARCHAR2,
17   X_S_STUDENT_COMM_TYPE in VARCHAR2,
18   X_ENR_METHOD_TYPE in VARCHAR2,
19   X_PERSON_ADD_ALLOW_IND in VARCHAR2,
20   X_COURSE_ADD_ALLOW_IND in VARCHAR2,
21   X_ENFORCE_DATE_ALIAS  IN VARCHAR2 DEFAULT NULL,
22   X_CONFIG_MIN_CP_VALDN IN VARCHAR2 DEFAULT NULL
23 );
24 procedure UPDATE_ROW (
25   X_ROWID in VARCHAR2,
26   X_ENROLMENT_CAT in VARCHAR2,
27   X_S_STUDENT_COMM_TYPE in VARCHAR2,
28   X_ENR_METHOD_TYPE in VARCHAR2,
29   X_PERSON_ADD_ALLOW_IND in VARCHAR2,
30   X_COURSE_ADD_ALLOW_IND in VARCHAR2,
31   X_MODE in VARCHAR2 default 'R',
32   X_ENFORCE_DATE_ALIAS  IN VARCHAR2 DEFAULT NULL,
33   X_CONFIG_MIN_CP_VALDN IN VARCHAR2 DEFAULT NULL
34   );
35 procedure ADD_ROW (
36   X_ROWID in out NOCOPY VARCHAR2,
37   X_ENROLMENT_CAT in VARCHAR2,
38   X_S_STUDENT_COMM_TYPE in VARCHAR2,
39   X_ENR_METHOD_TYPE in VARCHAR2,
40   X_PERSON_ADD_ALLOW_IND in VARCHAR2,
41   X_COURSE_ADD_ALLOW_IND in VARCHAR2,
42   X_MODE in VARCHAR2 default 'R',
43   X_ENFORCE_DATE_ALIAS  IN VARCHAR2 DEFAULT NULL,
44   X_CONFIG_MIN_CP_VALDN IN VARCHAR2 DEFAULT NULL
45   );
46 procedure DELETE_ROW (
47   X_ROWID in VARCHAR2
48   );
49 FUNCTION Get_PK_For_Validation (
50     x_enrolment_cat IN VARCHAR2,
51     x_s_student_comm_type IN VARCHAR2,
52     x_enr_method_type IN VARCHAR2
53  ) RETURN BOOLEAN;
54 
55 PROCEDURE GET_FK_IGS_EN_METHOD_TYPE (
56     x_enr_method_type IN VARCHAR2
57  );
58 
59 PROCEDURE GET_FK_IGS_EN_ENROLMENT_CAT (
60     x_enrolment_cat IN VARCHAR2
61 );
62 
63  PROCEDURE get_fk_igs_ca_da (
64     x_dt_alias           IN     VARCHAR2
65   );
66 
67 PROCEDURE Check_Constraints (
68  	Column_Name	IN	VARCHAR2	DEFAULT NULL,
69  	Column_Value 	IN	VARCHAR2	DEFAULT NULL
70  );
71 
72 PROCEDURE Before_DML (
73     p_action IN VARCHAR2,
74     x_rowid IN VARCHAR2 DEFAULT NULL,
75     x_enrolment_cat IN VARCHAR2 DEFAULT NULL,
76     x_s_student_comm_type IN VARCHAR2 DEFAULT NULL,
77     x_enr_method_type IN VARCHAR2 DEFAULT NULL,
78     x_person_add_allow_ind IN VARCHAR2 DEFAULT NULL,
79     x_course_add_allow_ind IN VARCHAR2 DEFAULT NULL,
80     x_creation_date IN DATE  DEFAULT NULL,
81     x_created_by IN NUMBER  DEFAULT NULL,
82     x_last_update_date IN DATE  DEFAULT NULL,
83     x_last_updated_by IN NUMBER  DEFAULT NULL,
84     x_last_update_login IN NUMBER  DEFAULT NULL,
85     x_enforce_date_alias  IN VARCHAR2 DEFAULT NULL,
86     x_config_min_cp_valdn IN VARCHAR2 DEFAULT NULL
87   );
88 
89 end IGS_EN_CAT_PRC_DTL_PKG;