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,
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,
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,
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,
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,
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,
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,
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,
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
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
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
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
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
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,
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,
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,
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,
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,
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
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
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
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
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