APPS.PA_DEDUCTIONS dependencies on PA_DEDUCTIONS_ALL

Line 6: FROM PA_DEDUCTIONS_ALL WHERE deduction_req_id = c_dctn_req_id AND status IN('WORKING','REJECTED','FAILED');

2: -- /* $Header: PADEDTXS.pls 120.0 2010/09/22 11:04:53 lamalviy noship $ */
3:
4: CURSOR cur_dctn_hdr_info (c_dctn_req_id NUMBER) IS
5: SELECT *
6: FROM PA_DEDUCTIONS_ALL WHERE deduction_req_id = c_dctn_req_id AND status IN('WORKING','REJECTED','FAILED');
7:
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;

Line 10: TYPE g_dctn_hdrid IS TABLE OF PA_DEDUCTIONS_ALL.DEDUCTION_REQ_ID%TYPE INDEX BY BINARY_INTEGER;

6: FROM PA_DEDUCTIONS_ALL WHERE deduction_req_id = c_dctn_req_id AND status IN('WORKING','REJECTED','FAILED');
7:
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:

Line 69: -- This procedure populates PA_DEDUCTIONS_ALL table after validating the data.

65: g_validate_txn VARCHAR2(1) := 'N';
66: g_user_id NUMBER(15) := FND_GLOBAL.USER_ID;
67:
68: /*---------------------------------------------------------------------------------------------------------
69: -- This procedure populates PA_DEDUCTIONS_ALL table after validating the data.
70: -- Input parameters
71: -- Parameters Type Required Description
72: -- p_dctn_hdr TABLE YES It stores the deduction header information
73: -- Out parameters

Line 131: -- This procedure is to update existing data in PA_DEDUCTIONS_ALL table after validating the data.

127: );
128:
129:
130: /*---------------------------------------------------------------------------------------------------------
131: -- This procedure is to update existing data in PA_DEDUCTIONS_ALL table after validating the data.
132: -- Input parameters
133: -- Parameters Type Required Description
134: -- p_dctn_hdr TABLE YES It stores the deduction header information
135: -- Out parameters

Line 191: -- This procedure is to delete existing data in PA_DEDUCTIONS_ALL table after validating the data.

187: ,p_calling_mode IN VARCHAR2
188: );
189:
190: /*---------------------------------------------------------------------------------------------------------
191: -- This procedure is to delete existing data in PA_DEDUCTIONS_ALL table after validating the data.
192: -- Input parameters
193: -- Parameters Type Required Description
194: -- p_dctn_hdrid TABLE YES It stores the array of deducion requests
195: -- Out parameters

Line 324: Procedure Submit_For_DebitMemo ( p_dctn_req_id IN PA_DEDUCTIONS_ALL.deduction_req_id%TYPE

320: -- p_msg_data VARCHAR2 YES Holds the message code, if the API returned only
321: one error/warning message Otherwise the column is
322: left blank.
323: ----------------------------------------------------------------------------------------------------------*/
324: Procedure Submit_For_DebitMemo ( p_dctn_req_id IN PA_DEDUCTIONS_ALL.deduction_req_id%TYPE
325: ,p_msg_count OUT NOCOPY NUMBER
326: ,p_msg_data OUT NOCOPY VARCHAR2
327: ,p_return_status OUT NOCOPY VARCHAR2
328: );