PACKAGE: APPS.IGS_AD_SS_APPL_COMPS_PKG

Source

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