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_PS_PAT_OF_STUDY_PKG

Source


1 package IGS_PS_PAT_OF_STUDY_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSPI61S.pls 115.4 2002/11/29 02:33:13 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_COURSE_CD in VARCHAR2,
6   X_CAL_TYPE in VARCHAR2,
7   X_VERSION_NUMBER in NUMBER,
8   X_SEQUENCE_NUMBER in NUMBER,
9   X_LOCATION_CD in VARCHAR2,
10   X_ATTENDANCE_MODE in VARCHAR2,
11   X_ATTENDANCE_TYPE in VARCHAR2,
12   X_UNIT_SET_CD in VARCHAR2,
13   X_ADMISSION_CAL_TYPE in VARCHAR2,
14   X_ADMISSION_CAT in VARCHAR2,
15   X_APRVD_CI_SEQUENCE_NUMBER in NUMBER,
16   X_NUMBER_OF_PERIODS in NUMBER,
17   X_ALWAYS_PRE_ENROL_IND in VARCHAR2,
18   X_ACAD_PERD_UNIT_SET in VARCHAR2 default NULL ,
19   X_MODE in VARCHAR2 default 'R'
20   );
21 procedure LOCK_ROW (
22   X_ROWID in VARCHAR2,
23   X_COURSE_CD in VARCHAR2,
24   X_CAL_TYPE in VARCHAR2,
25   X_VERSION_NUMBER in NUMBER,
26   X_SEQUENCE_NUMBER in NUMBER,
27   X_LOCATION_CD in VARCHAR2,
28   X_ATTENDANCE_MODE in VARCHAR2,
29   X_ATTENDANCE_TYPE in VARCHAR2,
30   X_UNIT_SET_CD in VARCHAR2,
31   X_ADMISSION_CAL_TYPE in VARCHAR2,
32   X_ADMISSION_CAT in VARCHAR2,
33   X_APRVD_CI_SEQUENCE_NUMBER in NUMBER,
34   X_NUMBER_OF_PERIODS in NUMBER,
35   X_ALWAYS_PRE_ENROL_IND in VARCHAR2,
36   X_ACAD_PERD_UNIT_SET in VARCHAR2 default NULL
37 );
38 procedure UPDATE_ROW (
39   X_ROWID in VARCHAR2,
40   X_COURSE_CD in VARCHAR2,
41   X_CAL_TYPE in VARCHAR2,
42   X_VERSION_NUMBER in NUMBER,
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_UNIT_SET_CD in VARCHAR2,
48   X_ADMISSION_CAL_TYPE in VARCHAR2,
49   X_ADMISSION_CAT in VARCHAR2,
50   X_APRVD_CI_SEQUENCE_NUMBER in NUMBER,
51   X_NUMBER_OF_PERIODS in NUMBER,
52   X_ALWAYS_PRE_ENROL_IND in VARCHAR2,
53   X_ACAD_PERD_UNIT_SET in VARCHAR2 default NULL,
54   X_MODE in VARCHAR2 default 'R'
55   );
56 procedure ADD_ROW (
57   X_ROWID in out NOCOPY VARCHAR2,
58   X_COURSE_CD in VARCHAR2,
59   X_CAL_TYPE in VARCHAR2,
60   X_VERSION_NUMBER in NUMBER,
61   X_SEQUENCE_NUMBER in NUMBER,
62   X_LOCATION_CD in VARCHAR2,
63   X_ATTENDANCE_MODE in VARCHAR2,
64   X_ATTENDANCE_TYPE in VARCHAR2,
65   X_UNIT_SET_CD in VARCHAR2,
66   X_ADMISSION_CAL_TYPE in VARCHAR2,
67   X_ADMISSION_CAT in VARCHAR2,
68   X_APRVD_CI_SEQUENCE_NUMBER in NUMBER,
69   X_NUMBER_OF_PERIODS in NUMBER,
70   X_ALWAYS_PRE_ENROL_IND in VARCHAR2,
71   X_ACAD_PERD_UNIT_SET in VARCHAR2 default NULL,
72   X_MODE in VARCHAR2 default 'R'
73   );
74 procedure DELETE_ROW (
75   X_ROWID in VARCHAR2
76 );
77   FUNCTION Get_PK_For_Validation (
78     x_course_cd IN VARCHAR2,
79     x_version_number IN NUMBER,
80     x_cal_type IN VARCHAR2,
81     x_sequence_number IN NUMBER
82     ) RETURN BOOLEAN;
83 
84   PROCEDURE GET_FK_IGS_AD_CAT (
85     x_admission_cat IN VARCHAR2
86     );
87 
88   PROCEDURE GET_FK_IGS_EN_ATD_MODE (
89     x_attendance_mode IN VARCHAR2
90     );
91 
92   PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
93     x_attendance_type IN VARCHAR2
94     );
95 
96   PROCEDURE GET_FK_IGS_CA_TYPE (
97     x_cal_type IN VARCHAR2
98     );
99 
100   PROCEDURE GET_FK_IGS_CA_INST (
101     x_cal_type IN VARCHAR2,
102     x_sequence_number IN NUMBER
103     );
104 
105   PROCEDURE GET_FK_IGS_PS_OFR (
106     x_course_cd IN VARCHAR2,
107     x_version_number IN NUMBER,
108     x_cal_type IN VARCHAR2
109     );
110 
111   PROCEDURE GET_FK_IGS_AD_LOCATION (
112     x_location_cd IN VARCHAR2
113     );
114   PROCEDURE Check_Constraints (
115    Column_Name	IN	VARCHAR2	DEFAULT NULL,
116    Column_Value 	IN	VARCHAR2	DEFAULT NULL
117    );
118   PROCEDURE Before_DML (
119     p_action IN VARCHAR2,
120     x_rowid IN VARCHAR2 DEFAULT NULL,
121     x_course_cd IN VARCHAR2 DEFAULT NULL,
122     x_version_number IN NUMBER DEFAULT NULL,
123     x_cal_type IN VARCHAR2 DEFAULT NULL,
124     x_sequence_number IN NUMBER DEFAULT NULL,
125     x_location_cd IN VARCHAR2 DEFAULT NULL,
126     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
127     x_attendance_type IN VARCHAR2 DEFAULT NULL,
128     x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
129     x_admission_cal_type IN VARCHAR2 DEFAULT NULL,
130     x_admission_cat IN VARCHAR2 DEFAULT NULL,
131     x_aprvd_ci_sequence_number IN NUMBER DEFAULT NULL,
132     x_number_of_periods IN NUMBER DEFAULT NULL,
133     x_always_pre_enrol_ind IN VARCHAR2 DEFAULT NULL,
134     X_ACAD_PERD_UNIT_SET in VARCHAR2 default NULL,
135     x_creation_date IN DATE DEFAULT NULL,
136     x_created_by IN NUMBER DEFAULT NULL,
137     x_last_update_date IN DATE DEFAULT NULL,
138     x_last_updated_by IN NUMBER DEFAULT NULL,
139     x_last_update_login IN NUMBER DEFAULT NULL
140   );
141 
142 end IGS_PS_PAT_OF_STUDY_PKG;