PACKAGE: APPS.MTL_LOT_UOM_CONV_PUB

Source

1 PACKAGE MTL_LOT_UOM_CONV_PUB AUTHID CURRENT_USER AS
2 /* $Header: INVPLUCS.pls 120.0 2005/05/25 05:26:27 appldev noship $
3 /* Record Type Declarations */
4 
5 
6 G_TRUE      CONSTANT NUMBER := 1;
7 G_FALSE     CONSTANT NUMBER := 0;
8 
9 TYPE quantity_update_rec_type IS TABLE OF mtl_lot_conv_audit_details%ROWTYPE
10                               INDEX BY BINARY_INTEGER;
11 
12 lot_uom_conv_rec      mtl_lot_uom_class_conversions%ROWTYPE;
13 
14 
15 TYPE lotconv_aud_typ IS RECORD
16 (
17  conv_audit_id      mtl_lot_conv_audit.conv_audit_id%TYPE,
18  conversion_id      mtl_lot_conv_audit.conversion_id%TYPE,
19  conversion_date    mtl_lot_conv_audit.conversion_date%TYPE,
20  update_type_indicator   mtl_lot_conv_audit.update_type_indicator%TYPE,
21  batch_id           mtl_lot_conv_audit.batch_id%TYPE,
22  reason_id          mtl_lot_conv_audit.reason_id%TYPE,
23  old_conversion_rate     mtl_lot_conv_audit.old_conversion_rate%TYPE,
24  new_conversion_rate     mtl_lot_conv_audit.new_conversion_rate%TYPE,
25  event_spec_disp_id      mtl_lot_conv_audit.event_spec_disp_id%TYPE,
26  created_by         mtl_lot_conv_audit.created_by%TYPE,
27  creation_date      mtl_lot_conv_audit.creation_date%TYPE,
28  last_updated_by    mtl_lot_conv_audit.last_updated_by%TYPE,
29  last_update_date   mtl_lot_conv_audit.last_update_date%TYPE,
30  last_update_login  mtl_lot_conv_audit.last_update_login%TYPE
31 );
32 
33 
34 TYPE lotconv_aud_det IS RECORD
35 (
36  conv_audit_detail_id mtl_lot_conv_audit_details.conv_audit_detail_id%TYPE,
37  conv_audit_id         mtl_lot_conv_audit_details.conv_audit_id%TYPE,
38  revision              mtl_lot_conv_audit_details.revision%TYPE,
39  organization_id       mtl_lot_conv_audit_details.organization_id%TYPE,
40  subinventory_code     mtl_lot_conv_audit_details.subinventory_code%TYPE,
41  lpn_id                mtl_lot_conv_audit_details.lpn_id%TYPE,
42  locator_id            mtl_lot_conv_audit_details.locator_id%TYPE,
43  old_primary_qty       mtl_lot_conv_audit_details.old_primary_qty%TYPE,
44  old_secondary_qty     mtl_lot_conv_audit_details.old_secondary_qty%TYPE,
45  new_primary_qty       mtl_lot_conv_audit_details.new_primary_qty%TYPE,
46  new_secondary_qty     mtl_lot_conv_audit_details.new_secondary_qty%TYPE,
47  transaction_primary_qty mtl_lot_conv_audit_details.transaction_primary_qty%TYPE,
48  transaction_secondary_qty mtl_lot_conv_audit_details.transaction_secondary_qty%TYPE,
49  transaction_update_flag mtl_lot_conv_audit_details.transaction_update_flag%TYPE,
50  created_by           mtl_lot_conv_audit_details.created_by%TYPE,
51  creation_date        mtl_lot_conv_audit_details.creation_date%TYPE,
52  last_updated_by      mtl_lot_conv_audit_details.last_updated_by%TYPE,
53  last_update_date     mtl_lot_conv_audit_details.last_update_date%TYPE,
54  last_update_login    mtl_lot_conv_audit_details.last_update_login%TYPE
55 );
56 
57 
58 PROCEDURE create_lot_uom_conversion
59 ( p_api_version           IN              NUMBER
60 , p_init_msg_list         IN              VARCHAR2 DEFAULT FND_API.G_FALSE
61 , p_commit                IN              VARCHAR2 DEFAULT FND_API.G_FALSE
62 , p_validation_level      IN              NUMBER   DEFAULT FND_API.G_VALID_LEVEL_FULL
63 , p_action_type           IN              VARCHAR2
64 , p_update_type_indicator IN              NUMBER DEFAULT 5
65 , p_reason_id             IN              NUMBER
66 , p_batch_id              IN              NUMBER
67 , p_process_data          IN              VARCHAR2 DEFAULT FND_API.G_TRUE
68 , p_lot_uom_conv_rec      IN OUT NOCOPY   mtl_lot_uom_class_conversions%ROWTYPE
69 , p_qty_update_tbl        IN OUT NOCOPY   MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type
70 , x_return_status         OUT NOCOPY      VARCHAR2
71 , x_msg_count             OUT NOCOPY      NUMBER
72 , x_msg_data              OUT NOCOPY      VARCHAR2
73 , x_sequence              IN OUT NOCOPY   NUMBER
74 );
75 
76 
77 
78 END MTL_LOT_UOM_CONV_PUB;