1 PACKAGE CS_InstalledBase_GRP AS
2 /* $Header: csgibs.pls 120.1 2005/08/29 16:21:12 epajaril noship $ */
3
4 -- Private datatypes used only by this package
5
6 TYPE Split_Line_Rec_Type IS RECORD
7 (
8 split_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
9 quantity NUMBER DEFAULT FND_API.G_MISS_NUM
10 );
11
12 TYPE Split_Line_Tbl_Type is TABLE OF Split_Line_Rec_Type
13 INDEX BY BINARY_INTEGER;
14
15 -- End private datatypes
16
17
18 PROCEDURE Update_Inst_Details_Order_Line
19 (
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 p_quote_line_shipment_id IN NUMBER,
27 p_order_line_id IN NUMBER
28 );
29
30 --------------------------------------------------------------------------
31
32 -- Start of comments
33 -- API name : Split_Installation_Details
34 -- Type : Public
35 -- Function : This API is used to split Installation details records when the-- order line it belongs to is split.This API will be called by
36 -- the Process Order API only if the first Split Order Line has
37 -- the ordered quantity lower than the total quantity of the
38 -- Installation Details. If the first Split Order Line has the
39 -- ordered quantity greater or equal to the total quantity of the
40 -- Installation Details, OM will automatically attach all the
41 -- installation details records to the first split order line and
42 -- the rest of teh split lines will not have any installation
43 -- details.
44 -- Pre-reqs : None.
45 --
46 -- Standard IN Parameters:
47 -- p_api_version IN NUMBER Required
48 -- p_init_msg_list IN VARCHAR2 Optional
49 -- Default = FND_API.G_FALSE
50 --
51 -- Standard OUT Parameters:
52 -- x_return_status OUT VARCHAR2(1)
53 -- x_msg_count OUT NUMBER
54 -- x_msg_data OUT VARCHAR2(2000)
55 --
56 -- Split_Installation_Details IN Parameters:
57 -- p_split_line_tbl Split_Line_Tbl_Type Required.
58 -- p_split_line_tbl_count NUMBER
59
60 -- Split_Installation_Details OUT Parameters:
61 -- None
62 --
63 -- Version : Current version 1.0
64 -- Initial version 1.0
65 --
66 -- End of comments
67 --------------------------------------------------------------------------
68
69 PROCEDURE Split_Installation_Details
70 (
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_split_line_tbl IN Split_Line_Tbl_Type,
78 p_split_line_tbl_count IN NUMBER
79 );
80
81 END CS_InstalledBase_GRP;