PACKAGE: APPS.IGS_EN_INST_WL_STPS_PKG

Source

1 PACKAGE igs_en_inst_wl_stps_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSEI71S.pls 115.0 2003/09/02 08:50:53 svanukur noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_inst_wlst_setup_id                IN OUT NOCOPY   NUMBER,
7     x_waitlist_allowed_flag             IN     VARCHAR2,
8     x_time_confl_alwd_wlst_flag         IN     VARCHAR2,
9     x_simultaneous_wlst_alwd_flag       IN     VARCHAR2,
10     x_auto_enroll_waitlist_flag         IN     VARCHAR2,
11     x_include_waitlist_cp_flag          IN     VARCHAR2,
12     x_max_waitlists_student_num         IN     NUMBER,
13     x_mode                              IN     VARCHAR2    DEFAULT 'R'
14   );
15 
16   PROCEDURE lock_row (
17     x_rowid                             IN     VARCHAR2,
18     x_inst_wlst_setup_id                IN     NUMBER,
19     x_waitlist_allowed_flag             IN     VARCHAR2,
20     x_time_confl_alwd_wlst_flag         IN     VARCHAR2,
21     x_simultaneous_wlst_alwd_flag       IN     VARCHAR2,
22     x_auto_enroll_waitlist_flag         IN     VARCHAR2,
23     x_include_waitlist_cp_flag          IN     VARCHAR2,
24     x_max_waitlists_student_num         IN     NUMBER
25   );
26 
27   PROCEDURE update_row (
28     x_rowid                             IN     VARCHAR2,
29     x_inst_wlst_setup_id                IN     NUMBER,
30     x_waitlist_allowed_flag             IN     VARCHAR2,
31     x_time_confl_alwd_wlst_flag         IN     VARCHAR2,
32     x_simultaneous_wlst_alwd_flag       IN     VARCHAR2,
33     x_auto_enroll_waitlist_flag         IN     VARCHAR2,
34     x_include_waitlist_cp_flag          IN     VARCHAR2,
35     x_max_waitlists_student_num         IN     NUMBER,
36     x_mode                              IN     VARCHAR2    DEFAULT 'R'
37   );
38 
39   PROCEDURE add_row (
40     x_rowid                             IN OUT NOCOPY VARCHAR2,
41     x_inst_wlst_setup_id                IN OUT NOCOPY   NUMBER,
42     x_waitlist_allowed_flag             IN     VARCHAR2,
43     x_time_confl_alwd_wlst_flag         IN     VARCHAR2,
44     x_simultaneous_wlst_alwd_flag       IN     VARCHAR2,
45     x_auto_enroll_waitlist_flag         IN     VARCHAR2,
46     x_include_waitlist_cp_flag          IN     VARCHAR2,
47     x_max_waitlists_student_num         IN     NUMBER,
48     x_mode                              IN     VARCHAR2    DEFAULT 'R'
49   );
50 
51   PROCEDURE delete_row (
52     x_rowid                             IN     VARCHAR2
53   );
54 
55   FUNCTION Get_PK_For_Validation (
56      x_inst_wlst_setup_id IN NUMBER
57     ) RETURN BOOLEAN;
58   PROCEDURE before_dml (
59     p_action                            IN     VARCHAR2,
60     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
61     x_inst_wlst_setup_id                IN     NUMBER      DEFAULT NULL,
62     x_waitlist_allowed_flag             IN     VARCHAR2    DEFAULT NULL,
63     x_time_confl_alwd_wlst_flag         IN     VARCHAR2    DEFAULT NULL,
64     x_simultaneous_wlst_alwd_flag       IN     VARCHAR2    DEFAULT NULL,
65     x_auto_enroll_waitlist_flag         IN     VARCHAR2    DEFAULT NULL,
66     x_include_waitlist_cp_flag          IN     VARCHAR2    DEFAULT NULL,
67     x_max_waitlists_student_num         IN     NUMBER      DEFAULT NULL,
68     x_creation_date                     IN     DATE        DEFAULT NULL,
69     x_created_by                        IN     NUMBER      DEFAULT NULL,
70     x_last_update_date                  IN     DATE        DEFAULT NULL,
71     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
72     x_last_update_login                 IN     NUMBER      DEFAULT NULL
73   );
74 
75 END igs_en_inst_wl_stps_pkg;