PACKAGE: APPS.IGS_AD_PESTAT_GROUP_PKG

Source

1 PACKAGE igs_ad_pestat_group_pkg AS
2 /* $Header: IGSAIG4S.pls 120.1 2005/08/03 06:46:00 appldev ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_group_number                      IN     NUMBER,
7     x_admission_application_type        IN     VARCHAR2,
8     x_group_min                         IN     NUMBER,
9     x_self_message                      IN     VARCHAR2,
10     x_mode                              IN     VARCHAR2    DEFAULT 'R',
11     x_group_name                        IN     VARCHAR2    DEFAULT NULL,
12     x_group_required_flag               IN     VARCHAR2    DEFAULT NULL
13   );
14 
15   PROCEDURE lock_row (
16     x_rowid                             IN     VARCHAR2,
17     x_group_number                      IN     NUMBER,
18     x_admission_application_type        IN     VARCHAR2,
19     x_group_min                         IN     NUMBER,
20     x_self_message                      IN     VARCHAR2,
21     x_group_name                        IN     VARCHAR2    DEFAULT NULL,
22     x_group_required_flag               IN     VARCHAR2    DEFAULT NULL
23   );
24 
25   PROCEDURE update_row (
26     x_rowid                             IN     VARCHAR2,
27     x_group_number                      IN     NUMBER,
28     x_admission_application_type        IN     VARCHAR2,
29     x_group_min                         IN     NUMBER,
30     x_self_message                      IN     VARCHAR2,
31     x_mode                              IN     VARCHAR2    DEFAULT 'R',
32     x_group_name                        IN     VARCHAR2    DEFAULT NULL,
33     x_group_required_flag               IN     VARCHAR2    DEFAULT NULL
34   );
35 
36   PROCEDURE add_row (
37     x_rowid                             IN OUT NOCOPY VARCHAR2,
38     x_group_number                      IN     NUMBER,
39     x_admission_application_type        IN     VARCHAR2,
40     x_group_min                         IN     NUMBER,
41     x_self_message                      IN     VARCHAR2,
42     x_mode                              IN     VARCHAR2    DEFAULT 'R',
43     x_group_name                        IN     VARCHAR2    DEFAULT NULL,
44     x_group_required_flag               IN     VARCHAR2    DEFAULT NULL
45   );
46 
47   PROCEDURE delete_row (
48     x_rowid                             IN     VARCHAR2
49   );
50 
51   FUNCTION get_pk_for_validation (
52     x_group_number                      IN     NUMBER,
53     x_admission_application_type        IN     VARCHAR2
54   ) RETURN BOOLEAN;
55 
56   PROCEDURE get_fk_igs_ad_ss_appl_typ (
57     x_admission_appl_type               IN     VARCHAR2
58   );
59 
60   PROCEDURE before_dml (
61     p_action                            IN     VARCHAR2,
62     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
63     x_group_number                      IN     NUMBER      DEFAULT NULL,
64     x_admission_application_type        IN     VARCHAR2    DEFAULT NULL,
65     x_group_min                         IN     NUMBER      DEFAULT NULL,
66     x_self_message                      IN     VARCHAR2    DEFAULT NULL,
67     x_creation_date                     IN     DATE        DEFAULT NULL,
68     x_created_by                        IN     NUMBER      DEFAULT NULL,
69     x_last_update_date                  IN     DATE        DEFAULT NULL,
70     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
71     x_last_update_login                 IN     NUMBER      DEFAULT NULL,
72     x_group_name                        IN     VARCHAR2    DEFAULT NULL,
73     x_group_required_flag               IN     VARCHAR2    DEFAULT NULL
74   );
75 
76 END igs_ad_pestat_group_pkg;