PACKAGE: APPS.IGS_OR_LOC_REGION_PKG

Source

1 PACKAGE igs_or_loc_region_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI34S.pls 115.0 2003/04/19 05:21:10 kpadiyar noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_location_cd                       IN     VARCHAR2,
7     x_region_cd                         IN     VARCHAR2,
8     x_mode                              IN     VARCHAR2    DEFAULT 'R'
9   );
10 
11   PROCEDURE lock_row (
12     x_rowid                             IN     VARCHAR2,
13     x_location_cd                       IN     VARCHAR2,
14     x_region_cd                         IN     VARCHAR2
15   );
16 
17   PROCEDURE delete_row (
18     x_rowid                             IN     VARCHAR2
19   );
20 
21   FUNCTION get_pk_for_validation (
22     x_location_cd                       IN     VARCHAR2,
23     x_region_cd                         IN     VARCHAR2
24   ) RETURN BOOLEAN;
25 
26   PROCEDURE get_fk_igs_ad_location (
27     x_location_cd                       IN     VARCHAR2
28   );
29 
30   PROCEDURE before_dml (
31     p_action                            IN     VARCHAR2,
32     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
33     x_location_cd                       IN     VARCHAR2    DEFAULT NULL,
34     x_region_cd                         IN     VARCHAR2    DEFAULT NULL,
35     x_creation_date                     IN     DATE        DEFAULT NULL,
36     x_created_by                        IN     NUMBER      DEFAULT NULL,
37     x_last_update_date                  IN     DATE        DEFAULT NULL,
38     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
39     x_last_update_login                 IN     NUMBER      DEFAULT NULL
40   );
41 
42 END igs_or_loc_region_pkg;