1 PACKAGE EAM_PARAMETERS_PUB AS
2 /* $Header: EAMPPRMS.pls 120.1 2005/06/17 02:00:38 appldev $ */
3 /*#
4 * This package is used for the INSERT / UPDATE of Eam Parameters.
5 * It defines 2 key procedures insert_parameters, update_parameters
6 * which first validates and massages the IN parameters
7 * and then carries out the respective operations.
8 * @rep:scope public
9 * @rep:product EAM
10 * @rep:lifecycle active
11 * @rep:displayname Eam Parameters
12 * @rep:category BUSINESS_ENTITY EAM_PARAMETER
13 */
14
15 /*#
16 * This procedure is used to insert records in WIP_EAM_PARAMETERS.
17 * It is used to create Eam Parameters.
18 * @param p_api_version Version of the API
19 * @param p_init_msg_list Flag to indicate initialization of message list
20 * @param p_commit Flag to indicate whether API should commit changes
21 * @param p_validation_level Validation Level of the API
22 * @param x_return_status Return status of the procedure call
23 * @param x_msg_count Count of the return messages that API returns
24 * @param x_msg_data The collection of the messages.
25 * @param p_ORGANIZATION_ID Organization Identifier
26 * @param p_WORK_REQUEST_AUTO_APPROVE Work Request Auto Approve Flag
27 * @param p_DEF_MAINT_COST_CATEGORY Default Maintenance Cost Category
28 * @param p_DEF_EAM_COST_ELEMENT_ID Default Cost Element Identifier
29 * @param p_WORK_REQ_EXTENDED_LOG_FLAG Work Request Extended Log Flag
30 * @param p_DEFAULT_EAM_CLASS Default EAM WIP Accounting Class
31 * @param p_EASY_WORK_ORDER_PREFIX Easy Work Order Prefix
32 * @param p_WORK_ORDER_PREFIX Work Order Prefix
33 * @param p_SERIAL_NUMBER_ENABLED Flag to indicate Asset Number generated automatically
34 * @param p_AUTO_FIRM_FLAG A flag to indicate auto firming of the work order upon release
35 * @param p_MAINTENANCE_OFFSET_ACCOUNT Maintenance Offset Account
36 * @param p_MATERIAL_ISSUE_BY_MO Enable Material Issue Requests
37 * @param p_DEFAULT_DEPARTMENT_ID Default Department Identifier
38 * @param p_INVOICE_BILLABLE_ITEMS_ONLY Whether you want to invoice billable materials only or any material.
39 * @param P_OVERRIDE_BILL_AMOUNT Reserved for future
40 * @param p_BILLING_BASIS Billing Basis: 1=Price List, 2=Cost Plus
41 * @param p_BILLING_METHOD Billing Method: 1=Bill By Requirements, 2=Bill By Activity
42 * @param P_DYNAMIC_BILLING_ACTIVITY Reserved for future
43 * @param p_DEFAULT_ASSET_FLAG Whether to default asset number based on Property location assigned to the employee
44 * @param p_PM_IGNORE_MISSED_WO Whether Preventive Maintenance Engine should generate past work orders.
45 * @param p_issue_zero_cost_flag Whether to issue rebuildables at zero cost or item cost.
46 * @param p_WORK_REQUEST_ASSET_NUM_REQD Flag to denote whether asset number is mandatory during work request creation or not
47 * @param P_EAM_WO_WORKFLOW_ENABLED Stores whether any of the workflow events can be raised for this organization or not. 'Y' indicates the events can be raised, 'N'/Null indicates the events cannot be raised
48 * @param P_AUTO_FIRM_ON_CREATE A flag to indicate auto firming of the job on creation
49 * @return Returns the status of the procedure call as well as the return messages
50 * @rep:scope public
51 * @rep:displayname Insert Eam Parameters
52 */
53
54
55 PROCEDURE insert_parameters
56 (
57 p_api_version IN NUMBER ,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61
62 x_return_status OUT NOCOPY VARCHAR2 ,
63 x_msg_count OUT NOCOPY NUMBER ,
64 x_msg_data OUT NOCOPY VARCHAR2 ,
65
66 P_ORGANIZATION_ID IN NUMBER ,
67 P_WORK_REQUEST_AUTO_APPROVE IN VARCHAR2 default 'N',
68 P_DEF_MAINT_COST_CATEGORY IN NUMBER ,
69 P_DEF_EAM_COST_ELEMENT_ID IN NUMBER ,
70 P_WORK_REQ_EXTENDED_LOG_FLAG IN VARCHAR2 default 'Y',
71 P_DEFAULT_EAM_CLASS IN VARCHAR2 ,
72 P_EASY_WORK_ORDER_PREFIX IN VARCHAR2 default null,
73 P_WORK_ORDER_PREFIX IN VARCHAR2 default null,
74 P_SERIAL_NUMBER_ENABLED IN VARCHAR2 default 'Y',
75 P_AUTO_FIRM_FLAG IN VARCHAR2 default 'Y',
76 P_MAINTENANCE_OFFSET_ACCOUNT IN NUMBER default null,
77 P_MATERIAL_ISSUE_BY_MO IN VARCHAR2 default 'Y',
78 P_DEFAULT_DEPARTMENT_ID IN NUMBER default null,
79 P_INVOICE_BILLABLE_ITEMS_ONLY IN VARCHAR2 default 'N',
80 P_OVERRIDE_BILL_AMOUNT IN VARCHAR2 default null,
81 P_BILLING_BASIS IN NUMBER default null,
82 P_BILLING_METHOD IN NUMBER default null,
83 P_DYNAMIC_BILLING_ACTIVITY IN VARCHAR2 default null,
84 P_DEFAULT_ASSET_FLAG IN VARCHAR2 default 'Y' ,
85 P_PM_IGNORE_MISSED_WO IN VARCHAR2 default 'N',
86 p_issue_zero_cost_flag IN VARCHAR2 default 'Y',
87 p_WORK_REQUEST_ASSET_NUM_REQD IN VARCHAR2 default 'Y',
88 P_EAM_WO_WORKFLOW_ENABLED IN VARCHAR2 default null,
89 P_AUTO_FIRM_ON_CREATE IN VARCHAR2 default null
90 );
91
92 /*#
93 * This procedure is used to update the existing records in WIP_EAM_PARAMETERS.
94 * It is used to update Eam Parameters.
95 * @param p_api_version Version of the API
96 * @param p_init_msg_list Flag to indicate initialization of message list
97 * @param p_commit Flag to indicate whether API should commit changes
98 * @param p_validation_level Validation Level of the API
99 * @param x_return_status Return status of the procedure call
100 * @param x_msg_count Count of the return messages that API returns
101 * @param x_msg_data The collection of the messages.
102 * @param p_ORGANIZATION_ID Organization Identifier
103 * @param p_WORK_REQUEST_AUTO_APPROVE Work Request Auto Approve Flag
104 * @param p_DEF_MAINT_COST_CATEGORY Default Maintenance Cost Category
105 * @param p_DEF_EAM_COST_ELEMENT_ID Default Cost Element Identifier
106 * @param p_WORK_REQ_EXTENDED_LOG_FLAG Work Request Extended Log Flag
107 * @param p_DEFAULT_EAM_CLASS Default EAM WIP Accounting Class
108 * @param p_EASY_WORK_ORDER_PREFIX Easy Work Order Prefix
109 * @param p_WORK_ORDER_PREFIX Work Order Prefix
110 * @param p_SERIAL_NUMBER_ENABLED Flag to indicate Asset Number generated automatically
111 * @param p_AUTO_FIRM_FLAG A flag to indicate auto firming of the work order upon release
112 * @param p_MAINTENANCE_OFFSET_ACCOUNT Maintenance Offset Account
113 * @param p_MATERIAL_ISSUE_BY_MO Enable Material Issue Requests
114 * @param p_DEFAULT_DEPARTMENT_ID Default Department Identifier
115 * @param p_INVOICE_BILLABLE_ITEMS_ONLY Whether you want to invoice billable materials only or any material.
116 * @param P_OVERRIDE_BILL_AMOUNT Reserved for future
117 * @param p_BILLING_BASIS Billing Basis: 1=Price List, 2=Cost Plus
118 * @param p_BILLING_METHOD Billing Method: 1=Bill By Requirements, 2=Bill By Activity
119 * @param P_DYNAMIC_BILLING_ACTIVITY Reserved for future
120 * @param p_DEFAULT_ASSET_FLAG Whether to default asset number based on Property location assigned to the employee
121 * @param p_PM_IGNORE_MISSED_WO Whether Preventive Maintenance Engine should generate past work orders.
122 * @param p_issue_zero_cost_flag Whether to issue rebuildables at zero cost or item cost.
123 * @param p_WORK_REQUEST_ASSET_NUM_REQD Flag to denote whether asset number is mandatory during work request creation or not
124 * @param P_EAM_WO_WORKFLOW_ENABLED Stores whether any of the workflow events can be raised for this organization or not. 'Y' indicates the events can be raised, 'N'/Null indicates the events cannot be raised
125 * @param P_AUTO_FIRM_ON_CREATE A flag to indicate auto firming of the job on creation
126 * @return Returns the status of the procedure call as well as the return messages
127 * @rep:scope public
128 * @rep:displayname Update Eam Parameters
129 */
130
131
132 PROCEDURE update_parameters
133 (
134 p_api_version IN NUMBER ,
135 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
136 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138
139 x_return_status OUT NOCOPY VARCHAR2 ,
140 x_msg_count OUT NOCOPY NUMBER ,
141 x_msg_data OUT NOCOPY VARCHAR2 ,
142
143 P_ORGANIZATION_ID IN NUMBER ,
144 P_WORK_REQUEST_AUTO_APPROVE IN VARCHAR2 default 'N',
145 P_DEF_MAINT_COST_CATEGORY IN NUMBER ,
146 P_DEF_EAM_COST_ELEMENT_ID IN NUMBER ,
147 P_WORK_REQ_EXTENDED_LOG_FLAG IN VARCHAR2 default 'Y',
148 P_DEFAULT_EAM_CLASS IN VARCHAR2 ,
149 P_EASY_WORK_ORDER_PREFIX IN VARCHAR2 default null,
150 P_WORK_ORDER_PREFIX IN VARCHAR2 default null,
151 P_SERIAL_NUMBER_ENABLED IN VARCHAR2 default 'Y',
152 P_AUTO_FIRM_FLAG IN VARCHAR2 default 'Y',
153 P_MAINTENANCE_OFFSET_ACCOUNT IN NUMBER default null,
154 P_MATERIAL_ISSUE_BY_MO IN VARCHAR2 default 'Y',
155 P_DEFAULT_DEPARTMENT_ID IN NUMBER default null,
156 P_INVOICE_BILLABLE_ITEMS_ONLY IN VARCHAR2 default 'N',
157 P_OVERRIDE_BILL_AMOUNT IN VARCHAR2 default null,
158 P_BILLING_BASIS IN NUMBER default null,
159 P_BILLING_METHOD IN NUMBER default null,
160 P_DYNAMIC_BILLING_ACTIVITY IN VARCHAR2 default null,
161 P_DEFAULT_ASSET_FLAG IN VARCHAR2 default 'Y' ,
162 P_PM_IGNORE_MISSED_WO IN VARCHAR2 default 'N',
163 p_issue_zero_cost_flag IN VARCHAR2 default 'Y',
164 p_WORK_REQUEST_ASSET_NUM_REQD IN VARCHAR2 default 'Y',
165 P_EAM_WO_WORKFLOW_ENABLED IN VARCHAR2 default null,
166 P_AUTO_FIRM_ON_CREATE IN VARCHAR2 default null
167 );
168
169 END;