1 PACKAGE CST_Common_hooks AUTHID CURRENT_USER AS
2 /* $Header: CSTCOHKS.pls 120.1.12020000.2 2012/11/27 15:03:01 mpuranik ship $ */
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 -- FUNCTION
53 -- get_prd_cls_zeroval_option
54 -- This function can be used to turn off the summarization
55 -- and display in period close reconciliation and summary
56 -- of items that have zero value in the current period.
57 -- By default the function returns a value of 0 which means
58 -- that all items will be included.
59 -- The return value can be modified to 1 to prevent the
60 -- zero value items from being included.
61 -- The behavior can also be customized based on the organization
62 -- and accounting period.
63 --
64 -- Return Values
65 -- integer 0 Include all items
66 -- 1 Do not include zero value items
67 -- Any other Include all items
68 --
69 function get_prd_cls_zeroval_option (
70 i_org_id IN NUMBER,
71 i_acct_period_id IN NUMBER,
72 o_err_num OUT NOCOPY NUMBER,
73 o_err_code OUT NOCOPY VARCHAR2,
74 o_err_msg OUT NOCOPY VARCHAR2
75 ) return integer;
76
77 END CST_Common_hooks;