PACKAGE: APPS.IGS_DA_CNFG_FTR_PKG

Source

1 PACKAGE igs_da_cnfg_ftr_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSKI44S.pls 115.0 2003/04/15 09:12:00 ddey noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_request_type_id                   IN     NUMBER,
7     x_feature_code                      IN     VARCHAR2,
8     x_configure_flag                    IN     VARCHAR2,
9     x_display_flag                      IN     VARCHAR2,
10     x_feature_value                     IN     VARCHAR2,
11     x_force_value_flag                  IN     VARCHAR2,
12     x_default_value_flag                IN     VARCHAR2,
13     x_mode                              IN     VARCHAR2    DEFAULT 'R'
14   );
15 
16   PROCEDURE lock_row (
17     x_rowid                             IN     VARCHAR2,
18     x_request_type_id                   IN     NUMBER,
19     x_feature_code                      IN     VARCHAR2,
20     x_configure_flag                    IN     VARCHAR2,
21     x_display_flag                      IN     VARCHAR2,
22     x_feature_value                     IN     VARCHAR2,
23     x_force_value_flag                  IN     VARCHAR2,
24     x_default_value_flag                IN     VARCHAR2
25   );
26 
27   PROCEDURE update_row (
28     x_rowid                             IN     VARCHAR2,
29     x_request_type_id                   IN     NUMBER,
30     x_feature_code                      IN     VARCHAR2,
31     x_configure_flag                    IN     VARCHAR2,
32     x_display_flag                      IN     VARCHAR2,
33     x_feature_value                     IN     VARCHAR2,
34     x_force_value_flag                  IN     VARCHAR2,
35     x_default_value_flag                IN     VARCHAR2,
36     x_mode                              IN     VARCHAR2    DEFAULT 'R'
37   );
38 
39   PROCEDURE add_row (
40     x_rowid                             IN OUT NOCOPY VARCHAR2,
41     x_request_type_id                   IN     NUMBER,
42     x_feature_code                      IN     VARCHAR2,
43     x_configure_flag                    IN     VARCHAR2,
44     x_display_flag                      IN     VARCHAR2,
45     x_feature_value                     IN     VARCHAR2,
46     x_force_value_flag                  IN     VARCHAR2,
47     x_default_value_flag                IN     VARCHAR2,
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_request_type_id                   IN     NUMBER,
57     x_feature_code                      IN     VARCHAR2
58   ) RETURN BOOLEAN;
59 
60   PROCEDURE get_fk_igs_da_cnfg_req_typ (
61     x_request_type_id                   IN     NUMBER
62   );
63 
64   PROCEDURE get_fk_igs_da_ftr_val_map (
65     x_feature_code                      IN     VARCHAR2
66   );
67 
68   PROCEDURE before_dml (
69     p_action                            IN     VARCHAR2,
70     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
71     x_request_type_id                   IN     NUMBER      DEFAULT NULL,
72     x_feature_code                      IN     VARCHAR2    DEFAULT NULL,
73     x_configure_flag                    IN     VARCHAR2    DEFAULT NULL,
74     x_display_flag                      IN     VARCHAR2    DEFAULT NULL,
75     x_feature_value                     IN     VARCHAR2    DEFAULT NULL,
76     x_force_value_flag                  IN     VARCHAR2    DEFAULT NULL,
77     x_default_value_flag                IN     VARCHAR2    DEFAULT NULL,
78     x_creation_date                     IN     DATE        DEFAULT NULL,
79     x_created_by                        IN     NUMBER      DEFAULT NULL,
80     x_last_update_date                  IN     DATE        DEFAULT NULL,
81     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
82     x_last_update_login                 IN     NUMBER      DEFAULT NULL
83   );
84 
85 END igs_da_cnfg_ftr_pkg;