PACKAGE: APPS.CSTPSISC

Source

1 PACKAGE CSTPSISC AUTHID CURRENT_USER AS
2 /* $Header: CSTSISCS.pls 115.4 2002/11/11 22:57:43 awwang ship $ */
3 
4 -- PROCEDURE
5 --  ins_std_cost                This function inserts standard cost in mcacd,
6 --                              transaction cost in mctcd and sub-elemental
7 --                              costs in macs.
8 --
9 -- INPUT PARAMETERS
10 --  I_ORG_ID
11 --  I_INV_ITEM_ID
12 --  I_TXN_ID
13 --  I_TXN_ACTION_ID
14 --  I_TXN_SOURCE_TYPE_ID
15 --  I_EXP_ITEM                 1 is for expense item and 0 is for asset item.
16 --  I_EXP_SUB		       1 is for expense sub and 0 is for asset sub.
17 --  I_TXN_COST
18 --  I_ACTUAL_COST
19 --  I_PRIOR_COST
20 --  I_USER_ID
21 --  I_LOGIN_ID
22 --  I_REQ_ID
23 --  I_PRG_APPL_ID
24 --  I_PRG_ID
25 --  O_Err_Num
26 --  O_Err_Code
27 --  O_Err_Msg
28 --
29 
30 procedure ins_std_cost(
31   I_ORG_ID		IN	NUMBER,
32   I_INV_ITEM_ID         IN      NUMBER,
33   I_TXN_ID		IN 	NUMBER,
34   I_TXN_ACTION_ID       IN      NUMBER,
35   I_TXN_SOURCE_TYPE_ID  IN      NUMBER,
36   I_EXP_ITEM            IN      NUMBER,
37   I_EXP_SUB		IN	NUMBER,
38   I_TXN_COST            IN      NUMBER,
39   I_ACTUAL_COST		IN	NUMBER,
40   I_PRIOR_COST		IN	NUMBER,
41   I_USER_ID		IN	NUMBER,
42   I_LOGIN_ID    	IN	NUMBER,
43   I_REQUEST_ID		IN	NUMBER,
44   I_PROG_APPL_ID		IN	NUMBER,
45   I_PROG_ID		IN 	NUMBER,
46   O_Err_Num		OUT NOCOPY	NUMBER,
47   O_Err_Code		OUT NOCOPY	VARCHAR2,
48   O_Err_Msg		OUT NOCOPY	VARCHAR2
49 );
50 
51 END CSTPSISC;