64: * @rep:compatibility S
65: */
66: FUNCTION CLIENT_GROUPING_METHOD( p_proj_id IN PA_PROJECTS_ALL.project_id%TYPE,
67: p_task_id IN PA_TASKS.task_id%TYPE,
68: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
69: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
70: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
71: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
65: */
66: FUNCTION CLIENT_GROUPING_METHOD( p_proj_id IN PA_PROJECTS_ALL.project_id%TYPE,
67: p_task_id IN PA_TASKS.task_id%TYPE,
68: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
69: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
70: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
71: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
68: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
69: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
70: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
71: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
69: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
70: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
71: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
70: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
71: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
71: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
72: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
73: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
74: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
82: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
75: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
82: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
83: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
76: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
82: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
83: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
84: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE, /*bug5454123-adding system_reference2,3,4*/
77: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
82: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
83: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
84: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE, /*bug5454123-adding system_reference2,3,4*/
85: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,
78: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
82: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
83: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
84: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE, /*bug5454123-adding system_reference2,3,4*/
85: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,
86: p_ref4 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference4%TYPE)
79: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
80: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
81: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
82: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
83: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
84: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE, /*bug5454123-adding system_reference2,3,4*/
85: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,
86: p_ref4 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference4%TYPE)
87: return VARCHAR2;