DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PE_HZ_PARTY_REL_PKG

Source


1 PACKAGE igs_pe_hz_party_rel_pkg AS
2 /* $Header: IGSNI70S.pls 120.0 2005/06/02 04:27:50 appldev noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_party_relationship_id             IN     NUMBER,
7     x_other_rel_type                    IN     VARCHAR2,
8     x_mode                              IN     VARCHAR2    DEFAULT 'R'
9   );
10 
11   PROCEDURE lock_row (
12     x_rowid                             IN     VARCHAR2,
13     x_party_relationship_id             IN     NUMBER,
14     x_other_rel_type                    IN     VARCHAR2
15   );
16 
17   PROCEDURE update_row (
18     x_rowid                             IN     VARCHAR2,
19     x_party_relationship_id             IN     NUMBER,
20     x_other_rel_type                    IN     VARCHAR2,
21     x_mode                              IN     VARCHAR2    DEFAULT 'R'
22   );
23 
24   PROCEDURE add_row (
25     x_rowid                             IN OUT NOCOPY VARCHAR2,
26     x_party_relationship_id             IN     NUMBER,
27     x_other_rel_type                    IN     VARCHAR2,
28     x_mode                              IN     VARCHAR2    DEFAULT 'R'
29   );
30 
31   PROCEDURE delete_row (
32     x_rowid                             IN     VARCHAR2,
33   x_mode IN VARCHAR2 DEFAULT 'R'
34   );
35 
36   FUNCTION get_pk_for_validation (
37     x_party_relationship_id             IN     NUMBER
38   ) RETURN BOOLEAN;
39 
40   PROCEDURE before_dml (
41     p_action                            IN     VARCHAR2,
42     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
43     x_party_relationship_id             IN     NUMBER      DEFAULT NULL,
44     x_other_rel_type                    IN     VARCHAR2    DEFAULT NULL,
45     x_creation_date                     IN     DATE        DEFAULT NULL,
46     x_created_by                        IN     NUMBER      DEFAULT NULL,
47     x_last_update_date                  IN     DATE        DEFAULT NULL,
48     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
49     x_last_update_login                 IN     NUMBER      DEFAULT NULL
50   );
51 
52 END igs_pe_hz_party_rel_pkg;