DBA Data[Home] [Help]

PACKAGE: APPS.IGF_AW_DB_CHG_DTLS_PKG

Source


1 PACKAGE igf_aw_db_chg_dtls_pkg AS
2 /* $Header: IGFWI64S.pls 120.0 2005/06/01 14:33:15 appldev noship $ */
3 
4   PROCEDURE insert_row (
5     x_rowid                             IN OUT NOCOPY VARCHAR2,
6     x_award_id                          IN     NUMBER,
7     x_disb_num                          IN     NUMBER,
8     x_disb_seq_num                      IN     NUMBER,
9     x_disb_accepted_amt                 IN     NUMBER,
10     x_orig_fee_amt                      IN     NUMBER,
11     x_disb_net_amt                      IN     NUMBER,
12     x_disb_date                         IN     DATE,
13     x_disb_activity                     IN     VARCHAR2,
14     x_disb_status                       IN     VARCHAR2,
15     x_disb_status_date                  IN     DATE,
16     x_disb_rel_flag                     IN     VARCHAR2,
17     x_first_disb_flag                   IN     VARCHAR2,
18     x_interest_rebate_amt               IN     NUMBER,
19     x_disb_conf_flag                    IN     VARCHAR2,
20     x_pymnt_prd_start_date              IN     DATE,
21     x_note_message                      IN     VARCHAR2,
22     x_batch_id_txt                      IN     VARCHAR2,
23     x_ack_date                          IN     DATE,
24     x_booking_id_txt                    IN     VARCHAR2,
25     x_booking_date                      IN     DATE,
26     x_mode                              IN     VARCHAR2    DEFAULT 'R'
27   );
28 
29   PROCEDURE lock_row (
30     x_rowid                             IN     VARCHAR2,
31     x_award_id                          IN     NUMBER,
32     x_disb_num                          IN     NUMBER,
33     x_disb_seq_num                      IN     NUMBER,
34     x_disb_accepted_amt                 IN     NUMBER,
35     x_orig_fee_amt                      IN     NUMBER,
36     x_disb_net_amt                      IN     NUMBER,
37     x_disb_date                         IN     DATE,
38     x_disb_activity                     IN     VARCHAR2,
39     x_disb_status                       IN     VARCHAR2,
40     x_disb_status_date                  IN     DATE,
41     x_disb_rel_flag                     IN     VARCHAR2,
42     x_first_disb_flag                   IN     VARCHAR2,
43     x_interest_rebate_amt               IN     NUMBER,
44     x_disb_conf_flag                    IN     VARCHAR2,
45     x_pymnt_prd_start_date              IN     DATE,
46     x_note_message                      IN     VARCHAR2,
47     x_batch_id_txt                      IN     VARCHAR2,
48     x_ack_date                          IN     DATE,
49     x_booking_id_txt                    IN     VARCHAR2,
50     x_booking_date                      IN     DATE
51   );
52 
53   PROCEDURE update_row (
54     x_rowid                             IN     VARCHAR2,
55     x_award_id                          IN     NUMBER,
56     x_disb_num                          IN     NUMBER,
57     x_disb_seq_num                      IN     NUMBER,
58     x_disb_accepted_amt                 IN     NUMBER,
59     x_orig_fee_amt                      IN     NUMBER,
60     x_disb_net_amt                      IN     NUMBER,
61     x_disb_date                         IN     DATE,
62     x_disb_activity                     IN     VARCHAR2,
63     x_disb_status                       IN     VARCHAR2,
64     x_disb_status_date                  IN     DATE,
65     x_disb_rel_flag                     IN     VARCHAR2,
66     x_first_disb_flag                   IN     VARCHAR2,
67     x_interest_rebate_amt               IN     NUMBER,
68     x_disb_conf_flag                    IN     VARCHAR2,
69     x_pymnt_prd_start_date              IN     DATE,
70     x_note_message                      IN     VARCHAR2,
71     x_batch_id_txt                      IN     VARCHAR2,
72     x_ack_date                          IN     DATE,
73     x_booking_id_txt                    IN     VARCHAR2,
74     x_booking_date                      IN     DATE,
75     x_mode                              IN     VARCHAR2    DEFAULT 'R'
76   );
77 
78   PROCEDURE add_row (
79     x_rowid                             IN OUT NOCOPY VARCHAR2,
80     x_award_id                          IN     NUMBER,
81     x_disb_num                          IN     NUMBER,
82     x_disb_seq_num                      IN     NUMBER,
83     x_disb_accepted_amt                 IN     NUMBER,
84     x_orig_fee_amt                      IN     NUMBER,
85     x_disb_net_amt                      IN     NUMBER,
86     x_disb_date                         IN     DATE,
87     x_disb_activity                     IN     VARCHAR2,
88     x_disb_status                       IN     VARCHAR2,
89     x_disb_status_date                  IN     DATE,
90     x_disb_rel_flag                     IN     VARCHAR2,
91     x_first_disb_flag                   IN     VARCHAR2,
92     x_interest_rebate_amt               IN     NUMBER,
93     x_disb_conf_flag                    IN     VARCHAR2,
94     x_pymnt_prd_start_date              IN     DATE,
95     x_note_message                      IN     VARCHAR2,
96     x_batch_id_txt                      IN     VARCHAR2,
97     x_ack_date                          IN     DATE,
98     x_booking_id_txt                    IN     VARCHAR2,
99     x_booking_date                      IN     DATE,
100     x_mode                              IN     VARCHAR2    DEFAULT 'R'
101   );
102 
103   PROCEDURE delete_row (
104     x_rowid                             IN     VARCHAR2
105   );
106 
107   FUNCTION get_pk_for_validation (
108     x_award_id                          IN     NUMBER,
109     x_disb_num                          IN     NUMBER,
110     x_disb_seq_num                      IN     NUMBER
111   ) RETURN BOOLEAN;
112 
113   PROCEDURE get_fk_igf_aw_award (
114     x_award_id                          IN     NUMBER
115   );
116 
117   PROCEDURE get_fk_igf_aw_awd_disb (
118     x_award_id                          IN     NUMBER,
119     x_disb_num                          IN     NUMBER
120   );
121 
122   PROCEDURE before_dml (
123     p_action                            IN     VARCHAR2,
124     x_rowid                             IN     VARCHAR2    DEFAULT NULL,
125     x_award_id                          IN     NUMBER      DEFAULT NULL,
126     x_disb_num                          IN     NUMBER      DEFAULT NULL,
127     x_disb_seq_num                      IN     NUMBER      DEFAULT NULL,
128     x_disb_accepted_amt                 IN     NUMBER      DEFAULT NULL,
129     x_orig_fee_amt                      IN     NUMBER      DEFAULT NULL,
130     x_disb_net_amt                      IN     NUMBER      DEFAULT NULL,
131     x_disb_date                         IN     DATE        DEFAULT NULL,
132     x_disb_activity                     IN     VARCHAR2    DEFAULT NULL,
133     x_disb_status                       IN     VARCHAR2    DEFAULT NULL,
134     x_disb_status_date                  IN     DATE        DEFAULT NULL,
135     x_disb_rel_flag                     IN     VARCHAR2    DEFAULT NULL,
136     x_first_disb_flag                   IN     VARCHAR2    DEFAULT NULL,
137     x_interest_rebate_amt               IN     NUMBER      DEFAULT NULL,
138     x_disb_conf_flag                    IN     VARCHAR2    DEFAULT NULL,
139     x_pymnt_prd_start_date              IN     DATE        DEFAULT NULL,
140     x_note_message                      IN     VARCHAR2    DEFAULT NULL,
141     x_batch_id_txt                      IN     VARCHAR2    DEFAULT NULL,
142     x_ack_date                          IN     DATE        DEFAULT NULL,
143     x_booking_id_txt                    IN     VARCHAR2    DEFAULT NULL,
144     x_booking_date                      IN     DATE        DEFAULT NULL,
145     x_creation_date                     IN     DATE        DEFAULT NULL,
146     x_created_by                        IN     NUMBER      DEFAULT NULL,
147     x_last_update_date                  IN     DATE        DEFAULT NULL,
148     x_last_updated_by                   IN     NUMBER      DEFAULT NULL,
149     x_last_update_login                 IN     NUMBER      DEFAULT NULL
150   );
151 
152 END igf_aw_db_chg_dtls_pkg;