1 PACKAGE igs_ps_sch_ocr_cfig_pkg AS
2 /* $Header: IGSPI3QS.pls 120.1 2005/09/08 14:34:23 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_ocr_cfig_id IN OUT NOCOPY NUMBER,
7 x_to_be_announced_roll_flag IN VARCHAR2,
8 x_day_roll_flag IN VARCHAR2,
9 x_time_roll_flag IN VARCHAR2,
10 x_instructor_roll_flag IN VARCHAR2,
11 x_facility_roll_flag IN VARCHAR2,
12 x_schd_not_rqd_roll_flag IN VARCHAR2,
13 x_ref_cd_roll_flag IN VARCHAR2,
14 x_preferred_bld_roll_flag IN VARCHAR2,
15 x_preferred_room_roll_flag IN VARCHAR2,
16 x_dedicated_bld_roll_flag IN VARCHAR2,
17 x_dedicated_room_roll_flag IN VARCHAR2,
18 x_scheduled_bld_roll_flag IN VARCHAR2,
19 x_scheduled_room_roll_flag IN VARCHAR2,
20 x_preferred_region_roll_flag IN VARCHAR2,
21 x_occur_flexfield_roll_flag IN VARCHAR2,
22 x_inc_ins_cng_notfy_roll_flag IN VARCHAR2,
23 x_date_ovrd_flag IN VARCHAR2,
24 x_day_ovrd_flag IN VARCHAR2,
25 x_time_ovrd_flag IN VARCHAR2,
26 x_instructor_ovrd_flag IN VARCHAR2,
27 x_scheduled_bld_ovrd_flag IN VARCHAR2,
28 x_scheduled_room_ovrd_flag IN VARCHAR2,
29 x_mode IN VARCHAR2 DEFAULT 'R'
30 );
31
32 PROCEDURE lock_row (
33 x_rowid IN VARCHAR2,
34 x_ocr_cfig_id IN NUMBER,
35 x_to_be_announced_roll_flag IN VARCHAR2,
36 x_day_roll_flag IN VARCHAR2,
37 x_time_roll_flag IN VARCHAR2,
38 x_instructor_roll_flag IN VARCHAR2,
39 x_facility_roll_flag IN VARCHAR2,
40 x_schd_not_rqd_roll_flag IN VARCHAR2,
41 x_ref_cd_roll_flag IN VARCHAR2,
42 x_preferred_bld_roll_flag IN VARCHAR2,
43 x_preferred_room_roll_flag IN VARCHAR2,
44 x_dedicated_bld_roll_flag IN VARCHAR2,
45 x_dedicated_room_roll_flag IN VARCHAR2,
46 x_scheduled_bld_roll_flag IN VARCHAR2,
47 x_scheduled_room_roll_flag IN VARCHAR2,
48 x_preferred_region_roll_flag IN VARCHAR2,
49 x_occur_flexfield_roll_flag IN VARCHAR2,
50 x_inc_ins_cng_notfy_roll_flag IN VARCHAR2,
51 x_date_ovrd_flag IN VARCHAR2,
52 x_day_ovrd_flag IN VARCHAR2,
53 x_time_ovrd_flag IN VARCHAR2,
54 x_instructor_ovrd_flag IN VARCHAR2,
55 x_scheduled_bld_ovrd_flag IN VARCHAR2,
56 x_scheduled_room_ovrd_flag IN VARCHAR2
57 );
58
59 PROCEDURE update_row (
60 x_rowid IN VARCHAR2,
61 x_ocr_cfig_id IN NUMBER,
62 x_to_be_announced_roll_flag IN VARCHAR2,
63 x_day_roll_flag IN VARCHAR2,
64 x_time_roll_flag IN VARCHAR2,
65 x_instructor_roll_flag IN VARCHAR2,
66 x_facility_roll_flag IN VARCHAR2,
67 x_schd_not_rqd_roll_flag IN VARCHAR2,
68 x_ref_cd_roll_flag IN VARCHAR2,
69 x_preferred_bld_roll_flag IN VARCHAR2,
70 x_preferred_room_roll_flag IN VARCHAR2,
71 x_dedicated_bld_roll_flag IN VARCHAR2,
72 x_dedicated_room_roll_flag IN VARCHAR2,
73 x_scheduled_bld_roll_flag IN VARCHAR2,
74 x_scheduled_room_roll_flag IN VARCHAR2,
75 x_preferred_region_roll_flag IN VARCHAR2,
76 x_occur_flexfield_roll_flag IN VARCHAR2,
77 x_inc_ins_cng_notfy_roll_flag IN VARCHAR2,
78 x_date_ovrd_flag IN VARCHAR2,
79 x_day_ovrd_flag IN VARCHAR2,
80 x_time_ovrd_flag IN VARCHAR2,
81 x_instructor_ovrd_flag IN VARCHAR2,
82 x_scheduled_bld_ovrd_flag IN VARCHAR2,
83 x_scheduled_room_ovrd_flag IN VARCHAR2,
84 x_mode IN VARCHAR2 DEFAULT 'R'
85 );
86
87 PROCEDURE add_row (
88 x_rowid IN OUT NOCOPY VARCHAR2,
89 x_ocr_cfig_id IN OUT NOCOPY NUMBER,
90 x_to_be_announced_roll_flag IN VARCHAR2,
91 x_day_roll_flag IN VARCHAR2,
92 x_time_roll_flag IN VARCHAR2,
93 x_instructor_roll_flag IN VARCHAR2,
94 x_facility_roll_flag IN VARCHAR2,
95 x_schd_not_rqd_roll_flag IN VARCHAR2,
96 x_ref_cd_roll_flag IN VARCHAR2,
97 x_preferred_bld_roll_flag IN VARCHAR2,
98 x_preferred_room_roll_flag IN VARCHAR2,
99 x_dedicated_bld_roll_flag IN VARCHAR2,
100 x_dedicated_room_roll_flag IN VARCHAR2,
101 x_scheduled_bld_roll_flag IN VARCHAR2,
102 x_scheduled_room_roll_flag IN VARCHAR2,
103 x_preferred_region_roll_flag IN VARCHAR2,
104 x_occur_flexfield_roll_flag IN VARCHAR2,
105 x_inc_ins_cng_notfy_roll_flag IN VARCHAR2,
106 x_date_ovrd_flag IN VARCHAR2,
107 x_day_ovrd_flag IN VARCHAR2,
108 x_time_ovrd_flag IN VARCHAR2,
109 x_instructor_ovrd_flag IN VARCHAR2,
110 x_scheduled_bld_ovrd_flag IN VARCHAR2,
111 x_scheduled_room_ovrd_flag IN VARCHAR2,
112 x_mode IN VARCHAR2 DEFAULT 'R'
113 );
114
115 PROCEDURE delete_row (
116 x_rowid IN VARCHAR2
117 );
118
119 FUNCTION get_pk_for_validation (
120 x_ocr_cfig_id IN NUMBER
121 ) RETURN BOOLEAN;
122
123 PROCEDURE before_dml (
124 p_action IN VARCHAR2,
125 x_rowid IN VARCHAR2 DEFAULT NULL,
126 x_ocr_cfig_id IN NUMBER DEFAULT NULL,
127 x_to_be_announced_roll_flag IN VARCHAR2 DEFAULT NULL,
128 x_day_roll_flag IN VARCHAR2 DEFAULT NULL,
129 x_time_roll_flag IN VARCHAR2 DEFAULT NULL,
130 x_instructor_roll_flag IN VARCHAR2 DEFAULT NULL,
131 x_facility_roll_flag IN VARCHAR2 DEFAULT NULL,
132 x_schd_not_rqd_roll_flag IN VARCHAR2 DEFAULT NULL,
133 x_ref_cd_roll_flag IN VARCHAR2 DEFAULT NULL,
134 x_preferred_bld_roll_flag IN VARCHAR2 DEFAULT NULL,
135 x_preferred_room_roll_flag IN VARCHAR2 DEFAULT NULL,
136 x_dedicated_bld_roll_flag IN VARCHAR2 DEFAULT NULL,
137 x_dedicated_room_roll_flag IN VARCHAR2 DEFAULT NULL,
138 x_scheduled_bld_roll_flag IN VARCHAR2 DEFAULT NULL,
139 x_scheduled_room_roll_flag IN VARCHAR2 DEFAULT NULL,
140 x_preferred_region_roll_flag IN VARCHAR2 DEFAULT NULL,
141 x_occur_flexfield_roll_flag IN VARCHAR2 DEFAULT NULL,
142 x_inc_ins_cng_notfy_roll_flag IN VARCHAR2 DEFAULT NULL,
143 x_date_ovrd_flag IN VARCHAR2 DEFAULT NULL,
144 x_day_ovrd_flag IN VARCHAR2 DEFAULT NULL,
145 x_time_ovrd_flag IN VARCHAR2 DEFAULT NULL,
146 x_instructor_ovrd_flag IN VARCHAR2 DEFAULT NULL,
147 x_scheduled_bld_ovrd_flag IN VARCHAR2 DEFAULT NULL,
148 x_scheduled_room_ovrd_flag IN VARCHAR2 DEFAULT NULL,
149 x_creation_date IN DATE DEFAULT NULL,
150 x_created_by IN NUMBER DEFAULT NULL,
151 x_last_update_date IN DATE DEFAULT NULL,
152 x_last_updated_by IN NUMBER DEFAULT NULL,
153 x_last_update_login IN NUMBER DEFAULT NULL
154 );
155
156 END igs_ps_sch_ocr_cfig_pkg;