[Home] [Help]
8: cur_dctn_hdr cur_dctn_hdr_info%ROWTYPE;
9:
10: TYPE g_dctn_hdrid IS TABLE OF PA_DEDUCTIONS_ALL.DEDUCTION_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE g_dctn_txnid IS TABLE OF PA_DEDUCTION_TRANSACTIONS_ALL.DEDUCTION_REQ_TRAN_ID%TYPE
13: INDEX BY BINARY_INTEGER;
14:
15: TYPE g_dctn_hdr_rec IS RECORD (
16: deduction_req_id NUMBER(15),
96: ,p_calling_mode IN VARCHAR2
97: );
98:
99: /*---------------------------------------------------------------------------------------------------------
100: -- This procedure populates PA_DEDUCTION_TRANSACTIONS_ALL table after validating the data.
101: -- Input parameters
102: -- Parameters Type Required Description
103: -- p_dctn_dtl TABLE YES It stores the deduction transactions information
104: -- Out parameters
157: ,p_calling_mode IN VARCHAR2
158: );
159:
160: /*---------------------------------------------------------------------------------------------------------
161: -- This procedure is to update existing data in PA_DEDUCTION_TRANSACTIONS_ALL table after validating the data.
162: -- Input parameters
163: -- Parameters Type Required Description
164: -- p_dctn_dtl TABLE YES It stores the deduction transactions information
165: -- Out parameters
212: ,p_return_status OUT NOCOPY VARCHAR2
213: );
214:
215: /*---------------------------------------------------------------------------------------------------------
216: -- This procedure is to delete existing data in PA_DEDUCTION_TRANSACTIONS_ALL table after validating the data.
217: -- Input parameters
218: -- Parameters Type Required Description
219: -- p_dctn_txnid TABLE YES It stores the array of deducion request transactions
220: -- Out parameters