1 PACKAGE BODY PA_ALLOC_EXTNS AS
2 /* $Header: PAXALCXB.pls 120.2 2005/08/09 16:22:56 dlanka noship $ */
3
4 PROCEDURE source_extn(p_alloc_rule_id IN NUMBER,
5 x_source_proj_task_tbl OUT NOCOPY ALLOC_SOURCE_TABTYPE )
6 IS
7 BEGIN
8 NULL ;
9 EXCEPTION
10 WHEN OTHERS THEN
11 null;
12 END source_extn;
13
14 PROCEDURE offset_extn( p_alloc_rule_id IN NUMBER
15 , p_offset_amount IN NUMBER
16 , x_offset_proj_task_tbl OUT NOCOPY ALLOC_OFFSET_TABTYPE )
17 IS
18 BEGIN
19 null;
20 EXCEPTION
21 WHEN OTHERS THEN
22 null;
23 END offset_extn;
24
25 PROCEDURE offset_task_extn( p_alloc_rule_id IN NUMBER
26 , p_offset_project_id IN NUMBER
27 , x_offset_task_id OUT NOCOPY NUMBER ) IS
28 BEGIN
29 NULL;
30 EXCEPTION
31 WHEN OTHERS THEN
32 null;
33 END offset_task_extn;
34
35 PROCEDURE target_extn(p_alloc_rule_id IN NUMBER ,
36 x_target_proj_task_tbl OUT NOCOPY ALLOC_TARGET_TABTYPE)
37 IS
38 BEGIN
39 NULL;
40
41 EXCEPTION
42 WHEN OTHERS THEN
43 null;
44 END target_extn;
45
46 PROCEDURE basis_extn(p_alloc_rule_id IN NUMBER
47 , p_project_id IN NUMBER
48 , p_task_id IN NUMBER
49 , x_basis_amount OUT NOCOPY NUMBER ) IS
50 BEGIN
51 NULL;
52 EXCEPTION
53 WHEN OTHERS THEN
54 null;
55 END basis_extn;
56
57 PROCEDURE txn_dff_extn( p_alloc_rule_id IN NUMBER
58 ,p_run_id IN NUMBER
59 ,p_txn_type IN VARCHAR2
60 ,p_project_id IN VARCHAR2
61 ,P_task_id IN VARCHAR2
62 ,p_expnd_org IN VARCHAR2
63 ,p_expnd_type_class IN VARCHAR2
64 ,p_expnd_type IN VARCHAR2
65 ,x_attribute_category OUT NOCOPY VARCHAR2
66 ,x_attribute1 OUT NOCOPY VARCHAR2
67 ,x_attribute2 OUT NOCOPY VARCHAR2
68 ,x_attribute3 OUT NOCOPY VARCHAR2
69 ,x_attribute4 OUT NOCOPY VARCHAR2
70 ,x_attribute5 OUT NOCOPY VARCHAR2
71 ,x_attribute6 OUT NOCOPY VARCHAR2
72 ,x_attribute7 OUT NOCOPY VARCHAR2
73 ,x_attribute8 OUT NOCOPY VARCHAR2
74 ,x_attribute9 OUT NOCOPY VARCHAR2
75 ,x_attribute10 OUT NOCOPY VARCHAR2
76 ) IS
77 BEGIN
78 NULL;
79 EXCEPTION
80 WHEN OTHERS THEN
81 null;
82 END txn_dff_extn ;
83 END PA_ALLOC_EXTNS;