DBA Data[Home] [Help]

PACKAGE: APPS.IGS_PS_EXP_WL_PKG

Source


1 PACKAGE igs_ps_exp_wl_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI3DS.pls 115.4 2003/07/24 13:32:51 shtatiko noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_calendar_cat                      IN     VARCHAR2,
7     x_mode                              IN     VARCHAR2    DEFAULT 'R'
8   );
9 
10   PROCEDURE lock_row (
11     x_rowid                             IN     VARCHAR2,
12     x_calendar_cat                      IN     VARCHAR2
13   );
14 
15   PROCEDURE update_row (
16     x_rowid                             IN     VARCHAR2,
17     x_calendar_cat                      IN     VARCHAR2,
18     x_mode                              IN     VARCHAR2    DEFAULT 'R'
19   );
20 
21   PROCEDURE add_row (
22     x_rowid                             IN OUT NOCOPY VARCHAR2,
23     x_calendar_cat                      IN     VARCHAR2,
24     x_mode                              IN     VARCHAR2    DEFAULT 'R'
25   );
26 
27   PROCEDURE delete_row (
28     x_rowid                             IN     VARCHAR2
29   );
30 
31   FUNCTION get_pk_for_validation (
32     x_calendar_cat                      IN     VARCHAR2
33   ) RETURN BOOLEAN;
34 
35   PROCEDURE before_dml (
36     p_action                            IN     VARCHAR2,
37     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
38     x_calendar_cat                      IN     VARCHAR2    DEFAULT NULL,
39     x_creation_date                     IN     DATE        DEFAULT NULL,
40     x_created_by                        IN     NUMBER      DEFAULT NULL,
41     x_last_update_date                  IN     DATE        DEFAULT NULL,
42     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
43     x_last_update_login                 IN     NUMBER      DEFAULT NULL
44   );
45 
46 END igs_ps_exp_wl_pkg;