[Home] [Help]
PACKAGE: APPS.ASO_FIND_HIERARCHY_PVT
Source
1 Package ASO_Find_hierarchy_pvt AUTHID CURRENT_USER AS
2 /* $Header: asovqres.pls 120.1 2005/06/29 12:44:04 appldev ship $ */
3
4 TYPE hier_rec_type IS RECORD (
5 depth NUMBER := FND_API.G_MISS_NUM ,
6 line_num NUMBER := FND_API.G_MISS_NUM ,
7 parent_line_id Number := FND_API.G_MISS_NUM ,
8 quote_line_id NUMBER := FND_API.G_MISS_NUM ,
9 inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
10 inventory_item VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
11 description varchar2(2000) := FND_API.G_MISS_CHAR ,
12 item_revision VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
13 uom_code VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
14 -- inventory_item VARCHAR2(40) := FND_API.G_MISS_CHAR ,
15 -- description varchar2(240) := FND_API.G_MISS_CHAR ,
16 -- item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR ,
17 -- uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
18 quantity NUMBER := FND_API.G_MISS_NUM ,
19 amount NUMBER := FND_API.G_MISS_NUM ,
20 adjusted_amount NUMBER := FND_API.G_MISS_NUM ,
21 qty_factor NUMBER := FND_API.G_MISS_NUM ,
22 included_flag VARCHAR2(2000) := 'N' ) ;
23 -- included_flag VARCHAR2(1) := 'N' ) ;
24
25
26 Type hier_tbl_type IS TABLE OF hier_rec_type
27 INDEX BY BINARY_INTEGER;
28
29 G_qte_lines_tbl hier_tbl_type ;
30 G_hier_tbl hier_tbl_type ;
31 G_Miss_tbl hier_tbl_type ;
32
33 TYPE relation_rec_type IS RECORD (
34 quote_line_id NUMBER := FND_API.G_MISS_NUM ,
35 related_quote_line_id NUMBER := FND_API.G_MISS_NUM );
36
37 TYPE relation_tbl_type IS TABLE OF relation_rec_type
38 INDEX BY BINARY_INTEGER ;
39
40 G_relation_tbl relation_tbl_type ;
41 G_Miss_reln_tbl relation_tbl_type ;
42
43 PROCEDURE Populate_hier( p_quote_header_id IN NUMBER ,
44 x_hier_tbl OUT NOCOPY /* file.sql.39 change */ hier_tbl_type ,
45 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
46 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
47 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
48 End ASO_FInd_Hierarchy_pvt ;