1 PACKAGE CST_Common_hooks AS
2 /* $Header: CSTCOHKS.pls 120.0.12000000.3 2007/10/15 09:54:07 sbhati noship $ */
3
4 /*--------------------------------------------------------------------------------
5 | FUNCTION |
6 | Get_NRtax_amount |
7 | This function is used to get the additional taxes involved in PO or |
8 | Internal order receiving transactions that will be used to calculate the |
9 | Encumbrance amount that is required to create the encumbrance reversal |
10 | entry for PO and Internal Orders receiving transactions to Inventory/Expense |
11 | destinations. |
12 | RETURN VALUES : |
13 | integer 1 Hook has been used get Recoverable and Non Recoverable tax amount |
14 | from hook and use them for computing Encumbrance Amount. |
15 | 0 No Taxes involved use original amount derived by system logic. |
16 | -1 Error in Hook |
17 | |
18 | INPUT PARAMETERS |
19 | I_ACCT_TXN_ID (RCV_TRANSACTION_ID OR TRANSACTION_ID from mmt) |
20 | I_SOURCE_DOC_TYPE (PO OR REQ ) |
21 | I_SOURCE_DOC_ID (PO_DISTRIBUTION_ID OR REQUISITION_LINE_ID) |
22 | I_ACCT_SOURCE (RCV OR MMT) |
23 | I_USER_ID |
24 | I_LOGIN_ID |
25 | I_REQ_ID |
26 | I_PRG_APPL_ID |
27 | I_PRG_ID |
28 | O_DOC_NR_TAX |
29 | O_DOC_REC_TAX |
30 | O_Err_Num |
31 | O_Err_Code |
32 | O_Err_Msg |
33 ---------------------------------------------------------------------------------*/
34 function Get_NRtax_amount(
35 I_ACCT_TXN_ID IN NUMBER,
36 I_SOURCE_DOC_TYPE IN VARCHAR2,
37 I_SOURCE_DOC_ID IN NUMBER,
38 I_ACCT_SOURCE IN VARCHAR2,
39 I_USER_ID IN NUMBER,
40 I_LOGIN_ID IN NUMBER,
41 I_REQ_ID IN NUMBER,
42 I_PRG_APPL_ID IN NUMBER,
43 I_PRG_ID IN NUMBER,
44 O_DOC_NR_TAX OUT NOCOPY NUMBER,
45 O_DOC_REC_TAX OUT NOCOPY NUMBER,
46 O_Err_Num OUT NOCOPY NUMBER,
47 O_Err_Code OUT NOCOPY VARCHAR2,
48 O_Err_Msg OUT NOCOPY VARCHAR2
49 )
50 return integer;
51
52 END CST_Common_hooks;
[Home] [Help]