[Home] [Help]
PACKAGE: APPS.WMA_FLOW
Source
1 PACKAGE wma_flow AUTHID CURRENT_USER AS
2 /* $Header: wmapflws.pls 120.1 2007/10/12 18:27:21 vjambhek ship $ */
3
4 /**
5 * This structure is for the parameters passed from the form.
6 */
7 TYPE FlowParam IS RECORD (
8 environment wma_common.environment,
9 scheduleNumber VARCHAR2(30),
10 scheduledFlag NUMBER,
11 assemblyID NUMBER,
12 lineID NUMBER,
13 wipEntityID NUMBER,
14 transactionType NUMBER,
15 transactionHeaderID NUMBER,
16 transactionIntID NUMBER,
17 completionTxnID NUMBER,
18 transactionQty NUMBER,
19 transactionUOM VARCHAR2(3),
20 transactionDate DATE,
21 subinventoryCode VARCHAR2(10),
22 locatorID NUMBER,
23 reasonID NUMBER,
24 qualityID NUMBER,
25 lineOp NUMBER,
26 kanbanID NUMBER,
27 projectID NUMBER,
28 taskID NUMBER,
29 lpnID NUMBER,
30 demandSourceHeaderID NUMBER,
31 demandSourceLine VARCHAR2(30),
32 demandSourceDelivery VARCHAR2(30),
33 headerId NUMBER /*Fix for bug #6216695, which is an FP of 6082623 :
34 Add header id to populate MTLT and MSNT*/
35 );
36
37
38 /**
39 * This structrue is for the record that should be inserted into
40 * mtl_material_transactions_temp table.
41 */
42 TYPE FlowRecord IS RECORD(
43 transaction_interface_id NUMBER,
44 completion_transaction_id NUMBER,
45 transaction_header_id NUMBER,
46 process_flag NUMBER,
47 source_code VARCHAR2(30),
48 last_updated_by NUMBER,
49 last_update_date DATE,
50 creation_date DATE,
51 created_by NUMBER,
52 transaction_mode NUMBER,
53 inventory_item_id NUMBER,
54 organization_id NUMBER,
55 wip_entity_type NUMBER,
56 subinventory_code VARCHAR2(30),
57 locator_id NUMBER,
58 revision VARCHAR2(3),
59 bom_revision VARCHAR2(3),
60 bom_revision_date DATE,
61 routing_revision VARCHAR2(3),
62 routing_revision_date DATE,
63 transaction_uom VARCHAR2(3),
64 transaction_quantity NUMBER,
65 primary_quantity NUMBER,
66 acct_period_id NUMBER,
67 distribution_account_id NUMBER,
68 reason_id NUMBER,
69 qa_collection_id NUMBER,
70 transaction_source_id NUMBER,
71 transaction_source_type_id NUMBER,
72 transaction_type_id NUMBER,
73 transaction_action_id NUMBER,
74 transaction_date DATE,
75 flow_schedule VARCHAR2(1),
76 wipEntityType NUMBER,
77 scheduled_flag NUMBER,
78 schedule_number VARCHAR2(30),
79 repetitive_line_id NUMBER,
80 operation_seq_num NUMBER,
81 accounting_class VARCHAR2(10),
82 kanban_card_id NUMBER,
83 source_project_id NUMBER,
84 source_task_id NUMBER,
85 lpn_id NUMBER,
86 demand_source_header_id NUMBER,
87 demand_source_line VARCHAR2(30),
88 demand_source_delivery VARCHAR2(30),
89 source_line_id NUMBER,
90 source_header_id NUMBER,
91 header_id NUMBER /*Fix for bug #6216695, which is an FP of 6082623 :
92 Add header id to populate MTLT and MSNT*/
93 );
94
95
96
97 PROCEDURE insertParentRecord(param IN FlowParam,
98 status OUT NOCOPY NUMBER,
99 errMessage OUT NOCOPY VARCHAR2);
100
101 PROCEDURE insertParentRecordIntoMMTT(param IN FlowParam,
102 status OUT NOCOPY NUMBER,
103 errMessage OUT NOCOPY VARCHAR2);
104
105 Function derive(param FlowParam,
106 flowRec OUT NOCOPY FlowRecord,
107 errMsg OUT NOCOPY VARCHAR2) return boolean;
108
109 Function put(flowRec FlowRecord, errMsg OUT NOCOPY VARCHAR2) return boolean;
110
111
112 procedure explodeBOMAndDerive(p_assyID in number,
113 p_orgID in number,
114 p_qty in number,
115 p_wipEntityID in number,
116 p_txnDate in date,
117 p_projectID in number,
118 p_taskID in number,
119 p_toOpSeqNum in number,
120 x_lotEntryType out nocopy number,
121 x_compInfo out nocopy system.wip_lot_serial_obj_t,
122 x_returnStatus out nocopy varchar2,
123 x_errMessage out nocopy varchar2);
124
125 END wma_flow;