1 PACKAGE CSTPPAHK AUTHID CURRENT_USER AS
2 /* $Header: CSTPAHKS.pls 115.7 2002/11/11 19:52:08 awwang ship $ */
3
4 -- FUNCTION
5 -- acq_cost_hook Cover routine to allow users to add
6 -- customization. This would let users circumvent
7 -- our acquisition cost processing. This function
8 -- is called by both CSTPPACQ .
9 --
10 --
11 -- RETURN VALUES
12 -- integer 1 Hook has been used.
13 -- 0 Continue cost processing for this transaction
14 -- as usual.
15 --
16 /* Added I_START_DATE and I_END_DATE input parameters
17 * to provide the hook with the process_upto_date information
18 */
19
20 function acq_cost_hook(
21 I_PERIOD_ID IN NUMBER,
22 I_START_DATE IN DATE,
23 I_END_DATE IN DATE,
24 I_COST_TYPE_ID IN NUMBER,
25 I_COST_GROUP_ID IN NUMBER,
26 I_USER_ID IN NUMBER,
27 I_LOGIN_ID IN NUMBER,
28 I_REQ_ID IN NUMBER,
29 I_PROG_ID IN NUMBER,
30 I_PROG_APPL_ID IN NUMBER,
31 O_Err_Num OUT NOCOPY NUMBER,
32 O_Err_Code OUT NOCOPY VARCHAR2,
33 O_Err_Msg OUT NOCOPY VARCHAR2
34 )
35 return integer;
36
37 -- PROCEDURE
38 -- acq_receipt_cost_hook Cover routine to allow users to provide
39 -- cost for the receipt transaction that have
40 -- been done in periods prior to the first
41 -- period of Acquisition Cost. This function
42 -- is called by both CSTPPACQ .
43 --
44 --
45 -- OUT VALUES
46 -- o_error_num <0 Error has occured.
47 -- 0 No error has occured.
48 --
49 -- o_hook_cost Cost of the transaction.
50 --
51 -- When returning cost in the o_hook_cost set the o_error_num to zero.
52 -- If the o_error_num is less than zero then returned cost will not be used
53 -- and the prcoess will error out.
54 --
55 --
56 procedure acq_receipt_cost_hook(
57 I_COST_TYPE_ID IN NUMBER,
58 I_COST_GROUP_ID IN NUMBER,
59 I_PAR_TXN IN NUMBER,
60 O_HOOK_COST OUT NOCOPY NUMBER,
61 O_ERROR_NUM OUT NOCOPY NUMBER,
62 O_ERROR_MSG OUT NOCOPY VARCHAR2);
63
64 END CSTPPAHK;
|
|
|