PACKAGE: APPS.WMA_CFM

Source

1 PACKAGE wma_cfm AUTHID CURRENT_USER AS
2 /* $Header: wmapcfms.pls 115.9 2003/09/08 22:01:13 rlohani ship $ */
3 
4   /**
5    * This structure is for the parameters passed from the form.
6    */
7   TYPE CfmParam 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     transactionInterfaceID  NUMBER,
17     transactionQty          NUMBER,
18     transactionUOM          VARCHAR2(3),
19     transactionDate         DATE,
20     subinventoryCode        VARCHAR2(10),
21     locatorID               NUMBER,
22     reasonID                NUMBER,
23     qualityID               NUMBER,
24     lineOp                  NUMBER,
25     kanbanID                NUMBER,
26     projectID               NUMBER,
27     taskID                  NUMBER,
28     demandSourceHeaderID    NUMBER,
29     demandSourceLine        VARCHAR2(30),
30     demandSourceDelivery    VARCHAR2(30)
31   );
32 
33   TYPE LpnCfmParam IS RECORD (
34     environment             wma_common.environment,
35     scheduleNumber          VARCHAR2(30),
36     scheduledFlag           NUMBER,
37     assemblyID              NUMBER,
38     lineID                  NUMBER,
39     headerID                NUMBER,
40     transactionType         NUMBER,
41     transactionQty          NUMBER,
42     transactionUOM          VARCHAR2(3),
43     transactionDate         DATE,
44     subinventoryCode        VARCHAR2(10),
45     locatorID               NUMBER,
46     reasonID                NUMBER,
47     qualityID               NUMBER,
48     lineOp                  NUMBER,
49     kanbanID                NUMBER,
50     lpnID                   NUMBER,
51     completionTxnID         NUMBER,
52     wipEntityID             NUMBER,
53     demandSourceHeaderID    NUMBER,
54     demandSourceLine        VARCHAR2(30),
55     demandSourceDelivery    VARCHAR2(30)
56   );
57 
58   /**
59    * This structrue is for the record that should be inserted into
60    * mtl_transactions_interface table.
61    */
62   TYPE CfmRecord IS RECORD (row mtl_transactions_interface%ROWTYPE);
63   TYPE LpnCfmRecord IS RECORD (row wip_lpn_completions%ROWTYPE);
64 
65   PROCEDURE process(param      IN     CfmParam,
66                     status     OUT NOCOPY NUMBER,
67                     errMessage OUT NOCOPY VARCHAR2);
68 
69   PROCEDURE process(lpnParam   IN     LpnCfmParam,
70                     status     OUT NOCOPY NUMBER,
71                     errMessage OUT NOCOPY VARCHAR2);
72 
73   Function derive(param CfmParam,
74                   cfmRec OUT NOCOPY CfmRecord,
75                   errMsg OUT NOCOPY VARCHAR2) return boolean;
76 
77   Function derive(lpnParam LpnCfmParam,
78                   lpnCfmRec OUT NOCOPY LpnCfmRecord,
79                   errMsg OUT NOCOPY VARCHAR2) return boolean;
80 
81   Function put(cfmRec CfmRecord, errMsg OUT NOCOPY VARCHAR2) return boolean;
82 
83   Function put(lpnCfmRec LpnCfmRecord, errMsg OUT NOCOPY VARCHAR2) return boolean;
84 
85 END wma_cfm;