[Home] [Help]
PACKAGE: APPS.EDW_ITEMS_PKG
Source
1 PACKAGE EDW_ITEMS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ENIITEMS.pls 115.2 2004/01/30 21:43:58 sbag noship $ */
3 -- ------------------------
4 -- Public Functions
5 -- ------------------------
6 Function Item_Org_FK(
7 p_inventory_item_id in NUMBER,
8 p_organization_id in NUMBER,
9 p_item_description in VARCHAR2 DEFAULT NULL,
10 p_item_category in VARCHAR2 DEFAULT NULL,
11 p_instance_code in VARCHAR2 DEFAULT NULL)
12 return VARCHAR2;
13
14 Function Item_Org_FK(
15 p_inventory_item_id in NUMBER,
16 p_organization_id in NUMBER,
17 p_item_description in VARCHAR2 DEFAULT NULL,
18 p_item_category_id in NUMBER DEFAULT NULL,
19 p_instance_code in VARCHAR2 DEFAULT NULL)
20 return VARCHAR2;
21
22 Function Item_Rev_FK(
23 p_inventory_item_id in NUMBER,
24 p_organization_id in NUMBER,
25 p_revision in VARCHAR2,
26 p_instance_code in VARCHAR2 := null)
27 return VARCHAR2;
28 Function Category_FK(
29 p_functional_area in NUMBER,
30 p_control in NUMBER,
31 p_category_id in NUMBER,
32 p_instance_code in VARCHAR2 DEFAULT NULL)
33 return VARCHAR2;
34
35 FUNCTION GET_PROD_GRP_FK(
36 p_item_id in NUMBER,
37 p_organization_id in NUMBER,
38 p_instance_code in VARCHAR2 )
39 RETURN VARCHAR2;
40
41 FUNCTION GET_ITEM_FK(
42 p_item_id in NUMBER,
43 p_inv_org_id in NUMBER,
44 p_interest_type_id in NUMBER,
45 p_primary_code_id in NUMBER,
46 p_secondary_code_id in NUMBER,
47 p_instance_code in VARCHAR2 )
48 RETURN VARCHAR2;
49
50 Function GET_MASTER_PARENT(p_organization_id IN NUMBER) RETURN NUMBER;
51
52 PRAGMA RESTRICT_REFERENCES (Item_Org_FK,WNDS, WNPS, RNPS);
53 PRAGMA RESTRICT_REFERENCES (Item_Rev_FK,WNDS, WNPS, RNPS);
54 PRAGMA RESTRICT_REFERENCES (Category_FK,WNDS, WNPS, RNPS);
55 PRAGMA RESTRICT_REFERENCES (Get_Prod_Grp_FK,WNDS, WNPS, RNPS);
56 PRAGMA RESTRICT_REFERENCES (Get_Item_FK, WNDS, WNPS, RNPS);
57 --PRAGMA RESTRICT_REFERENCES (Get_Master_Parent, WNDS, WNPS, RNPS);
58
59 end;