1 package wip_mtlTempProc_grp AUTHID CURRENT_USER as
2 /* $Header: wiptmpps.pls 115.7 2003/09/19 02:47:01 kmreddy ship $ */
3
4
5 type comp_rec_t is record(txnTmpID NUMBER,
6 mtlTxnID NUMBER,
7 wipEntityId NUMBER,
8 repLineID NUMBER,
9 orgID NUMBER,
10 itemID NUMBER,
11 opSeqNum NUMBER,
12 primaryQty NUMBER,
13 txnQty NUMBER,
14 negReqFlag NUMBER,
15 wipSupplyType NUMBER,
16 wipEntityType NUMBER,
17 supplySub VARCHAR2(10),
18 supplyLocID NUMBER,
19 txnDate DATE,
20 txnHdrID NUMBER,
21 movTxnID NUMBER,
22 cplTxnID NUMBER,
23 qaCollectionID NUMBER,
24 deptID NUMBER,
25 txnActionID NUMBER,
26 serialControlCode NUMBER,
27 lotControlCode NUMBER,
28 eamItemType NUMBER,
29 rebuildItemID NUMBER,
30 rebuildJobName VARCHAR2(240),
31 rebuildActivityID NUMBER,
32 rebuildSerialNumber VARCHAR2(30));
33
34 --Procedure to process WIP transactions out of MMTT. Currently a limited number of transaction
35 --types are supported:
36 -- + component issues
37 -- + component returns
38 -- + component negative issues
39 -- + component negative returns
40 -- + Scraps (no WIP processing involved)
41 -- + Cost Updates (no WIP processing involved)
42 -- Arguments:
43 -- + p_initMsgList: Pass fnd_api.g_true to initialize the message list.
44 -- Pass fnd_api.g_false to leave the message list intact.
45 -- + p_processInv: Pass fnd_api.g_true to invoke the TM
46 -- Pass fnd_api.g_false to only perform WIP processing
47 -- + p_txnHdrID: the transaction_header_id value of the MMTT records to be processed.
48 -- + p_mtlTxnBusinessFlowCode: This will be passed to the inv TM for component transactions.
49 -- It is generally used for label printing purposes. If null, then
50 -- label printing does not occur.
51 -- + x_returnStatus: fnd_api.g_ret_sts_success if all rows were processed successfully.
52 -- fnd_api.g_ret_sts_error OR fnd_api.g_ret_sts_unexp_error if some rows failed.
53 -- + x_errorMsg: A concatenation of all the error messages for any rows that failed. It is limited
54 -- to 2000 characters in length. Each row's error_code and error_explanation columns
55 -- should be updated for that row's specific error.
56 procedure processTemp(p_initMsgList IN VARCHAR2,
57 p_processInv IN VARCHAR2, --whether or not to call inventory TM
58 p_txnHdrID IN NUMBER,
59 p_mtlTxnBusinessFlowCode IN NUMBER := null,
60 x_returnStatus OUT NOCOPY VARCHAR2,
61 x_errorMsg OUT NOCOPY VARCHAR2);
62
63 procedure processWIP(p_txnTmpID IN NUMBER,
64 x_returnStatus OUT NOCOPY VARCHAR2,
65 x_errorMsg OUT NOCOPY VARCHAR2);
66
67 function isTxnIDRequired(p_txnTmpID IN NUMBER) return boolean;
68
69 end wip_mtlTempProc_grp;
[Home] [Help]