DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTEN_CIP_GROUPING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 5: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,

1: Package BODY PA_CLIENT_EXTEN_CIP_GROUPING AS
2: /* $Header: PAXGCEB.pls 120.5 2007/02/06 09:30:05 rshaik ship $ */
3: FUNCTION CLIENT_GROUPING_METHOD( p_proj_id IN PA_PROJECTS_ALL.project_id%TYPE,
4: p_task_id IN PA_TASKS.task_id%TYPE,
5: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
6: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 6: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,

2: /* $Header: PAXGCEB.pls 120.5 2007/02/06 09:30:05 rshaik ship $ */
3: FUNCTION CLIENT_GROUPING_METHOD( p_proj_id IN PA_PROJECTS_ALL.project_id%TYPE,
4: p_task_id IN PA_TASKS.task_id%TYPE,
5: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
6: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

5: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
6: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

6: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,

Line 16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

12: p_attribute4 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
20: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,

Line 17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

13: p_attribute5 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
20: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
21: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE,

Line 18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

14: p_attribute6 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
20: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
21: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE,
22: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,

Line 19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,

15: p_attribute7 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
20: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
21: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE,
22: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,
23: p_ref4 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference4%TYPE)

Line 20: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,

16: p_attribute8 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
17: p_attribute9 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
18: p_attribute10 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
19: p_attribute_category IN PA_EXPENDITURE_ITEMS_ALL.attribute_category%TYPE,
20: p_transaction_source IN PA_EXPENDITURE_ITEMS_ALL.transaction_source%TYPE,
21: p_ref2 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference2%TYPE,
22: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,
23: p_ref4 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference4%TYPE)
24: return VARCHAR2 IS