PACKAGE: APPS.IGS_FI_LB_FCIS_PKG

Source

1 PACKAGE igs_fi_lb_fcis_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSSID3S.pls 115.0 2003/06/10 10:19:38 shtatiko noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_lockbox_name                      IN     VARCHAR2,
7     x_bank_cd                           IN     VARCHAR2,
8     x_fee_cal_type                      IN     VARCHAR2,
9     x_fee_ci_sequence_number            IN     NUMBER,
10     x_mode                              IN     VARCHAR2    DEFAULT 'R'
11   );
12 
13   PROCEDURE lock_row (
14     x_rowid                             IN     VARCHAR2,
15     x_lockbox_name                      IN     VARCHAR2,
16     x_bank_cd                           IN     VARCHAR2,
17     x_fee_cal_type                      IN     VARCHAR2,
18     x_fee_ci_sequence_number            IN     NUMBER
19   );
20 
21   PROCEDURE update_row (
22     x_rowid                             IN     VARCHAR2,
23     x_lockbox_name                      IN     VARCHAR2,
24     x_bank_cd                           IN     VARCHAR2,
25     x_fee_cal_type                      IN     VARCHAR2,
26     x_fee_ci_sequence_number            IN     NUMBER,
27     x_mode                              IN     VARCHAR2    DEFAULT 'R'
28   );
29 
30   PROCEDURE add_row (
31     x_rowid                             IN OUT NOCOPY VARCHAR2,
32     x_lockbox_name                      IN     VARCHAR2,
33     x_bank_cd                           IN     VARCHAR2,
34     x_fee_cal_type                      IN     VARCHAR2,
35     x_fee_ci_sequence_number            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_lockbox_name                      IN     VARCHAR2,
45     x_bank_cd                           IN     VARCHAR2
46   ) RETURN BOOLEAN;
47 
48   FUNCTION get_uk_for_validation (
49     x_lockbox_name                      IN     VARCHAR2,
50     x_fee_cal_type                      IN     VARCHAR2,
51     x_fee_ci_sequence_number            IN     NUMBER
52   ) RETURN BOOLEAN;
53 
54   -- Removed get_fk_igs_fi_lockboxes as Deletion on IGS_FI_LOCBOXES table
55 
56   PROCEDURE get_fk_igs_ca_inst (
57     x_cal_type                          IN     VARCHAR2,
58     x_sequence_number                   IN     NUMBER
59   );
60 
61   PROCEDURE before_dml (
62     p_action                            IN     VARCHAR2,
63     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
64     x_lockbox_name                      IN     VARCHAR2    DEFAULT NULL,
65     x_bank_cd                           IN     VARCHAR2    DEFAULT NULL,
66     x_fee_cal_type                      IN     VARCHAR2    DEFAULT NULL,
67     x_fee_ci_sequence_number            IN     NUMBER      DEFAULT NULL,
68     x_creation_date                     IN     DATE        DEFAULT NULL,
69     x_created_by                        IN     NUMBER      DEFAULT NULL,
70     x_last_update_date                  IN     DATE        DEFAULT NULL,
71     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
72     x_last_update_login                 IN     NUMBER      DEFAULT NULL
73   );
74 
75 END igs_fi_lb_fcis_pkg;