1 package wip_flowResCharge AUTHID CURRENT_USER as
2 /* $Header: wipfsrcs.pls 120.0.12010000.1 2008/07/24 05:22:40 appldev ship $ */
3
4 /**
5 * This procedure is called by flow completion/work orderless completion to charge the
6 * resource and item/lot overhead.
7 * p_txnTempID is the temp id in the MMTT
8 *
9 * We will base the overhead and resource transaction out of the BOM.
10 * 1. Charge the resources even if the auto-charge flag is set to NO.
11 * -- This is based on the count_point_type in bom_operation_sequences
12 * -- 1 Yes Autocharge
13 * -- 2 No Autocharge
14 * -- 3 No Direct Charge
15 * 2. Charge the Lot Based only once if it is pre-planned. Else we charge it everytime.
16 * -- This is based on basis_type in bom_resources
17 * -- 1 Item
18 * -- 2 Lot
19 * -- 3 Resource Unit
20 * -- 4 Resource Value
21 * -- 5 Total Value
22 * -- 6 Activity
23 * 3. We will NOT charge the Manually Charged resources
24 * -- This is based on autocharge_type in bom_operation_resources
25 * -- If this is set to WIP_MOVE where the info about the standard rate is stored,
26 * -- we will still charge this even though it would be OSP resource
27 * -- 1 Wip move
28 * -- 2 Manual
29 * -- 3 PO receipt
30 * -- 4 PO move
31 * 4. Different overhead and ordinary resource
32 * -- This is based on cost_element_id in bom_resources
33 * -- 1 Material
34 * -- 2 Material Overheads
35 * -- 3 Resource
36 * -- 4 Outside Processing
37 * -- 5 Overhead
38 */
39 procedure chargeResourceAndOverhead(p_txnTempID in number,
40 x_returnStatus out NOCOPY varchar2);
41
42 end wip_flowResCharge;