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
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
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
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
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
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 ;
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:
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:
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
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
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
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
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
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
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: );
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:
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 */
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: