1 PACKAGE mrp_epi AS
2 /* $Header: MRPCINVS.pls 120.1 2005/08/31 13:22:44 ichoudhu noship $ */
3
4 -- Globals used for the concurrent procedure
5 G_SUCCESS CONSTANT NUMBER := 0;
6 G_WARNING CONSTANT NUMBER := 1;
7 G_ERROR CONSTANT NUMBER := 2;
8
9 PROCEDURE inventory_turns(errbuf OUT NOCOPY VARCHAR2,
10 retcode OUT NOCOPY NUMBER,
11 p_owning_org_id IN NUMBER,
12 p_designator IN VARCHAR2);
13
14 PROCEDURE mrp_calculate_revenue(plan_name in varchar2,
15 sched_name in varchar2,
16 p_org_id in number,
17 p_owning_org_id in number,
18 p_start_date in date,
19 p_complete_date in date);
20
21 PROCEDURE mrp_resource_util(p_designator in varchar2,
22 p_org_id in number,
23 p_start_date in date,
24 p_end_date in date);
25
26 PROCEDURE mrp_populate_fc_sum(ERRBUF OUT NOCOPY VARCHAR2,
27 RETCODE OUT NOCOPY NUMBER,
28 p_organization_id NUMBER,
29 p_from_forecast VARCHAR2,
30 p_to_forecast VARCHAR2,
31 p_from_date DATE,
32 p_to_date DATE);
33
34 FUNCTION mrp_item_selling_price(arg_item_id in number,
35 arg_org_id in number,
36 arg_price_list_id in number default null,
37 arg_currency in varchar2 default null)
38 RETURN NUMBER;
39
40 -- new function for the APS
41 FUNCTION mrp_item_list_price(arg_item_id in number,
42 arg_org_id in number,
43 arg_price_list_id in number default null,
44 arg_currency in varchar2 default null)
45 RETURN NUMBER;
46
47 FUNCTION mrp_item_cost(p_item_id in number,
48 p_org_id in number)
49 RETURN NUMBER;
50
51 FUNCTION mrp_resource_cost(p_item_id in number,
52 p_org_id in number)
53 RETURN NUMBER;
54
55 FUNCTION issued_values(p_designator IN VARCHAR2,
56 p_org_id IN NUMBER, p_item_id IN NUMBER) RETURN NUMBER;
57
58 FUNCTION past_due_mds(p_designator IN VARCHAR2, p_org_id IN NUMBER,
59 p_item_id IN NUMBER, p_date IN DATE) RETURN NUMBER;
60
61 FUNCTION inv_values(p_designator IN VARCHAR2,
62 p_org_id IN NUMBER, p_item_id IN NUMBER,
63 p_start_date IN DATE, p_end_date IN DATE) RETURN NUMBER;
64
65 -- Due to the OE design changes and these read/write constraints are not
66 -- required in 8i, the following pragma statemets are commented out.
67
68 -- PRAGMA RESTRICT_REFERENCES (issued_values, WNDS, WNPS);
69 -- PRAGMA RESTRICT_REFERENCES (past_due_mds, WNDS, WNPS);
70 -- PRAGMA RESTRICT_REFERENCES (inv_values, WNDS, WNPS);
71 -- PRAGMA RESTRICT_REFERENCES (mrp_item_selling_price,WNDS,WNPS);
72
73 -- Add RNPS restriction for remote procedure call
74 -- PRAGMA RESTRICT_REFERENCES (mrp_item_cost,WNDS,WNPS,RNPS);
75 -- PRAGMA RESTRICT_REFERENCES (mrp_resource_cost,WNDS,WNPS,RNPS);
76 -- New function for the APS
77 -- PRAGMA RESTRICT_REFERENCES (mrp_item_list_price,WNDS,WNPS,RNPS);
78
79
80 END mrp_epi;