[Home] [Help]
PACKAGE: APPS.WMA_MATERIAL
Source
1 PACKAGE wma_material AUTHID CURRENT_USER AS
2 /* $Header: wmapmtls.pls 120.0 2005/05/25 07:50:36 appldev noship $ */
3
4 /**
5 * This structure is for the parameters passed from the form.
6 *
7 * HISTORY:
8 * 30-DEC-2004 spondalu Bug 4093569: eAM-WMS Integration enhancements:
9 * Included new member wipEntityType to MtlParam.
10 */
11 TYPE MtlParam IS RECORD (
12 environment wma_common.environment,
13 transactionType NUMBER,
14 transactionHeaderID NUMBER,
15 transactionIntID NUMBER,
16 jobID NUMBER,
17 itemID NUMBER,
18 transactionQty NUMBER,
19 transactionUOM VARCHAR2(3),
20 opSeqNum NUMBER,
21 deptID NUMBER,
22 subinventoryCode VARCHAR2(10),
23 locatorID NUMBER,
24 qualityID NUMBER,
25 projectID NUMBER,
26 taskID NUMBER,
27 revision VARCHAR2(3),
28 isFromSerializedPage NUMBER,
29 wipEntityType NUMBER
30 );
31
32 /**
33 * This structrue is for the record that should be inserted into
34 * MTI.
35 *
36 * HISTORY:
37 * 30-DEC-2004 spondalu Bug 4093569: eAM-WMS Integration enhancements:
38 * Included new element rebuild_item_id in mtlRecord.
39 */
40 TYPE MtlRecord IS RECORD(transaction_header_id NUMBER,
41 transaction_interface_id NUMBER,
42 transaction_mode NUMBER,
43 inventory_item_id NUMBER,
44 subinventory_code VARCHAR2(10),
45 locator_id NUMBER,
46 transaction_date DATE,
47 organization_id NUMBER,
48 acct_period_id NUMBER,
49 last_update_date DATE,
50 last_updated_by NUMBER,
51 creation_date DATE,
52 created_by NUMBER,
53 transaction_source_id NUMBER,
54 transaction_source_type_id NUMBER,
55 source_code VARCHAR2(30),
56 source_line_id NUMBER,
57 source_header_id NUMBER,
58 transaction_quantity NUMBER,
59 primary_quantity NUMBER,
60 transaction_uom VARCHAR2(3),
61 negative_req_flag NUMBER,
62 transaction_action_id NUMBER,
63 transaction_type_id NUMBER,
64 wip_entity_type NUMBER,
65 operation_seq_num NUMBER,
66 department_id NUMBER,
67 revision VARCHAR2(3),
68 project_id NUMBER,
69 task_id NUMBER,
70 source_project_id NUMBER,
71 source_task_id NUMBER,
72 qa_collection_id NUMBER,
73 process_flag NUMBER,
74 final_completion_flag VARCHAR2(1),
75 rebuild_item_id NUMBER);
76
77 /**
78 * This procedure is the entry point into the Material Transaction
79 * processing code.
80 */
81 PROCEDURE process(param IN MtlParam,
82 status OUT NOCOPY NUMBER,
83 errMessage OUT NOCOPY VARCHAR2);
84
85 Function derive(param MtlParam,
86 mtlRec OUT NOCOPY MtlRecord,
87 errMsg OUT NOCOPY VARCHAR2) return boolean;
88
89 Function put(mtlRec MtlRecord, errMsg OUT NOCOPY VARCHAR2) return boolean;
90
91 procedure validateIssueProject(p_orgID in number,
92 p_wipEntityID in number,
93 p_locatorID in number,
94 p_allowCrossIssue in number,
95 x_projectID out nocopy number,
96 x_taskID out nocopy number,
97 x_projectNum out nocopy varchar2,
98 x_taskNum out nocopy varchar2,
99 x_returnStatus out nocopy varchar2,
100 x_returnMsg out nocopy varchar2);
101
102 END wma_material;