DBA Data[Home] [Help]

PACKAGE: APPS.IGF_SL_DL_BATCH_PKG

Source


1 PACKAGE igf_sl_dl_batch_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGFLI13S.pls 115.3 2002/11/28 14:24:32 nsidana ship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_dbth_id                           IN OUT NOCOPY NUMBER,
7     x_batch_id                          IN     VARCHAR2,
8     x_message_class                     IN     VARCHAR2,
9     x_bth_creation_date                 IN     DATE,
10     x_batch_rej_code                    IN     VARCHAR2,
11     x_end_date                          IN     DATE,
12     x_batch_type                        IN     VARCHAR2,
13     x_send_resp                         IN     VARCHAR2,
14     x_status                            IN     VARCHAR2,
15     x_mode                              IN     VARCHAR2    DEFAULT 'R'
16   );
17 
18   PROCEDURE lock_row (
19     x_rowid                             IN     VARCHAR2,
20     x_dbth_id                           IN     NUMBER,
21     x_batch_id                          IN     VARCHAR2,
22     x_message_class                     IN     VARCHAR2,
23     x_bth_creation_date                 IN     DATE,
24     x_batch_rej_code                    IN     VARCHAR2,
25     x_end_date                          IN     DATE,
26     x_batch_type                        IN     VARCHAR2,
27     x_send_resp                         IN     VARCHAR2,
28     x_status                            IN     VARCHAR2
29   );
30 
31   PROCEDURE update_row (
32     x_rowid                             IN     VARCHAR2,
33     x_dbth_id                           IN     NUMBER,
34     x_batch_id                          IN     VARCHAR2,
35     x_message_class                     IN     VARCHAR2,
36     x_bth_creation_date                 IN     DATE,
37     x_batch_rej_code                    IN     VARCHAR2,
38     x_end_date                          IN     DATE,
39     x_batch_type                        IN     VARCHAR2,
40     x_send_resp                         IN     VARCHAR2,
41     x_status                            IN     VARCHAR2,
42     x_mode                              IN     VARCHAR2    DEFAULT 'R'
43   );
44 
45   PROCEDURE add_row (
46     x_rowid                             IN OUT NOCOPY VARCHAR2,
47     x_dbth_id                           IN OUT NOCOPY NUMBER,
48     x_batch_id                          IN     VARCHAR2,
49     x_message_class                     IN     VARCHAR2,
50     x_bth_creation_date                 IN     DATE,
51     x_batch_rej_code                    IN     VARCHAR2,
52     x_end_date                          IN     DATE,
53     x_batch_type                        IN     VARCHAR2,
54     x_send_resp                         IN     VARCHAR2,
55     x_status                            IN     VARCHAR2,
56     x_mode                              IN     VARCHAR2    DEFAULT 'R'
57   );
58 
59   PROCEDURE delete_row (
60     x_rowid                             IN     VARCHAR2
61   );
62 
63   FUNCTION get_pk_for_validation (
64     x_dbth_id                           IN     NUMBER
65   ) RETURN BOOLEAN;
66 
67   PROCEDURE before_dml (
68     p_action                            IN     VARCHAR2,
69     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
70     x_dbth_id                           IN     NUMBER      DEFAULT NULL,
71     x_batch_id                          IN     VARCHAR2    DEFAULT NULL,
72     x_message_class                     IN     VARCHAR2    DEFAULT NULL,
73     x_bth_creation_date                 IN     DATE        DEFAULT NULL,
74     x_batch_rej_code                    IN     VARCHAR2    DEFAULT NULL,
75     x_end_date                          IN     DATE        DEFAULT NULL,
76     x_batch_type                        IN     VARCHAR2    DEFAULT NULL,
77     x_send_resp                         IN     VARCHAR2    DEFAULT NULL,
78     x_status                            IN     VARCHAR2    DEFAULT NULL,
79     x_creation_date                     IN     DATE        DEFAULT NULL,
80     x_created_by                        IN     NUMBER      DEFAULT NULL,
81     x_last_update_date                  IN     DATE        DEFAULT NULL,
82     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
83     x_last_update_login                 IN     NUMBER      DEFAULT NULL
84   );
85 
86 END igf_sl_dl_batch_pkg;