DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PE_EV_FORM_PKG

Source


1 PACKAGE igs_pe_ev_form_pkg AS
2 /* $Header: IGSNI51S.pls 120.1 2006/02/17 06:53:58 gmaheswa noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_ev_form_id                        IN OUT NOCOPY NUMBER,
7     x_person_id                         IN     NUMBER,
8     x_print_form                        IN     VARCHAR2,
9     x_form_effective_date               IN     DATE,
10     x_form_status                       IN     VARCHAR2,
11     x_create_reason                     IN     VARCHAR2,
12     x_is_valid                          IN     VARCHAR2,
13     x_prgm_sponsor_amt                  IN     NUMBER,
14     x_govt_org1_amt                     IN     NUMBER,
15     x_govt_org1_code                    IN     VARCHAR2,
16     x_govt_org2_amt                     IN     NUMBER,
17     x_govt_org2_code                    IN     VARCHAR2,
18     x_intl_org1_amt                     IN     NUMBER,
19     x_intl_org1_code                    IN     VARCHAR2,
20     x_intl_org2_amt                     IN     NUMBER,
21     x_intl_org2_code                    IN     VARCHAR2,
22     x_ev_govt_amt                       IN     NUMBER,
23     x_bi_natnl_com_amt                  IN     NUMBER,
24     x_other_govt_amt                    IN     NUMBER,
25     x_personal_funds_amt                IN     NUMBER,
26     x_ev_form_number                    IN     VARCHAR2,
27     x_prgm_start_date                   IN     DATE,
28     x_prgm_end_date                     IN     DATE,
29     x_last_reprint_date                 IN     DATE,
30     x_reprint_reason                    IN     VARCHAR2,
31     x_reprint_remarks                   IN     VARCHAR2,
32     x_position_code                     IN     NUMBER,
33     x_position_remarks                  IN     VARCHAR2,
34     x_subject_field_code                IN     VARCHAR2,
35     x_subject_field_remarks             IN     VARCHAR2,
36     x_matriculation                     IN     VARCHAR2,
37     x_remarks                           IN     VARCHAR2,
38     x_mode                              IN     VARCHAR2    DEFAULT 'R',
39     x_category_code                     IN     VARCHAR2,
40     x_init_prgm_start_date              IN     DATE,
41     x_govt_org1_othr_name               IN     VARCHAR2 DEFAULT NULL,
42     x_govt_org2_othr_name               IN     VARCHAR2 DEFAULT NULL,
43     x_intl_org1_othr_name               IN     VARCHAR2 DEFAULT NULL,
44     x_intl_org2_othr_name               IN     VARCHAR2 DEFAULT NULL,
45     x_no_show_flag			IN     VARCHAR2 DEFAULT 'N',
46     x_other_govt_name			IN     VARCHAR2 DEFAULT NULL,
47     x_sevis_school_id                   IN     NUMBER DEFAULT NULL
48   );
49 
50   PROCEDURE lock_row (
51     x_rowid                             IN     VARCHAR2,
52     x_ev_form_id                        IN     NUMBER,
53     x_person_id                         IN     NUMBER,
54     x_print_form                        IN     VARCHAR2,
55     x_form_effective_date               IN     DATE,
56     x_form_status                       IN     VARCHAR2,
57     x_create_reason                     IN     VARCHAR2,
58     x_is_valid                          IN     VARCHAR2,
59     x_prgm_sponsor_amt                  IN     NUMBER,
60     x_govt_org1_amt                     IN     NUMBER,
61     x_govt_org1_code                    IN     VARCHAR2,
62     x_govt_org2_amt                     IN     NUMBER,
63     x_govt_org2_code                    IN     VARCHAR2,
64     x_intl_org1_amt                     IN     NUMBER,
65     x_intl_org1_code                    IN     VARCHAR2,
66     x_intl_org2_amt                     IN     NUMBER,
67     x_intl_org2_code                    IN     VARCHAR2,
68     x_ev_govt_amt                       IN     NUMBER,
69     x_bi_natnl_com_amt                  IN     NUMBER,
70     x_other_govt_amt                    IN     NUMBER,
71     x_personal_funds_amt                IN     NUMBER,
72     x_ev_form_number                    IN     VARCHAR2,
73     x_prgm_start_date                   IN     DATE,
74     x_prgm_end_date                     IN     DATE,
75     x_last_reprint_date                 IN     DATE,
76     x_reprint_reason                    IN     VARCHAR2,
77     x_reprint_remarks                   IN     VARCHAR2,
78     x_position_code                     IN     NUMBER,
79     x_position_remarks                  IN     VARCHAR2,
80     x_subject_field_code                IN     VARCHAR2,
81     x_subject_field_remarks             IN     VARCHAR2,
82     x_matriculation                     IN     VARCHAR2,
83     x_remarks                           IN     VARCHAR2 ,
84     x_category_code                     IN     VARCHAR2,
85     x_init_prgm_start_date              IN     DATE,
86     x_govt_org1_othr_name               IN     VARCHAR2,
87     x_govt_org2_othr_name               IN     VARCHAR2,
88     x_intl_org1_othr_name               IN     VARCHAR2,
89     x_intl_org2_othr_name               IN     VARCHAR2,
90     x_no_show_flag			IN     VARCHAR2 DEFAULT 'N',
91     x_other_govt_name			IN     VARCHAR2 DEFAULT NULL,
92     x_sevis_school_id                   IN     NUMBER DEFAULT NULL
93   );
94 
95   PROCEDURE update_row (
96     x_rowid                             IN     VARCHAR2,
97     x_ev_form_id                        IN     NUMBER,
98     x_person_id                         IN     NUMBER,
99     x_print_form                        IN     VARCHAR2,
100     x_form_effective_date               IN     DATE,
101     x_form_status                       IN     VARCHAR2,
102     x_create_reason                     IN     VARCHAR2,
103     x_is_valid                          IN     VARCHAR2,
104     x_prgm_sponsor_amt                  IN     NUMBER,
105     x_govt_org1_amt                     IN     NUMBER,
106     x_govt_org1_code                    IN     VARCHAR2,
107     x_govt_org2_amt                     IN     NUMBER,
108     x_govt_org2_code                    IN     VARCHAR2,
109     x_intl_org1_amt                     IN     NUMBER,
110     x_intl_org1_code                    IN     VARCHAR2,
111     x_intl_org2_amt                     IN     NUMBER,
112     x_intl_org2_code                    IN     VARCHAR2,
113     x_ev_govt_amt                       IN     NUMBER,
114     x_bi_natnl_com_amt                  IN     NUMBER,
115     x_other_govt_amt                    IN     NUMBER,
116     x_personal_funds_amt                IN     NUMBER,
117     x_ev_form_number                    IN     VARCHAR2,
118     x_prgm_start_date                   IN     DATE,
119     x_prgm_end_date                     IN     DATE,
120     x_last_reprint_date                 IN     DATE,
121     x_reprint_reason                    IN     VARCHAR2,
122     x_reprint_remarks                   IN     VARCHAR2,
123     x_position_code                     IN     NUMBER,
124     x_position_remarks                  IN     VARCHAR2,
125     x_subject_field_code                IN     VARCHAR2,
126     x_subject_field_remarks             IN     VARCHAR2,
127     x_matriculation                     IN     VARCHAR2,
128     x_remarks                           IN     VARCHAR2,
129     x_mode                              IN     VARCHAR2    DEFAULT 'R'  ,
130     x_category_code                     IN     VARCHAR2,
131     x_init_prgm_start_date              IN     DATE,
132     x_govt_org1_othr_name               IN     VARCHAR2 DEFAULT NULL,
133     x_govt_org2_othr_name               IN     VARCHAR2 DEFAULT NULL,
134     x_intl_org1_othr_name               IN     VARCHAR2 DEFAULT NULL,
135     x_intl_org2_othr_name               IN     VARCHAR2 DEFAULT NULL,
136     x_no_show_flag			IN     VARCHAR2 DEFAULT 'N',
137     x_other_govt_name			IN     VARCHAR2 DEFAULT NULL,
138     x_sevis_school_id                   IN     NUMBER DEFAULT NULL
139   );
140 
141   PROCEDURE add_row (
142     x_rowid                             IN OUT NOCOPY VARCHAR2,
143     x_ev_form_id                        IN OUT NOCOPY NUMBER,
144     x_person_id                         IN     NUMBER,
145     x_print_form                        IN     VARCHAR2,
146     x_form_effective_date               IN     DATE,
147     x_form_status                       IN     VARCHAR2,
148     x_create_reason                     IN     VARCHAR2,
149     x_is_valid                          IN     VARCHAR2,
150     x_prgm_sponsor_amt                  IN     NUMBER,
151     x_govt_org1_amt                     IN     NUMBER,
152     x_govt_org1_code                    IN     VARCHAR2,
153     x_govt_org2_amt                     IN     NUMBER,
154     x_govt_org2_code                    IN     VARCHAR2,
155     x_intl_org1_amt                     IN     NUMBER,
156     x_intl_org1_code                    IN     VARCHAR2,
157     x_intl_org2_amt                     IN     NUMBER,
158     x_intl_org2_code                    IN     VARCHAR2,
159     x_ev_govt_amt                       IN     NUMBER,
160     x_bi_natnl_com_amt                  IN     NUMBER,
161     x_other_govt_amt                    IN     NUMBER,
162     x_personal_funds_amt                IN     NUMBER,
163     x_ev_form_number                    IN     VARCHAR2,
164     x_prgm_start_date                   IN     DATE,
165     x_prgm_end_date                     IN     DATE,
166     x_last_reprint_date                 IN     DATE,
167     x_reprint_reason                    IN     VARCHAR2,
168     x_reprint_remarks                   IN     VARCHAR2,
169     x_position_code                     IN     NUMBER,
170     x_position_remarks                  IN     VARCHAR2,
171     x_subject_field_code                IN     VARCHAR2,
172     x_subject_field_remarks             IN     VARCHAR2,
173     x_matriculation                     IN     VARCHAR2,
174     x_remarks                           IN     VARCHAR2,
175     x_mode                              IN     VARCHAR2    DEFAULT 'R'   ,
176     x_category_code                     IN     VARCHAR2,
177     x_init_prgm_start_date              IN     DATE,
178     x_govt_org1_othr_name               IN     VARCHAR2 DEFAULT NULL,
179     x_govt_org2_othr_name               IN     VARCHAR2 DEFAULT NULL,
180     x_intl_org1_othr_name               IN     VARCHAR2 DEFAULT NULL,
181     x_intl_org2_othr_name               IN     VARCHAR2 DEFAULT NULL,
182     x_no_show_flag			IN     VARCHAR2 DEFAULT 'N',
183     x_other_govt_name			IN     VARCHAR2 DEFAULT NULL,
184     x_sevis_school_id                   IN     NUMBER DEFAULT NULL
185   );
186 
187   PROCEDURE delete_row (
188     x_rowid                             IN     VARCHAR2,
189   x_mode IN VARCHAR2 DEFAULT 'R'
190   );
191 
192   FUNCTION get_pk_for_validation (
193     x_ev_form_id                        IN     NUMBER
194   ) RETURN BOOLEAN;
195 
196   PROCEDURE before_dml (
197     p_action                            IN     VARCHAR2,
198     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
199     x_ev_form_id                        IN     NUMBER      DEFAULT NULL,
200     x_person_id                         IN     NUMBER      DEFAULT NULL,
201     x_print_form                        IN     VARCHAR2    DEFAULT NULL,
202     x_form_effective_date               IN     DATE        DEFAULT NULL,
203     x_form_status                       IN     VARCHAR2    DEFAULT NULL,
204     x_create_reason                     IN     VARCHAR2    DEFAULT NULL,
205     x_is_valid                          IN     VARCHAR2    DEFAULT NULL,
206     x_prgm_sponsor_amt                  IN     NUMBER      DEFAULT NULL,
207     x_govt_org1_amt                     IN     NUMBER      DEFAULT NULL,
208     x_govt_org1_code                    IN     VARCHAR2    DEFAULT NULL,
209     x_govt_org2_amt                     IN     NUMBER      DEFAULT NULL,
210     x_govt_org2_code                    IN     VARCHAR2    DEFAULT NULL,
211     x_intl_org1_amt                     IN     NUMBER      DEFAULT NULL,
212     x_intl_org1_code                    IN     VARCHAR2    DEFAULT NULL,
213     x_intl_org2_amt                     IN     NUMBER      DEFAULT NULL,
214     x_intl_org2_code                    IN     VARCHAR2    DEFAULT NULL,
215     x_ev_govt_amt                       IN     NUMBER      DEFAULT NULL,
216     x_bi_natnl_com_amt                  IN     NUMBER      DEFAULT NULL,
217     x_other_govt_amt                    IN     NUMBER      DEFAULT NULL,
218     x_personal_funds_amt                IN     NUMBER      DEFAULT NULL,
219     x_ev_form_number                    IN     VARCHAR2    DEFAULT NULL,
220     x_prgm_start_date                   IN     DATE        DEFAULT NULL,
221     x_prgm_end_date                     IN     DATE        DEFAULT NULL,
222     x_last_reprint_date                 IN     DATE        DEFAULT NULL,
223     x_reprint_reason                    IN     VARCHAR2    DEFAULT NULL,
224     x_reprint_remarks                   IN     VARCHAR2    DEFAULT NULL,
225     x_position_code                     IN     NUMBER      DEFAULT NULL,
226     x_position_remarks                  IN     VARCHAR2    DEFAULT NULL,
227     x_subject_field_code                IN     VARCHAR2    DEFAULT NULL,
228     x_subject_field_remarks             IN     VARCHAR2    DEFAULT NULL,
229     x_matriculation                     IN     VARCHAR2    DEFAULT NULL,
230     x_remarks                           IN     VARCHAR2    DEFAULT NULL,
231     x_creation_date                     IN     DATE        DEFAULT NULL,
232     x_created_by                        IN     NUMBER      DEFAULT NULL,
233     x_last_update_date                  IN     DATE        DEFAULT NULL,
234     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
235     x_last_update_login                 IN     NUMBER      DEFAULT NULL,
236     x_category_code                     IN     VARCHAR2    DEFAULT NULL,
237     x_init_prgm_start_date              IN     DATE        DEFAULT NULL,
238     x_govt_org1_othr_name               IN     VARCHAR2    DEFAULT NULL,
239     x_govt_org2_othr_name               IN     VARCHAR2    DEFAULT NULL,
240     x_intl_org1_othr_name               IN     VARCHAR2    DEFAULT NULL,
241     x_intl_org2_othr_name               IN     VARCHAR2    DEFAULT NULL,
242     x_no_show_flag			IN     VARCHAR2	   DEFAULT 'N',
243     x_other_govt_name			IN     VARCHAR2    DEFAULT NULL,
244     x_sevis_school_id                   IN     NUMBER DEFAULT NULL
245   );
246 
247 END igs_pe_ev_form_pkg;