1 package wip_cplProc_priv AUTHID CURRENT_USER as
2 /* $Header: wipcplps.pls 120.3 2007/09/17 19:52:10 vjambhek ship $ */
3
4 ---------------
5 --public types
6 ---------------
7 type completion_rec_t is record(wipEntityType NUMBER,
8 wipEntityID NUMBER,
9 orgID NUMBER,
10 repLineID NUMBER,
11 itemID NUMBER,
12 txnActionID NUMBER,
13 priQty NUMBER,
14 txnQty NUMBER,
15 txnDate DATE,
16 cplTxnID NUMBER,
17 movTxnID NUMBER,
18 kanbanCardID NUMBER,
19 qaCollectionID NUMBER,
20 lastOpSeq NUMBER,
21 revision VARCHAR2(3),
22 mtlAlcTmpID NUMBER,
23 txnHdrID NUMBER,
24 txnStatus NUMBER,
25 overCplPriQty NUMBER,
26 overCplTxnID NUMBER,
27 lastUpdBy NUMBER,
28 createdBy NUMBER,
29 lpnID NUMBER,
30 txnMode NUMBER);
31 ---------------------------------------------------------------------------------------------
32 -- Processes a single completion transaction in MMTT
33 --
34 --parameters:
35 -- + p_txnTmpID: mmtt identifier of the completion txn
36 -- + p_initMsgList: initialize the message stack?
37 -- + p_endDebug: Clean up the log file? Pass fnd_api.g_true unless you plan to call
38 -- wip_logger.cleanUp() later.
39 -- + x_returnStatus: fnd_api.g_ret_sts_success on successful processing.
40 -- fnd_api.g_exc_error if l/s information is for the components
41 -- is missing
42 -- fnd_api.g_ret_sts_unexp_error if an unexpected error occurred or one or
43 -- more records failed processing.
44 ---------------------------------------------------------------------------------------------
45 procedure processTemp(p_txnTmpID IN NUMBER,
46 p_initMsgList IN VARCHAR2,
47 p_endDebug IN VARCHAR2,
48 x_returnStatus OUT NOCOPY VARCHAR2);
49
50 procedure preAllocateSchedules(p_txnHdrID IN NUMBER,
51 p_cplTxnID IN NUMBER,
52 p_txnActionID IN NUMBER,
53 p_wipEntityID IN NUMBER,
54 p_repLineID IN NUMBER,
55 p_tblName IN VARCHAR2,
56 p_endDebug IN VARCHAR2,
57 x_returnStatus OUT NOCOPY VARCHAR2);
58
59 procedure processOverCpl(p_cplRec IN OUT NOCOPY completion_rec_t,
60 x_returnStatus OUT NOCOPY VARCHAR2);
61
62 /***************************************************************************
63 *
64 * This procedure will be called from WIP OA Transaction page to do completion
65 * and return transactions for Discrete jobs. User needs to insert record into
66 * MTL_TRANSACTIONS_INTERFACE before calling this routine.
67 *
68 * PARAMETER:
69 *
70 * p_org_id organization_id in MTL_TRANSACTIONS_INTERFACE
71 * p_interface_id transaction_interface_id in
72 * MTL_TRANSACTIONS_INTERFACE
73 * p_mtl_header_id transaction_header_id in MTL_TRANSACTIONS_INTERFACE
74 * p_oc_primary_qty overcompletion_primary_qty in
75 * p_assySerial Assembly serial number. This parameter will be used
76 * to differentiate between regular and serialized
77 * transactions.
78 * p_print_label Print Label flag. This parameter will be used to pass
79 * the value of the Administrator preference 'Standard
80 * Operations for Move Labels' for the current transaction.
81 * x_return_status There are 2 possible values
82 * *fnd_api.g_ret_sts_success*
83 * means the every record was succesfully processed
84 * *fnd_api.g_ret_sts_error*
85 * means some records error out
86 *
87 * NOTE:
88 * The user don't need to insert child record for online over completion.
89 * This API will take care everything. The user also don't need
90 * to call QA API for online transaction either.
91 ***************************************************************************/
92 PROCEDURE processOATxn(p_org_id IN NUMBER,
93 p_interface_id IN NUMBER,
94 p_mtl_header_id IN NUMBER,
95 p_oc_primary_qty IN NUMBER,
96 p_assySerial IN VARCHAR2:= NULL,
97 p_print_label IN NUMBER default null,/*VJ Label Printing*/
98 x_returnStatus OUT NOCOPY VARCHAR2);
99 end wip_cplProc_priv;