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;