PACKAGE: APPS.IGS_AS_ITM_EXAM_MTRL_PKG

Source

1 package IGS_AS_ITM_EXAM_MTRL_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSDI03S.pls 115.3 2002/11/28 23:10:59 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ASS_ID in NUMBER,
6   X_EXAM_MATERIAL_TYPE in VARCHAR2,
7   X_S_MATERIAL_CAT in VARCHAR2,
8   X_QUANTITY_PER_STUDENT in NUMBER,
9   X_COMMENTS in VARCHAR2,
10   X_MODE in VARCHAR2 default 'R'
11   );
12 procedure LOCK_ROW (
13   X_ROWID in VARCHAR2,
14   X_ASS_ID in NUMBER,
15   X_EXAM_MATERIAL_TYPE in VARCHAR2,
16   X_S_MATERIAL_CAT in VARCHAR2,
17   X_QUANTITY_PER_STUDENT in NUMBER,
18   X_COMMENTS in VARCHAR2
19 );
20 procedure UPDATE_ROW (
21   X_ROWID in VARCHAR2,
22   X_ASS_ID in NUMBER,
23   X_EXAM_MATERIAL_TYPE in VARCHAR2,
24   X_S_MATERIAL_CAT in VARCHAR2,
25   X_QUANTITY_PER_STUDENT in NUMBER,
26   X_COMMENTS in VARCHAR2,
27   X_MODE in VARCHAR2 default 'R'
28   );
29 procedure ADD_ROW (
30   X_ROWID in out NOCOPY VARCHAR2,
31   X_ASS_ID in NUMBER,
32   X_EXAM_MATERIAL_TYPE in VARCHAR2,
33   X_S_MATERIAL_CAT in VARCHAR2,
34   X_QUANTITY_PER_STUDENT in NUMBER,
35   X_COMMENTS in VARCHAR2,
36   X_MODE in VARCHAR2 default 'R'
37   );
38 procedure DELETE_ROW (
39   X_ROWID in VARCHAR2
40 );
41   FUNCTION Get_PK_For_Validation (
42     x_ass_id IN NUMBER,
43     x_exam_material_type IN VARCHAR2
44     ) RETURN BOOLEAN;
45 
46   PROCEDURE GET_FK_IGS_AS_ASSESSMNT_ITM (
47     x_ass_id IN NUMBER
48     );
49 
50   PROCEDURE GET_FK_IGS_AS_EXM_MTRL_TYPE (
51     x_exam_material_type IN VARCHAR2
52     );
53 
54 
55 
56 
57 
58 
59 
60 
61 
62 	PROCEDURE Check_Constraints (
63 
64 
65 
66 
67 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
68 
69 
70 
71 
72 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
73 
74 
75 
76 
77 );
78 
79 
80 
81 
82   PROCEDURE Before_DML (
83 
84 
85 
86 
87     p_action IN VARCHAR2,
88 
89 
90 
91 
92     x_rowid IN VARCHAR2 DEFAULT NULL,
93 
94 
95 
96 
97     x_ass_id IN NUMBER DEFAULT NULL,
98 
99 
100 
101 
102     x_exam_material_type IN VARCHAR2 DEFAULT NULL,
103 
104 
105 
106 
107     x_s_material_cat IN VARCHAR2 DEFAULT NULL,
108 
109 
110 
111 
112     x_quantity_per_student IN NUMBER DEFAULT NULL,
113 
114 
115 
116 
117     x_comments IN VARCHAR2 DEFAULT NULL,
118 
119 
120 
121 
122     x_creation_date IN DATE DEFAULT NULL,
123 
124 
125 
126 
127     x_created_by IN NUMBER DEFAULT NULL,
128 
129 
130 
131 
132     x_last_update_date IN DATE DEFAULT NULL,
133 
134 
135 
136 
137     x_last_updated_by IN NUMBER DEFAULT NULL,
138 
139 
140 
141 
142     x_last_update_login IN NUMBER DEFAULT NULL
143 
144 
145 
146 
147   ) ;
148 
149 end IGS_AS_ITM_EXAM_MTRL_PKG;