1 PACKAGE INVPCOII AUTHID CURRENT_USER AS
2 /* $Header: INVPCOIS.pls 120.1 2005/12/05 01:08:39 anmurali noship $ */
3
4 FUNCTION CSTFVSUB (
5 I_TRANSID IN NUMBER,
6 I_MATERIAL_SUB_ELEM IN VARCHAR2 DEFAULT NULL,
7 I_MATERIAL_OH_SUB_ELEM IN VARCHAR2 DEFAULT NULL,
8 I_ORGANIZATION_ID IN NUMBER,
9 I_USER_ID IN NUMBER := -1,
10 I_LOGIN_ID IN NUMBER := -1,
11 I_REQ_ID IN NUMBER := -1,
12 I_PRGM_ID IN NUMBER := -1,
13 I_PRGM_APPL_ID IN NUMBER := -1,
14 O_ERR_TEXT IN OUT NOCOPY VARCHAR2)
15 RETURN INTEGER;
16
17
18 PROCEDURE CSTPIICD (
19 I_ORGANIZATION_ID IN NUMBER,
20 I_INVENTORY_ITEM_ID IN NUMBER,
21 I_COST_ELEMENT_ID IN NUMBER,
22 I_COST_RATE IN NUMBER,
23 I_RESOURCE_ID IN NUMBER,
24 I_USER_ID IN NUMBER,
25 I_LOGIN_ID IN NUMBER,
26 I_REQ_ID IN NUMBER,
27 I_PRGM_ID IN NUMBER,
28 I_PRGM_APPL_ID IN NUMBER,
29 O_RETURN_CODE OUT NOCOPY NUMBER,
30 O_ERR_TEXT IN OUT NOCOPY VARCHAR2);
31
32
33 PROCEDURE CSTPPCOI (
34 I_ORGANIZATION_ID IN NUMBER,
35 I_INVENTORY_ITEM_ID IN NUMBER,
36 I_MATERIAL_COST IN NUMBER,
37 I_MATERIAL_SUB_ELEM_ID IN NUMBER,
38 I_MATERIAL_OH_RATE IN NUMBER,
39 I_MATERIAL_OH_SUB_ELEM_ID IN NUMBER,
40 I_USER_ID IN NUMBER,
41 I_LOGIN_ID IN NUMBER,
42 I_REQ_ID IN NUMBER,
43 I_PRGM_ID IN NUMBER,
44 I_PRGM_APPL_ID IN NUMBER,
45 O_RETURN_CODE OUT NOCOPY NUMBER,
46 O_ERR_TEXT IN OUT NOCOPY VARCHAR2);
47
48 PROCEDURE CSTPIICP (
49 I_USER_ID IN NUMBER := -1,
50 I_LOGIN_ID IN NUMBER := -1,
51 I_REQ_ID IN NUMBER := -1,
52 I_PRGM_ID IN NUMBER := -1,
53 I_PRGM_APPL_ID IN NUMBER := -1,
54 O_RETURN_CODE OUT NOCOPY NUMBER,
55 O_RETURN_ERR OUT NOCOPY VARCHAR2,
56 xset_id IN NUMBER DEFAULT NULL);
57
58
59 END INVPCOII;