1 PACKAGE PA_ALLOC_EXTNS AUTHID CURRENT_USER AS
2 /* $Header: PAXALCXS.pls 120.1 2005/08/09 12:10:53 dlanka noship $ */
3
4
5 TYPE ALLOC_SOURCE_REC IS RECORD (
6 PROJECT_ID NUMBER ,
7 TASK_ID NUMBER ,
8 EXCLUDE_FLAG VARCHAR2(1)
9 ) ;
10 TYPE ALLOC_SOURCE_TABTYPE IS TABLE OF ALLOC_SOURCE_REC
11 INDEX BY BINARY_INTEGER ;
12
13 TYPE ALLOC_TARGET_REC IS RECORD (
14 PROJECT_ID NUMBER ,
15 TASK_ID NUMBER ,
16 PERCENT NUMBER ,
17 EXCLUDE_FLAG VARCHAR2(1)
18 ) ;
19 TYPE ALLOC_TARGET_TABTYPE IS TABLE OF ALLOC_TARGET_REC
20 INDEX BY BINARY_INTEGER ;
21
22 TYPE ALLOC_OFFSET_REC IS RECORD (
23 PROJECT_ID NUMBER
24 , TASK_ID NUMBER
25 , OFFSET_AMOUNT NUMBER
26 ) ;
27
28 TYPE ALLOC_OFFSET_TABTYPE IS TABLE OF ALLOC_OFFSET_REC
29 INDEX BY BINARY_INTEGER ;
30
31 PROCEDURE source_extn( p_alloc_rule_id IN NUMBER
32 , x_source_proj_task_tbl OUT NOCOPY ALLOC_SOURCE_TABTYPE);
33
34 PROCEDURE offset_extn( p_alloc_rule_id IN NUMBER
35 , p_offset_amount IN NUMBER
36 , x_offset_proj_task_tbl OUT NOCOPY ALLOC_OFFSET_TABTYPE);
37
38 PROCEDURE offset_task_extn( p_alloc_rule_id IN NUMBER
39 , p_offset_project_id IN NUMBER
40 , x_offset_task_id OUT NOCOPY NUMBER);
41
42 PROCEDURE basis_extn( p_alloc_rule_id IN NUMBER
43 , p_project_id IN NUMBER
44 , p_task_id IN NUMBER
45 , x_basis_amount OUT NOCOPY NUMBER);
46
47 PROCEDURE target_extn( p_alloc_rule_id IN NUMBER
48 , x_target_proj_task_tbl OUT NOCOPY ALLOC_TARGET_TABTYPE);
49
50 PROCEDURE txn_dff_extn( p_alloc_rule_id IN NUMBER
51 ,p_run_id IN NUMBER
52 ,p_txn_type IN VARCHAR2
53 ,p_project_id IN VARCHAR2
54 ,P_task_id IN VARCHAR2
55 ,p_expnd_org IN VARCHAR2
56 ,p_expnd_type_class IN VARCHAR2
57 ,p_expnd_type IN VARCHAR2
58 ,x_attribute_category OUT NOCOPY VARCHAR2
59 ,x_attribute1 OUT NOCOPY VARCHAR2
60 ,x_attribute2 OUT NOCOPY VARCHAR2
61 ,x_attribute3 OUT NOCOPY VARCHAR2
62 ,x_attribute4 OUT NOCOPY VARCHAR2
63 ,x_attribute5 OUT NOCOPY VARCHAR2
64 ,x_attribute6 OUT NOCOPY VARCHAR2
65 ,x_attribute7 OUT NOCOPY VARCHAR2
66 ,x_attribute8 OUT NOCOPY VARCHAR2
67 ,x_attribute9 OUT NOCOPY VARCHAR2
68 ,x_attribute10 OUT NOCOPY VARCHAR2
69 ) ;
70
71 END PA_ALLOC_EXTNS;