1 PACKAGE WIP_EAM_RESOURCE_TRANSACTION as
2 /* $Header: wiprstxs.pls 120.2.12000000.1 2007/01/18 22:20:54 appldev 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 ,x_resource_seq_num OUT NOCOPY NUMBER
22 ,x_actual_resource_rate OUT NOCOPY NUMBER
23 ,x_status OUT NOCOPY NUMBER
24 ,x_res_status OUT NOCOPY NUMBER
25 ,x_uom_status OUT NOCOPY NUMBER
26 ,x_employee_status OUT NOCOPY NUMBER
27 ,x_employee_id OUT NOCOPY NUMBER
28 ,x_employee_number OUT NOCOPY VARCHAR2
29 ,x_equipment_status OUT NOCOPY NUMBER
30 ,x_reason_status OUT NOCOPY NUMBER
31 ,x_charge_dept_status OUT NOCOPY NUMBER
32 ,x_machine_status OUT NOCOPY NUMBER
33 ,x_person_status OUT NOCOPY NUMBER
34 ,x_work_order_status OUT NOCOPY NUMBER
35 ,x_instance_id OUT NOCOPY NUMBER
36 ,x_charge_dept_id OUT NOCOPY NUMBER
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2);
40
41 -- Procedure for insertion into wcti
42
43 PROCEDURE insert_into_wcti(
44 p_api_version IN NUMBER
45 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
46 ,p_commit IN VARCHAR2 := fnd_api.g_false
47 ,p_validation_level IN NUMBER
48 := fnd_api.g_valid_level_full
49 ,p_wip_entity_id IN NUMBER
50 ,p_operation_seq_num IN NUMBER
51 ,p_organization_id IN NUMBER
52 ,p_transaction_qty IN NUMBER
53 ,p_transaction_date IN DATE := null
54 ,p_resource_seq_num IN NUMBER
55 ,p_uom IN VARCHAR2
56 ,p_resource_code IN VARCHAR2
57 ,p_reason_name IN VARCHAR2
58 ,p_reference IN VARCHAR2
59 ,p_instance_id IN NUMBER
60 ,p_serial_number IN VARCHAR2
61 ,p_charge_dept_id IN NUMBER
62 ,p_actual_resource_rate IN NUMBER := null
63 ,p_employee_id IN NUMBER := null
64 ,p_employee_number IN VARCHAR2 := null
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_count OUT NOCOPY NUMBER
67 ,x_msg_data OUT NOCOPY VARCHAR2);
68
69 --Procedure for attaching instances to the operations in a work order
70
71 PROCEDURE insert_into_wori(
72 p_api_version IN NUMBER
73 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
74 ,p_commit IN VARCHAR2 := fnd_api.g_false
75 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
76 ,p_wip_entity_id IN NUMBER
77 ,p_operation_seq_num IN NUMBER
78 ,p_organization_id IN NUMBER
79 ,p_resource_seq_num IN NUMBER
80 ,p_instance_id IN NUMBER
81 ,p_serial_number IN VARCHAR2
82 ,p_start_date IN DATE
83 ,p_completion_date IN DATE
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2);
87
88 -- API called by Costing to insert into WED and WRO during receiving
89
90 PROCEDURE WIP_EAMRCVDIRECTITEM_HOOK
91 ( p_api_version IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
93 ,p_commit IN VARCHAR2 := fnd_api.g_false
94 ,p_rcv_txn_id IN NUMBER
95 ,p_primary_qty IN NUMBER
96 ,p_primary_uom IN VARCHAR2
97 ,p_unit_price IN NUMBER
98 ,x_return_status OUT NOCOPY VARCHAR2
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,x_msg_data OUT NOCOPY VARCHAR2);
101
102
103 END WIP_EAM_RESOURCE_TRANSACTION;