1 PACKAGE OE_BULK_LINE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEBULINS.pls 120.1.12020000.1 2012/06/26 08:18:33 appldev ship $ */
3
4 ---------------------------------------------------------------------
5 -- PROCEDURE Load_Lines
6 --
7 -- Loads order lines in the batch from interface tables to
8 -- the record - p_line_rec
9 ---------------------------------------------------------------------
10
11 PROCEDURE Load_Lines
12 ( p_batch_id IN NUMBER
13 ,p_process_configurations IN VARCHAR2 DEFAULT 'N'
14 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
15 );
16
17 ---------------------------------------------------------------------
18 -- PROCEDURE Insert_Lines
19 --
20 -- BULK Inserts order lines into the OM tables from p_line_rec
21 ---------------------------------------------------------------------
22
23 PROCEDURE Insert_Lines
24 ( p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE
25 );
26
27 ---------------------------------------------------------------------
28 -- PROCEDURE Create_Line_Scredits
29 --
30 -- BULK Inserts line sales credits into the OM tables from
31 -- p_line_scredit_rec
32 ---------------------------------------------------------------------
33 PROCEDURE Create_Line_Scredits
34 (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
35 );
36
37 ---------------------------------------------------------------------
38 -- PROCEDURE Append_Included_Items
39 --
40 -- This procedure is called for each KIT line being processed.
41 -- It appends the exploded included item order lines for this kit
42 -- to the end of p_line_rec.
43 -- IN/IN OUT NOCOPY /* file.sql.39 change */ Parameters -
44 -- p_parent_index : index of the KIT line in p_line_rec
45 -- p_line_rec: order lines in this batch
46 -- p_header_index : index of the order header for the kit line in
47 -- p_header_rec
48 -- p_header_rec: order headers in this batch
49 -- OUT NOCOPY /* file.sql.39 change */ Parameters -
50 -- x_ii_count : number of included item lines for this KIT line
51 -- x_ii_start_index : starting index from where the included items
52 -- for this KIT line are appended in p_line_rec
53 -- x_ii_on_generic_hold : TRUE if any one included item for this
54 -- KIT is applicable for a generic hold
55 ---------------------------------------------------------------------
56
57 PROCEDURE Append_Included_Items
58 (p_parent_index IN NUMBER
59 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
60 ,p_header_index IN NUMBER
61 ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
62 ,x_ii_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63 ,x_ii_start_index OUT NOCOPY /* file.sql.39 change */ NUMBER
64 ,x_ii_on_generic_hold OUT NOCOPY /* file.sql.39 change */ BOOLEAN
65 );
66
67 END OE_BULK_LINE_UTIL;
[Home] [Help]