[Home] [Help]
PACKAGE: APPS.PA_CLIENT_EXTEN_CIP_GROUPING
Source
1 Package PA_CLIENT_EXTEN_CIP_GROUPING AUTHID CURRENT_USER AS
2 /* $Header: PAXGCES.pls 120.5 2007/02/06 09:30:20 rshaik ship $ */
3 /*#
4 * You can use this extension to define a unique method that your company uses to specify how expenditure lines are grouped
5 * to form asset lines.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname CIP Grouping
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_CAPITAL_ASSET
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15
16 /*#
20 * @rep:paraminfo {@rep:required}
17 * You can use this function to define how expenditures lines are grouped to form asset lines.
18 * @return Returns the the method of grouping expenditure lines to form asset lines.
19 * @param p_proj_id Identifier of the project
21 * @param p_task_id Identifier of the task
22 * @rep:paraminfo {@rep:required}
23 * @param p_expnd_item_id Identifier of the expenditure item
24 * @rep:paraminfo {@rep:required}
25 * @param p_expnd_id Identifier of the expenditure
26 * @rep:paraminfo {@rep:required}
27 * @param p_expnd_type Identifier of the expenditure type
28 * @rep:paraminfo {@rep:required}
29 * @param p_expnd_category Identifier of the expenditure category
30 * @rep:paraminfo {@rep:required}
31 * @param p_attribute1 Descriptive flexfield segment
32 * @rep:paraminfo {@rep:required}
33 * @param p_attribute2 Descriptive flexfield segment
34 * @rep:paraminfo {@rep:required}
35 * @param p_attribute3 Descriptive flexfield segment
36 * @rep:paraminfo {@rep:required}
37 * @param p_attribute4 Descriptive flexfield segment
38 * @rep:paraminfo {@rep:required}
39 * @param p_attribute5 Descriptive flexfield segment
40 * @rep:paraminfo {@rep:required}
41 * @param p_attribute6 Descriptive flexfield segment
42 * @rep:paraminfo {@rep:required}
43 * @param p_attribute7 Descriptive flexfield segment
44 * @rep:paraminfo {@rep:required}
45 * @param p_attribute8 Descriptive flexfield segment
46 * @rep:paraminfo {@rep:required}
47 * @param p_attribute9 Descriptive flexfield segment
48 * @rep:paraminfo {@rep:required}
49 * @param p_attribute10 Descriptive flexfield segment
50 * @rep:paraminfo {@rep:required}
51 * @param p_attribute_category Descriptive flexfield category
52 * @rep:paraminfo {@rep:required}
53 * @param p_transaction_source Transaction source
54 * @rep:paraminfo {@rep:required}
55 * @param p_ref2 System reference 2
56 * @rep:paraminfo {@rep:required}
57 * @param p_ref3 System reference 3
58 * @rep:paraminfo {@rep:required}
59 * @param p_ref4 System reference 4
60 * @rep:paraminfo {@rep:required}
61 * @rep:scope public
62 * @rep:lifecycle active
63 * @rep:displayname Client Grouping Method
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,
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,
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;
88
89 END PA_CLIENT_EXTEN_CIP_GROUPING;