[Home] [Help]
PACKAGE: APPS.EAM_CE_WORK_ORDER_LINES_PKG
Source
1 PACKAGE EAM_CE_WORK_ORDER_LINES_PKG AS
2 /* $Header: EAMTCWOS.pls 120.0.12010000.2 2009/01/03 00:11:42 devijay noship $ */
3 -- Start of Comments
4 -- Package name : EAM_CE_WORK_ORDER_LINES_PKG
5 -- Purpose : Base Package to Insert/Delete/Update EAM_CE_WORK_ORDER_LINES
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_CE_WORK_ORDER_LINES_PKG';
11 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMTCWOS.pls';
12
13 PROCEDURE INSERT_ROW(
14 p_estimate_work_order_line_id NUMBER,
15 p_estimate_work_order_id NUMBER,
16 p_src_cu_id NUMBER,
17 p_src_activity_id NUMBER,
18 p_src_activity_qty NUMBER,
19 p_src_op_seq_num NUMBER,
20 p_src_acct_class_code VARCHAR2,
21 p_src_diff_id NUMBER,
22 p_diff_qty NUMBER,
23 p_estimate_id NUMBER,
24 p_organization_id NUMBER,
25 p_work_order_seq_num NUMBER,
26 p_work_order_number VARCHAR2,
27 p_work_order_description VARCHAR2,
28 p_ref_wip_entity_id NUMBER,
29 p_primary_item_id NUMBER,
30 p_status_type NUMBER,
31 p_acct_class_code VARCHAR2,
32 p_scheduled_start_date DATE,
33 p_scheduled_completion_date DATE,
34 p_project_id NUMBER,
35 p_task_id NUMBER,
36 p_maintenance_object_id NUMBER,
37 p_maintenance_object_type NUMBER,
38 p_maintenance_object_source NUMBER,
39 p_owning_department_id NUMBER,
40 p_user_defined_status_id NUMBER,
41 p_op_seq_num NUMBER,
42 p_op_description VARCHAR2,
43 p_standard_operation_id NUMBER,
44 p_op_department_id NUMBER,
45 p_op_long_description VARCHAR2,
46 p_res_seq_num NUMBER,
47 p_res_id NUMBER,
48 p_res_uom VARCHAR2,
49 p_res_basis_type NUMBER,
50 p_res_usage_rate_or_amount NUMBER,
51 p_res_required_units NUMBER,
52 p_res_assigned_units NUMBER,
53 p_item_type NUMBER,
54 p_required_quantity NUMBER,
55 p_unit_price NUMBER,
56 p_uom VARCHAR2,
57 p_basis_type NUMBER,
58 p_suggested_vendor_name VARCHAR2,
59 p_suggested_vendor_id NUMBER,
60 p_suggested_vendor_site VARCHAR2,
61 p_suggested_vendor_site_id NUMBER,
62 p_mat_inventory_item_id NUMBER,
63 p_mat_component_seq_num NUMBER,
64 p_mat_supply_subinventory VARCHAR2,
65 p_mat_supply_locator_id NUMBER,
66 p_di_amount NUMBER,
67 p_di_order_type_lookup_code VARCHAR2,
68 p_di_description VARCHAR2,
69 p_di_purchase_category_id NUMBER,
70 p_di_auto_request_material VARCHAR2,
71 p_di_need_by_date DATE,
72 p_work_order_line_cost NUMBER,
73 p_creation_date DATE,
74 p_created_by NUMBER,
75 p_last_update_date DATE,
76 p_last_updated_by NUMBER,
77 p_last_update_login NUMBER,
78 p_work_order_type NUMBER,
79 p_activity_type NUMBER,
80 p_activity_source NUMBER,
81 p_activity_cause NUMBER,
82 p_available_qty NUMBER,
83 p_item_comments VARCHAR2,
84 p_cu_qty NUMBER,
85 p_res_sch_flag NUMBER
86 );
87
88 PROCEDURE UPDATE_ROW(
89 p_estimate_work_order_line_id NUMBER,
90 p_estimate_work_order_id NUMBER,
91 p_src_cu_id NUMBER,
92 p_src_activity_id NUMBER,
93 p_src_activity_qty NUMBER,
94 p_src_op_seq_num NUMBER,
95 p_src_acct_class_code VARCHAR2,
96 p_src_diff_id NUMBER,
97 p_diff_qty NUMBER,
98 p_estimate_id NUMBER,
99 p_organization_id NUMBER,
100 p_work_order_seq_num NUMBER,
101 p_work_order_number VARCHAR2,
102 p_work_order_description VARCHAR2,
103 p_ref_wip_entity_id NUMBER,
104 p_primary_item_id NUMBER,
105 p_status_type NUMBER,
106 p_acct_class_code VARCHAR2,
107 p_scheduled_start_date DATE,
108 p_scheduled_completion_date DATE,
109 p_project_id NUMBER,
110 p_task_id NUMBER,
111 p_maintenance_object_id NUMBER,
112 p_maintenance_object_type NUMBER,
113 p_maintenance_object_source NUMBER,
114 p_owning_department_id NUMBER,
115 p_user_defined_status_id NUMBER,
116 p_op_seq_num NUMBER,
117 p_op_description VARCHAR2,
118 p_standard_operation_id NUMBER,
119 p_op_department_id NUMBER,
120 p_op_long_description VARCHAR2,
121 p_res_seq_num NUMBER,
122 p_res_id NUMBER,
123 p_res_uom VARCHAR2,
124 p_res_basis_type NUMBER,
125 p_res_usage_rate_or_amount NUMBER,
126 p_res_required_units NUMBER,
127 p_res_assigned_units NUMBER,
128 p_item_type NUMBER,
129 p_required_quantity NUMBER,
130 p_unit_price NUMBER,
131 p_uom VARCHAR2,
132 p_basis_type NUMBER,
133 p_suggested_vendor_name VARCHAR2,
134 p_suggested_vendor_id NUMBER,
135 p_suggested_vendor_site VARCHAR2,
136 p_suggested_vendor_site_id NUMBER,
137 p_mat_inventory_item_id NUMBER,
138 p_mat_component_seq_num NUMBER,
139 p_mat_supply_subinventory VARCHAR2,
140 p_mat_supply_locator_id NUMBER,
141 p_di_amount NUMBER,
142 p_di_order_type_lookup_code VARCHAR2,
143 p_di_description VARCHAR2,
144 p_di_purchase_category_id NUMBER,
145 p_di_auto_request_material VARCHAR2,
146 p_di_need_by_date DATE,
147 p_work_order_line_cost NUMBER,
148 p_creation_date DATE,
149 p_created_by NUMBER,
150 p_last_update_date DATE,
151 p_last_updated_by NUMBER,
152 p_last_update_login NUMBER,
153 p_work_order_type NUMBER,
154 p_activity_type NUMBER,
155 p_activity_source NUMBER,
156 p_activity_cause NUMBER,
157 p_available_qty NUMBER,
158 p_item_comments VARCHAR2,
159 p_cu_qty NUMBER,
160 p_res_sch_flag NUMBER
161 );
162
163 PROCEDURE DELETE_ALL_WITH_ESTIMATE_ID(
164 p_estimate_id IN NUMBER
165 );
166
167 PROCEDURE DELETE_ROW(
168 p_work_order_line_id IN NUMBER
169 );
170
171 END EAM_CE_WORK_ORDER_LINES_PKG;