1 PACKAGE INV_ROI_INTEGRATION_GRP AS
2 /* $Header: INVPROIS.pls 120.1 2005/12/19 03:06:12 ragsriva noship $*/
3
4 --G_TRUE CONSTANT NUMBER := 1;
5 --G_FALSE CONSTANT NUMBER := 0;
6
7 g_ret_sts_success CONSTANT VARCHAR2(1) := 'S';
8 g_ret_sts_error CONSTANT VARCHAR2(1) := 'E';
9 g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := 'U';
10
11
12 /*Exception definitions */
13 g_exc_error EXCEPTION;
14 g_exc_unexpected_error EXCEPTION;
15
16 /*Global variable for storing the INV:DEBUG TRACE profile value */
17 g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
18
19 PROCEDURE INV_VALIDATE_LOT(
20 x_return_status OUT NOCOPY VARCHAR2 ,
21 x_msg_data OUT NOCOPY VARCHAR2 ,
22 x_msg_count OUT NOCOPY NUMBER ,
23 p_api_version IN NUMBER DEFAULT 1.0 ,
24 p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
25 p_mtlt_rowid IN ROWID ,
26 p_transaction_type_id IN VARCHAR2 ,
27 p_new_lot IN VARCHAR2 ,
28 p_item_id IN NUMBER ,
29 p_to_organization_id IN NUMBER ,
30 p_lot_number IN VARCHAR2 ,
31 p_parent_lot_number IN VARCHAR2 ,
32 p_lot_quantity IN NUMBER ,
33 x_lot_secondary_quantity IN OUT NOCOPY NUMBER , ----bug 4025610
34 p_line_secondary_quantity IN NUMBER ,
35 p_secondary_unit_of_measure IN VARCHAR2 ,
36 p_transaction_unit_of_measure IN VARCHAR2 ,
37 p_source_document_code IN VARCHAR2 ,
38 p_OE_ORDER_HEADER_ID IN NUMBER ,
39 p_OE_ORDER_LINE_ID IN NUMBER ,
40 p_rti_id IN NUMBER ,
41 p_revision IN VARCHAR2 ,
42 p_subinventory_code IN VARCHAR2 ,
43 p_locator_id IN NUMBER ,
44 p_transaction_type IN VARCHAR2 ,
45 p_parent_txn_type IN VARCHAR2,
46 p_lot_primary_qty IN NUMBER -- Bug# 4233182
47 );
48
49 PROCEDURE INV_Synch_Quantities(
50 x_return_status OUT NOCOPY VARCHAR2 ,
51 x_msg_data OUT NOCOPY VARCHAR2 ,
52 x_msg_count OUT NOCOPY NUMBER ,
53 x_sum_sourcedoc_quantity OUT NOCOPY NUMBER ,
54 x_sum_rti_secondary_quantity OUT NOCOPY NUMBER ,
55 p_api_version IN NUMBER DEFAULT 1.0 ,
56 p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
57 p_inventory_item_id IN NUMBER ,
58 p_to_organization_id IN NUMBER ,
59 p_lot_number IN VARCHAR2 ,
60 p_transaction_unit_of_measure IN VARCHAR2 ,
61 p_sourcedoc_unit_of_meaure IN VARCHAR2 ,
62 p_lot_quantity IN NUMBER ,
63 p_line_secondary_quantity IN NUMBER ,
64 p_secondary_unit_of_measure IN VARCHAR2 ,
65 p_lot_secondary_quantity IN NUMBER
66 );
67
68 PROCEDURE INV_New_lot(
69 x_return_status OUT NOCOPY VARCHAR2 ,
70 x_msg_count OUT NOCOPY NUMBER ,
71 x_msg_data OUT NOCOPY VARCHAR2 ,
72 p_api_version IN NUMBER DEFAULT 1.0 ,
73 p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
74 p_source_document_code IN VARCHAR2 ,
75 p_item_id IN NUMBER ,
76 p_from_organization_id IN NUMBER ,
77 p_to_organization_id IN NUMBER ,
78 p_lot_number IN VARCHAR2 ,
79 p_lot_quantity IN NUMBER ,
80 p_lot_secondary_quantity IN NUMBER ,
81 p_line_secondary_quantity IN NUMBER ,
82 p_primary_unit_of_measure IN VARCHAR2 ,
83 p_secondary_unit_of_measure IN VARCHAR2 ,
84 p_uom_code IN VARCHAR2 ,
85 p_secondary_uom_code IN VARCHAR2 ,
86 p_reason_id IN NUMBER ,
87 P_MLN_REC IN mtl_lot_numbers%ROWTYPE ,
88 p_mtlt_rowid IN ROWID
89 );
90
91
92 FUNCTION inv_rma_lot_info_exists(
93 x_msg_data OUT NOCOPY VARCHAR2 ,
94 x_msg_count OUT NOCOPY NUMBER ,
95 x_count_rma_lots OUT NOCOPY NUMBER ,
96 p_oe_order_header_id IN VARCHAR2 ,
97 p_oe_order_line_id IN VARCHAR2
98 )RETURN BOOLEAN ;
99
100
101
102 PROCEDURE Inv_Validate_rma_quantity(
103 x_allowed OUT NOCOPY VARCHAR2 ,
104 x_allowed_quantity OUT NOCOPY NUMBER ,
105 x_return_status OUT NOCOPY VARCHAR2 ,
106 x_msg_data OUT NOCOPY VARCHAR2 ,
107 x_msg_count OUT NOCOPY NUMBER ,
108 p_api_version IN NUMBER DEFAULT 1.0 ,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
110 p_item_id IN NUMBER ,
111 p_lot_number IN VARCHAR2 ,
112 p_oe_order_header_id IN NUMBER ,
113 p_oe_order_line_id IN NUMBER ,
114 p_rma_quantity IN NUMBER ,
115 p_trx_unit_of_measure IN VARCHAR2 ,
116 p_rti_id IN NUMBER ,
117 p_to_organization_id IN NUMBER ,
118 p_trx_quantity IN NUMBER
119 );
120
121
122 PROCEDURE Check_Item_Attributes(
123 x_return_status OUT NOCOPY VARCHAR2
124 , x_msg_count OUT NOCOPY NUMBER
125 , x_msg_data OUT NOCOPY VARCHAR2
126 , x_lot_cont OUT NOCOPY BOOLEAN
127 , x_child_lot_cont OUT NOCOPY BOOLEAN
128 , p_inventory_item_id IN NUMBER
129 , p_organization_id IN NUMBER
130 );
131
132
133
134
135 END INV_ROI_INTEGRATION_GRP;
|
|
|