PACKAGE: APPS.IGS_PE_RACE_PKG

Source

1 PACKAGE igs_pe_race_pkg AS
2 /* $Header: IGSNIB0S.pls 120.0 2005/06/01 17:23:22 appldev noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_person_id                         IN     NUMBER,
7     x_race_cd                           IN     VARCHAR2,
8     x_mode                              IN     VARCHAR2    DEFAULT 'R'
9   );
10 
11   PROCEDURE lock_row (
12     x_rowid                             IN     VARCHAR2,
13     x_person_id                         IN     NUMBER,
14     x_race_cd                           IN     VARCHAR2
15   );
16 
17   PROCEDURE delete_row (
18     x_rowid                             IN     VARCHAR2,
19   x_mode IN VARCHAR2 DEFAULT 'R'
20   );
21 
22   FUNCTION get_pk_for_validation (
23     x_person_id                         IN     NUMBER,
24     x_race_cd                           IN     VARCHAR2
25   ) RETURN BOOLEAN;
26 
27   PROCEDURE before_dml (
28     p_action                            IN     VARCHAR2,
29     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
30     x_person_id                         IN     NUMBER      DEFAULT NULL,
31     x_race_cd                           IN     VARCHAR2    DEFAULT NULL,
32     x_creation_date                     IN     DATE        DEFAULT NULL,
33     x_created_by                        IN     NUMBER      DEFAULT NULL,
34     x_last_update_date                  IN     DATE        DEFAULT NULL,
35     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
36     x_last_update_login                 IN     NUMBER      DEFAULT NULL
37   );
38 
39 END igs_pe_race_pkg;