PACKAGE: APPS.IGS_HE_UT_CALC_LVL_PKG

Source

1 PACKAGE igs_he_ut_calc_lvl_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSWI34S.pls 115.0 2003/02/14 15:58:40 bayadav noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_tariff_calc_type_cd               IN     VARCHAR2,
7     x_tariff_level_cd                   IN     VARCHAR2,
8     x_closed_ind                        IN     VARCHAR2,
9     x_mode                              IN     VARCHAR2    DEFAULT 'R'
10   );
11 
12   PROCEDURE lock_row (
13     x_rowid                             IN     VARCHAR2,
14     x_tariff_calc_type_cd               IN     VARCHAR2,
15     x_tariff_level_cd                   IN     VARCHAR2,
16     x_closed_ind                        IN     VARCHAR2
17   );
18 
19   PROCEDURE update_row (
20     x_rowid                             IN     VARCHAR2,
21     x_tariff_calc_type_cd               IN     VARCHAR2,
22     x_tariff_level_cd                   IN     VARCHAR2,
23     x_closed_ind                        IN     VARCHAR2,
24     x_mode                              IN     VARCHAR2    DEFAULT 'R'
25   );
26 
27   PROCEDURE add_row (
28     x_rowid                             IN OUT NOCOPY VARCHAR2,
29     x_tariff_calc_type_cd               IN     VARCHAR2,
30     x_tariff_level_cd                   IN     VARCHAR2,
31     x_closed_ind                        IN     VARCHAR2,
32     x_mode                              IN     VARCHAR2    DEFAULT 'R'
33   );
34 
35 
36 
37   FUNCTION get_pk_for_validation (
38     x_tariff_calc_type_cd               IN     VARCHAR2,
39     x_tariff_level_cd                   IN     VARCHAR2
40   ) RETURN BOOLEAN;
41 
42 
43   PROCEDURE before_dml (
44     p_action                            IN     VARCHAR2,
45     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
46     x_tariff_calc_type_cd               IN     VARCHAR2    DEFAULT NULL,
47     x_tariff_level_cd                   IN     VARCHAR2    DEFAULT NULL,
48     x_closed_ind                        IN     VARCHAR2    DEFAULT NULL,
49     x_creation_date                     IN     DATE        DEFAULT NULL,
50     x_created_by                        IN     NUMBER      DEFAULT NULL,
51     x_last_update_date                  IN     DATE        DEFAULT NULL,
52     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
53     x_last_update_login                 IN     NUMBER      DEFAULT NULL
54   );
55 
56 END igs_he_ut_calc_lvl_pkg;