1 PACKAGE WIP_EAM_RESOURCE_TRANSACTION AUTHID CURRENT_USER as
2 /* $Header: wiprstxs.pls 120.4 2010/08/03 12:22:01 vchidura ship $ */
3
4 -- Procedure for validation of the data entered through the JSP
5
6 PROCEDURE resource_validate (
7 p_api_version IN NUMBER
8 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9 ,p_commit IN VARCHAR2 := fnd_api.g_false
10 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
11 ,p_wip_entity_id IN NUMBER
12 ,p_operation_seq_num IN NUMBER
13 ,p_organization_id IN NUMBER
14 ,p_resource_seq_num IN NUMBER
15 ,p_resource_code IN VARCHAR2
16 ,p_uom_code IN VARCHAR2
17 ,p_employee_name IN VARCHAR2
18 ,p_equipment_name IN VARCHAR2
19 ,p_reason IN VARCHAR2
20 ,p_charge_dept IN VARCHAR2
21 ,p_start_time IN DATE DEFAULT TRUNC(SYSDATE) --for bug 8532793
22 ,x_resource_seq_num OUT NOCOPY NUMBER
23 ,x_actual_resource_rate OUT NOCOPY NUMBER
24 ,x_status OUT NOCOPY NUMBER
25 ,x_res_status OUT NOCOPY NUMBER
26 ,x_uom_status OUT NOCOPY NUMBER
27 ,x_employee_status OUT NOCOPY NUMBER
28 ,x_employee_id OUT NOCOPY NUMBER
29 ,x_employee_number OUT NOCOPY VARCHAR2
30 ,x_equipment_status OUT NOCOPY NUMBER
31 ,x_reason_status OUT NOCOPY NUMBER
32 ,x_charge_dept_status OUT NOCOPY NUMBER
33 ,x_machine_status OUT NOCOPY NUMBER
34 ,x_person_status OUT NOCOPY NUMBER
35 ,x_work_order_status OUT NOCOPY NUMBER
36 ,x_instance_id OUT NOCOPY NUMBER
37 ,x_charge_dept_id OUT NOCOPY NUMBER
38 ,x_return_status OUT NOCOPY VARCHAR2
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2);
41
42 -- Procedure for insertion into wcti
43
44 PROCEDURE insert_into_wcti(
45 p_api_version IN NUMBER
46 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47 ,p_commit IN VARCHAR2 := fnd_api.g_false
48 ,p_validation_level IN NUMBER
49 := fnd_api.g_valid_level_full
50 ,p_wip_entity_id IN NUMBER
51 ,p_operation_seq_num IN NUMBER
52 ,p_organization_id IN NUMBER
53 ,p_transaction_qty IN NUMBER
54 ,p_transaction_date IN DATE := null
55 ,p_resource_seq_num IN NUMBER
56 ,p_uom IN VARCHAR2
57 ,p_resource_code IN VARCHAR2
58 ,p_reason_name IN VARCHAR2
59 ,p_reference IN VARCHAR2
60 ,p_instance_id IN NUMBER
61 ,p_serial_number IN VARCHAR2
62 ,p_charge_dept_id IN NUMBER
63 ,p_attribute_category IN VARCHAR2 :=null
64 ,p_attribute1 IN VARCHAR2 :=null
65 ,p_attribute2 IN VARCHAR2 :=null
66 ,p_attribute3 IN VARCHAR2 :=null
67 ,p_attribute4 IN VARCHAR2 :=null
68 ,p_attribute5 IN VARCHAR2 :=null
69 ,p_attribute6 IN VARCHAR2 :=null
70 ,p_attribute7 IN VARCHAR2 :=null
71 ,p_attribute8 IN VARCHAR2 :=null
72 ,p_attribute9 IN VARCHAR2 :=null
73 ,p_attribute10 IN VARCHAR2 :=null
74 ,p_attribute11 IN VARCHAR2 :=null
75 ,p_attribute12 IN VARCHAR2 :=null
76 ,p_attribute13 IN VARCHAR2 :=null
77 ,p_attribute14 IN VARCHAR2 :=null
78 ,p_attribute15 IN VARCHAR2 :=null
79 ,p_actual_resource_rate IN NUMBER := null
80 ,p_employee_id IN NUMBER := null
81 ,p_employee_number IN VARCHAR2 := NULL
82 ,x_return_status OUT NOCOPY VARCHAR2
83 ,x_msg_count OUT NOCOPY NUMBER
84 ,x_msg_data OUT NOCOPY VARCHAR2);
85
86 --Procedure for attaching instances to the operations in a work order
87
88 PROCEDURE insert_into_wori(
89 p_api_version IN NUMBER
90 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
91 ,p_commit IN VARCHAR2 := fnd_api.g_false
92 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
93 ,p_wip_entity_id IN NUMBER
94 ,p_operation_seq_num IN NUMBER
95 ,p_organization_id IN NUMBER
96 ,p_resource_seq_num IN NUMBER
97 ,p_instance_id IN NUMBER
98 ,p_serial_number IN VARCHAR2
99 ,p_start_date IN DATE
100 ,p_completion_date IN DATE
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2);
104
105 -- API called by Costing to insert into WED and WRO during receiving
106
107 PROCEDURE WIP_EAMRCVDIRECTITEM_HOOK
108 ( p_api_version IN NUMBER
109 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
110 ,p_commit IN VARCHAR2 := fnd_api.g_false
111 ,p_rcv_txn_id IN NUMBER
112 ,p_primary_qty IN NUMBER
113 ,p_primary_uom IN VARCHAR2
114 ,p_unit_price IN NUMBER
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2);
118
119
120 END WIP_EAM_RESOURCE_TRANSACTION;