DBA Data[Home] [Help]

PACKAGE: APPS.IGI_RPI_AUDIT_ITEMS_ALL_PKG

Source


1 PACKAGE igi_rpi_audit_items_all_pkg AS
2 /* $Header: igiraias.pls 120.3.12000000.1 2007/08/31 05:52:33 mbremkum noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_item_id                           IN     NUMBER,
7     x_price                             IN     NUMBER,
8     x_effective_date                    IN     DATE,
9     x_revised_effective_date            IN     DATE,
10     x_revised_price                     IN     NUMBER,
11     x_run_id                            IN     NUMBER,
12     x_org_id                            IN     NUMBER,
13     x_mode                              IN     VARCHAR2    DEFAULT 'R'
14   );
15 
16   PROCEDURE lock_row (
17     x_rowid                             IN     VARCHAR2,
18     x_item_id                           IN     NUMBER,
19     x_price                             IN     NUMBER,
20     x_effective_date                    IN     DATE,
21     x_revised_effective_date            IN     DATE,
22     x_revised_price                     IN     NUMBER,
23     x_run_id                            IN     NUMBER,
24     x_org_id                            IN     NUMBER
25   );
26 
27   PROCEDURE update_row (
28     x_rowid                             IN     VARCHAR2,
29     x_item_id                           IN     NUMBER,
30     x_price                             IN     NUMBER,
31     x_effective_date                    IN     DATE,
32     x_revised_effective_date            IN     DATE,
33     x_revised_price                     IN     NUMBER,
34     x_run_id                            IN     NUMBER,
35     x_org_id                            IN     NUMBER,
36     x_mode                              IN     VARCHAR2    DEFAULT 'R'
37   );
38 
39   PROCEDURE add_row (
40     x_rowid                             IN OUT NOCOPY VARCHAR2,
41     x_item_id                           IN     NUMBER,
42     x_price                             IN     NUMBER,
43     x_effective_date                    IN     DATE,
44     x_revised_effective_date            IN     DATE,
45     x_revised_price                     IN     NUMBER,
46     x_run_id                            IN     NUMBER,
47     x_org_id                            IN     NUMBER,
48     x_mode                              IN     VARCHAR2    DEFAULT 'R'
49   );
50 
51   PROCEDURE delete_row (
52     x_rowid                             IN     VARCHAR2
53   );
54 
55 
56   PROCEDURE before_dml (
57     p_action                            IN     VARCHAR2,
58     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
59     x_item_id                           IN     NUMBER      DEFAULT NULL,
60     x_price                             IN     NUMBER      DEFAULT NULL,
61     x_effective_date                    IN     DATE        DEFAULT NULL,
62     x_revised_effective_date            IN     DATE        DEFAULT NULL,
63     x_revised_price                     IN     NUMBER      DEFAULT NULL,
64     x_run_id                            IN     NUMBER      DEFAULT NULL,
65     x_org_id                            IN     NUMBER      DEFAULT NULL,
66     x_creation_date                     IN     DATE        DEFAULT NULL,
67     x_created_by                        IN     NUMBER      DEFAULT NULL,
68     x_last_update_date                  IN     DATE        DEFAULT NULL,
69     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
70     x_last_update_login                 IN     NUMBER      DEFAULT NULL
71   );
72 
73 END igi_rpi_audit_items_all_pkg;