1 PACKAGE PA_CLIENT_EXTN_BURDEN_SUMMARY AUTHID CURRENT_USER AS
2 /* $Header: PAXBSGCS.pls 120.4 2006/05/26 07:43:32 rahariha noship $ */
3
4 FUNCTION CLIENT_GROUPING
5
6 (
7 p_src_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8 p_src_ind_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
9 p_src_attribute1 IN PA_EXPENDITURE_TYPES.attribute1%TYPE,
10 p_src_attribute2 IN PA_EXPENDITURE_TYPES.attribute2%TYPE,
11 p_src_attribute3 IN PA_EXPENDITURE_TYPES.attribute3%TYPE,
12 p_src_attribute4 IN PA_EXPENDITURE_TYPES.attribute4%TYPE,
13 p_src_attribute5 IN PA_EXPENDITURE_TYPES.attribute5%TYPE,
14 p_src_attribute6 IN PA_EXPENDITURE_TYPES.attribute6%TYPE,
15 p_src_attribute7 IN PA_EXPENDITURE_TYPES.attribute7%TYPE,
16 p_src_attribute8 IN PA_EXPENDITURE_TYPES.attribute8%TYPE,
17 p_src_attribute9 IN PA_EXPENDITURE_TYPES.attribute9%TYPE,
18 p_src_attribute10 IN PA_EXPENDITURE_TYPES.attribute10%TYPE,
19 p_src_attribute_category IN PA_EXPENDITURE_TYPES.attribute_category%TYPE
20 ,p_src_exp_item_date IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_date%TYPE DEFAULT NULL
21 ,p_src_acct_rate_date IN PA_COST_DISTRIBUTION_LINES_ALL.ACCT_RATE_DATE%TYPE DEFAULT NULL
22 ,p_src_acct_rate_type IN PA_COST_DISTRIBUTION_LINES_ALL.ACCT_RATE_TYPE%TYPE DEFAULT NULL
23 ,p_src_acct_exchange_rate IN PA_COST_DISTRIBUTION_LINES_ALL.ACCT_EXCHANGE_RATE%TYPE DEFAULT NULL
24 ,p_src_project_rate_date IN PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_RATE_DATE%TYPE DEFAULT NULL
25 ,p_src_project_rate_type IN PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_RATE_TYPE%TYPE DEFAULT NULL
26 ,p_src_project_exchange_rate IN PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_EXCHANGE_RATE%TYPE DEFAULT NULL
27 ,p_src_projfunc_cost_rate_date IN PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_RATE_DATE%TYPE DEFAULT NULL
28 ,p_src_projfunc_cost_rate_type IN PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_RATE_TYPE%TYPE DEFAULT NULL
29 ,p_src_projfunc_cost_xchng_rate IN PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_EXCHANGE_RATE%TYPE DEFAULT NULL
30 ) RETURN varchar2 ;
31
32
33 PROCEDURE CLIENT_COLUMN_VALUES
34 (
35 p_src_attribute2 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute2%TYPE,
36 p_src_attribute3 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute3%TYPE,
37 p_src_attribute4 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute4%TYPE,
38 p_src_attribute5 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute5%TYPE,
39 p_src_attribute6 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute6%TYPE,
40 p_src_attribute7 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute7%TYPE,
41 p_src_attribute8 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute8%TYPE,
42 p_src_attribute9 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute9%TYPE,
43 p_src_attribute10 IN OUT NOCOPY PA_EXPENDITURE_TYPES.attribute10%TYPE,
44 p_src_attribute_category IN PA_EXPENDITURE_TYPES.attribute_category%TYPE
45 ,p_src_acct_rate_date IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.ACCT_RATE_DATE%TYPE
46 ,p_src_acct_rate_type IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.ACCT_RATE_TYPE%TYPE
47 ,p_src_acct_exchange_rate IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.ACCT_EXCHANGE_RATE%TYPE
48 ,p_src_project_rate_date IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_RATE_DATE%TYPE
49 ,p_src_project_rate_type IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_RATE_TYPE%TYPE
50 ,p_src_project_exchange_rate IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_EXCHANGE_RATE%TYPE
51 ,p_src_projfunc_cost_rate_date IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_RATE_DATE%TYPE
52 ,p_src_projfunc_cost_rate_type IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_RATE_TYPE%TYPE
53 ,p_src_projfunc_cost_xchng_rate IN OUT NOCOPY PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_EXCHANGE_RATE%TYPE
54 );
55
56 /* Function Same_Line_Burden_Cmt added for bug 2989775 */
57
58 FUNCTION Same_Line_Burden_Cmt
59 RETURN BOOLEAN;
60
61 pragma RESTRICT_REFERENCES (Same_Line_Burden_Cmt, WNDS, WNPS);
62
63 END PA_CLIENT_EXTN_BURDEN_SUMMARY;