DBA Data[Home] [Help]

PACKAGE: APPS.IGI_EXP_DU_TYPE_DETAILS_PKG

Source


1 PACKAGE igi_exp_du_type_details_pkg AS
2 /* $Header: igiexpts.pls 120.4.12000000.1 2007/09/13 04:24:47 mbremkum ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_du_type_detail_id                 IN OUT NOCOPY NUMBER,
7     x_du_type_header_id                 IN     NUMBER,
8     x_transaction_type                  IN     VARCHAR2,
9     x_org_id                            IN     NUMBER,
10     x_mode                              IN     VARCHAR2    DEFAULT 'R'
11   );
12 
13   PROCEDURE lock_row (
14     x_rowid                             IN     VARCHAR2,
15     x_du_type_detail_id                 IN     NUMBER,
16     x_du_type_header_id                 IN     NUMBER,
17     x_transaction_type                  IN     VARCHAR2,
18     x_org_id                            IN     NUMBER
19   );
20 
21   PROCEDURE update_row (
22     x_rowid                             IN     VARCHAR2,
23     x_du_type_detail_id                 IN     NUMBER,
24     x_du_type_header_id                 IN     NUMBER,
25     x_transaction_type                  IN     VARCHAR2,
26     x_org_id                            IN     NUMBER,
27     x_mode                              IN     VARCHAR2    DEFAULT 'R'
28   );
29 
30   PROCEDURE add_row (
31     x_rowid                             IN OUT NOCOPY VARCHAR2,
32     x_du_type_detail_id                 IN OUT NOCOPY NUMBER,
33     x_du_type_header_id                 IN     NUMBER,
34     x_transaction_type                  IN     VARCHAR2,
35     x_org_id                            IN     NUMBER,
36     x_mode                              IN     VARCHAR2    DEFAULT 'R'
37   );
38 
39   PROCEDURE delete_row (
40     x_rowid                             IN     VARCHAR2
41   );
42 
43   FUNCTION get_pk_for_validation (
44     x_du_type_detail_id                 IN     NUMBER
45   ) RETURN BOOLEAN;
46 
47   PROCEDURE get_fk_igi_exp_du_type_headers (
48     x_du_type_header_id                 IN     NUMBER
49   );
50 
51   PROCEDURE before_dml (
52     p_action                            IN     VARCHAR2,
53     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
54     x_du_type_detail_id                 IN     NUMBER      DEFAULT NULL,
55     x_du_type_header_id                 IN     NUMBER      DEFAULT NULL,
56     x_transaction_type                  IN     VARCHAR2    DEFAULT NULL,
57     x_org_id                            IN     NUMBER      DEFAULT NULL,
58     x_creation_date                     IN     DATE        DEFAULT NULL,
59     x_created_by                        IN     NUMBER      DEFAULT NULL,
60     x_last_update_date                  IN     DATE        DEFAULT NULL,
61     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
62     x_last_update_login                 IN     NUMBER      DEFAULT NULL
63   );
64 
65 END igi_exp_du_type_details_pkg;