1 PACKAGE PJM_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PJMPUTLS.pls 120.1 2006/03/08 14:04:19 yliou noship $ */
3 FUNCTION Get_Demand_Quantity (
4 X_line_id IN NUMBER
5 ) RETURN NUMBER;
6 --
7 -- Name : Last_Accum_Period
8 -- Pre-reqs : None.
9 -- Function : This function returns the last accumulated period
10 -- for a given project or project / task combo.
11 --
12 --
13 -- Parameters :
14 -- IN : X_project_id IN NUMBER
15 -- : X_task_id IN NUMBER
16 --
17 -- Returns : Last accum period
18 --
19 FUNCTION Last_Accum_Period (
20 X_project_id IN NUMBER,
21 X_task_id IN NUMBER DEFAULT NULL
22 ) RETURN VARCHAR2;
23 PRAGMA RESTRICT_REFERENCES (Last_Accum_Period, WNDS, WNPS);
24
25
26 --
27 -- Name : default_wip_acct_class
28 -- Pre-reqs : None.
29 -- Function : This function returns the default WIP accounting
30 -- class for the given organization , project and
31 -- task. The default is derived first from the
32 -- task level, and if not found, the project level.
33 --
34 --
35 -- Parameters :
36 -- IN : X_inventory_org_id IN NUMBER
37 -- : X_project_id IN NUMBER
38 -- : X_task_id IN NUMBER
39 -- : X_class_type IN NUMBER
40 --
41 -- Returns : WIP accounting class code
42 --
43 FUNCTION default_wip_acct_class
44 ( X_inventory_org_id in number
45 , X_project_id in number
46 , X_task_id in number
47 , X_class_type in number
48 ) RETURN VARCHAR2;
49
50 END;