eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_AD_PRD_PS_OF_OPT_PKG

Source


1 package IGS_AD_PRD_PS_OF_OPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSAI31S.pls 115.4 2002/11/28 22:02:22 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ADM_CAL_TYPE in VARCHAR2,
6   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
7   X_ADMISSION_CAT in VARCHAR2,
8   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
9   X_COURSE_CD in VARCHAR2,
10   X_VERSION_NUMBER in NUMBER,
11   X_ACAD_CAL_TYPE in VARCHAR2,
12   X_SEQUENCE_NUMBER in NUMBER,
13   X_LOCATION_CD in VARCHAR2,
14   X_ATTENDANCE_MODE in VARCHAR2,
15   X_ATTENDANCE_TYPE in VARCHAR2,
16   X_ROLLOVER_INCLUSION_IND in VARCHAR2,
17   X_MODE in VARCHAR2 default 'R'
18   );
19 procedure LOCK_ROW (
20   X_ROWID in VARCHAR2,
21   X_ADM_CAL_TYPE in VARCHAR2,
22   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
23   X_ADMISSION_CAT in VARCHAR2,
24   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
25   X_COURSE_CD in VARCHAR2,
26   X_VERSION_NUMBER in NUMBER,
27   X_ACAD_CAL_TYPE in VARCHAR2,
28   X_SEQUENCE_NUMBER in NUMBER,
29   X_LOCATION_CD in VARCHAR2,
30   X_ATTENDANCE_MODE in VARCHAR2,
31   X_ATTENDANCE_TYPE in VARCHAR2,
32   X_ROLLOVER_INCLUSION_IND in VARCHAR2
33 );
34 procedure UPDATE_ROW (
35   X_ROWID in VARCHAR2,
36   X_ADM_CAL_TYPE in VARCHAR2,
37   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
38   X_ADMISSION_CAT in VARCHAR2,
39   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
40   X_COURSE_CD in VARCHAR2,
41   X_VERSION_NUMBER in NUMBER,
42   X_ACAD_CAL_TYPE in VARCHAR2,
43   X_SEQUENCE_NUMBER in NUMBER,
44   X_LOCATION_CD in VARCHAR2,
45   X_ATTENDANCE_MODE in VARCHAR2,
46   X_ATTENDANCE_TYPE in VARCHAR2,
47   X_ROLLOVER_INCLUSION_IND in VARCHAR2,
48   X_MODE in VARCHAR2 default 'R'
49   );
50 procedure ADD_ROW (
51   X_ROWID in out NOCOPY VARCHAR2,
52   X_ADM_CAL_TYPE in VARCHAR2,
53   X_ADM_CI_SEQUENCE_NUMBER in NUMBER,
54   X_ADMISSION_CAT in VARCHAR2,
55   X_S_ADMISSION_PROCESS_TYPE in VARCHAR2,
56   X_COURSE_CD in VARCHAR2,
57   X_VERSION_NUMBER in NUMBER,
58   X_ACAD_CAL_TYPE in VARCHAR2,
59   X_SEQUENCE_NUMBER in NUMBER,
60   X_LOCATION_CD in VARCHAR2,
61   X_ATTENDANCE_MODE in VARCHAR2,
62   X_ATTENDANCE_TYPE in VARCHAR2,
63   X_ROLLOVER_INCLUSION_IND in VARCHAR2,
64   X_MODE in VARCHAR2 default 'R'
65   );
66 procedure DELETE_ROW (
67   X_ROWID in VARCHAR2
68 );
69 FUNCTION Get_PK_For_Validation (
70     x_adm_cal_type IN VARCHAR2,
71     x_adm_ci_sequence_number IN NUMBER,
72     x_admission_cat IN VARCHAR2,
73     x_s_admission_process_type IN VARCHAR2,
74     x_course_cd IN VARCHAR2,
75     x_version_number IN NUMBER,
76     x_acad_cal_type IN VARCHAR2,
77     x_sequence_number IN NUMBER
78     )
79 RETURN BOOLEAN;
80 
81 PROCEDURE Check_constraints(
82   	Column_Name 	IN	VARCHAR2 DEFAULT NULL,
83 	Column_Value 	IN	VARCHAR2 DEFAULT NULL
84 	);
85 
86   PROCEDURE Before_DML (
87     p_action IN VARCHAR2,
88     x_rowid IN VARCHAR2 DEFAULT NULL,
89     x_adm_cal_type IN VARCHAR2 DEFAULT NULL,
90     x_adm_ci_sequence_number IN NUMBER DEFAULT NULL,
91     x_admission_cat IN VARCHAR2 DEFAULT NULL,
92     x_s_admission_process_type IN VARCHAR2 DEFAULT NULL,
93     x_course_cd IN VARCHAR2 DEFAULT NULL,
94     x_version_number IN NUMBER DEFAULT NULL,
95     x_acad_cal_type IN VARCHAR2 DEFAULT NULL,
96     x_sequence_number IN NUMBER DEFAULT NULL,
97     x_location_cd IN VARCHAR2 DEFAULT NULL,
98     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
99     x_attendance_type IN VARCHAR2 DEFAULT NULL,
100     x_rollover_inclusion_ind IN VARCHAR2 DEFAULT NULL,
101     x_creation_date IN DATE DEFAULT NULL,
102     x_created_by IN NUMBER DEFAULT NULL,
103     x_last_update_date IN DATE DEFAULT NULL,
104     x_last_updated_by IN NUMBER DEFAULT NULL,
105     x_last_update_login IN NUMBER DEFAULT NULL
106   );
107 
108   PROCEDURE GET_FK_IGS_EN_ATD_MODE (
109     x_attendance_mode IN VARCHAR2
110     );
111 
112   PROCEDURE GET_FK_IGS_AD_PRD_AD_PRC_CA (
113     x_adm_cal_type IN VARCHAR2,
114     x_adm_ci_sequence_number IN NUMBER,
115     x_admission_cat IN VARCHAR2,
116     x_s_admission_process_type IN VARCHAR2
117     );
118 
119   PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
120     x_attendance_type IN VARCHAR2
121     );
122 
123   PROCEDURE GET_FK_IGS_PS_OFR (
124     x_course_cd IN VARCHAR2,
125     x_version_number IN NUMBER,
126     x_cal_type IN VARCHAR2
127     );
128 
129   PROCEDURE GET_FK_IGS_AD_LOCATION (
130     x_location_cd IN VARCHAR2
131     );
132 end IGS_AD_PRD_PS_OF_OPT_PKG;