1 PACKAGE wma_resource AUTHID CURRENT_USER AS
2 /* $Header: wmapress.pls 115.2 2002/11/13 03:07:29 kboonyap noship $ */
3
4 /**
5 * Contains the set of parameters that will be passed from the Mobile Apps
6 * Resource Transaction form to the process procedure for processing the
7 * transaction. The list contains all displayed fields as well as hidden
8 * fields (derived from LOVs on the form)
9 * All fields are initialized to FND_API initialization values. Boolean
10 * values are initailized to false. Strings lengths are derived from
11 * those defined in WIP_CONSTANTS package.
12 */
13 TYPE ResParams IS RECORD
14 (
15 environment wma_common.environment,
16 newResource BOOLEAN,
17 wipEntityID NUMBER,
18 wipEntityName VARCHAR2(241),
19 itemID NUMBER,
20 itemName VARCHAR2(241),
21 resourceID NUMBER,
22 resourceName VARCHAR2(241),
23 resourceSeq NUMBER,
24 opSeq NUMBER,
25 transactionQty NUMBER,
26 transactionUOM VARCHAR2(4)
27 );
28
29
30 /**
31 * This is the record type for the record to be populated and inserted into
32 * the WIP_COST_TXN_INTERFACE table.
33 */
34 TYPE ResTxnRec IS RECORD (row wip_cost_txn_interface%ROWTYPE);
35
36
37 /**
38 * This procedure is the entry point into the Resource Transaction
39 * processing code for background processing.
40 */
41 PROCEDURE process(parameters IN ResParams,
42 status OUT NOCOPY NUMBER,
43 errMessage OUT NOCOPY VARCHAR2);
44
45
46 /**
47 * This function derives and validates the values necessary for executing a
48 * resource transaction. Given the form parameters, it populates
49 * resRecord preparing it to be inserted into the interface table.
50 */
51 FUNCTION derive(resRecord IN OUT NOCOPY ResTxnRec,
52 parameters IN ResParams,
53 errMessage IN OUT NOCOPY VARCHAR2) return boolean;
54
55
56 /**
57 * Inserts a populated ResTxnRec record into WIP_COST_TXN_INTERFACE
58 */
59 FUNCTION put(resRecord IN ResTxnRec,
60 errMessage IN OUT NOCOPY VARCHAR2) return boolean;
61
62
63 END wma_resource;