PACKAGE: APPS.IGS_AD_LOCVENUE_ADDR_PKG

Source

1 PACKAGE igs_ad_locvenue_addr_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAIC0S.pls 115.4 2002/11/28 22:26:56 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_location_venue_addr_id            IN OUT NOCOPY NUMBER,
7     x_location_id                       IN     NUMBER,
8     x_location_venue_cd                 IN     VARCHAR2,
9     x_source_type                       IN     VARCHAR2,
10     x_identifying_address_flag          IN     VARCHAR2,
11     x_mode                              IN     VARCHAR2    DEFAULT 'R'
12   );
13 
14   PROCEDURE lock_row (
15     x_rowid                             IN     VARCHAR2,
16     x_location_venue_addr_id            IN     NUMBER,
17     x_location_id                       IN     NUMBER,
18     x_location_venue_cd                 IN     VARCHAR2,
19     x_source_type                       IN     VARCHAR2,
20     x_identifying_address_flag          IN     VARCHAR2
21   );
22 
23   PROCEDURE update_row (
24     x_rowid                             IN     VARCHAR2,
25     x_location_venue_addr_id            IN     NUMBER,
26     x_location_id                       IN     NUMBER,
27     x_location_venue_cd                 IN     VARCHAR2,
28     x_source_type                       IN     VARCHAR2,
29     x_identifying_address_flag          IN     VARCHAR2,
30     x_mode                              IN     VARCHAR2    DEFAULT 'R'
31   );
32 
33   PROCEDURE add_row (
34     x_rowid                             IN OUT NOCOPY VARCHAR2,
35     x_location_venue_addr_id            IN OUT NOCOPY NUMBER,
36     x_location_id                       IN     NUMBER,
37     x_location_venue_cd                 IN     VARCHAR2,
38     x_source_type                       IN     VARCHAR2,
39     x_identifying_address_flag          IN     VARCHAR2,
40     x_mode                              IN     VARCHAR2    DEFAULT 'R'
41   );
42 
43   PROCEDURE delete_row (
44     x_rowid                             IN     VARCHAR2
45   );
46 
47   PROCEDURE check_constraints (
48     column_name                         IN     VARCHAR2    DEFAULT NULL,
49     column_value                        IN     VARCHAR2    DEFAULT NULL
50   );
51 
52   PROCEDURE check_parent_existance;
53 
54   PROCEDURE check_child_existance;
55 
56   FUNCTION get_pk_for_validation (
57     x_location_venue_addr_id            IN     NUMBER
58   ) RETURN BOOLEAN;
59 
60   PROCEDURE get_fk_igs_pe_hz_locations (
61     x_location_id                       IN     NUMBER
62   );
63 
64   PROCEDURE before_dml (
65     p_action                            IN     VARCHAR2,
66     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
67     x_location_venue_addr_id            IN     NUMBER      DEFAULT NULL,
68     x_location_id                       IN     NUMBER      DEFAULT NULL,
69     x_location_venue_cd                 IN     VARCHAR2    DEFAULT NULL,
70     x_source_type                       IN     VARCHAR2    DEFAULT NULL,
71     x_identifying_address_flag          IN     VARCHAR2    DEFAULT NULL,
72     x_creation_date                     IN     DATE        DEFAULT NULL,
73     x_created_by                        IN     NUMBER      DEFAULT NULL,
74     x_last_update_date                  IN     DATE        DEFAULT NULL,
75     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
76     x_last_update_login                 IN     NUMBER      DEFAULT NULL
77   );
78 
79 END igs_ad_locvenue_addr_pkg;