DBA Data[Home] [Help]

APPS.ASO_FIND_HIERARCHY_PVT dependencies on FND_API

Line 5: depth NUMBER := FND_API.G_MISS_NUM ,

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 ,

Line 6: line_num NUMBER := FND_API.G_MISS_NUM ,

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 ,

Line 7: parent_line_id Number := FND_API.G_MISS_NUM ,

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 ,

Line 8: quote_line_id NUMBER := FND_API.G_MISS_NUM ,

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 ,

Line 9: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,

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 ,

Line 10: inventory_item VARCHAR2(2000) := FND_API.G_MISS_CHAR ,

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 ,

Line 11: description varchar2(2000) := FND_API.G_MISS_CHAR ,

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 ,

Line 12: item_revision VARCHAR2(2000) := FND_API.G_MISS_CHAR ,

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 ,

Line 13: uom_code VARCHAR2(2000) := FND_API.G_MISS_CHAR ,

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 ,

Line 14: -- inventory_item VARCHAR2(40) := FND_API.G_MISS_CHAR ,

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 ,

Line 15: -- description varchar2(240) := 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 ,

Line 16: -- item_revision VARCHAR2(3) := 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 ,

Line 17: -- uom_code VARCHAR2(3) := 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 ,

Line 18: quantity NUMBER := FND_API.G_MISS_NUM ,

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' ) ;

Line 19: amount NUMBER := FND_API.G_MISS_NUM ,

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' ) ;

Line 20: adjusted_amount NUMBER := FND_API.G_MISS_NUM ,

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:

Line 21: qty_factor NUMBER := FND_API.G_MISS_NUM ,

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:

Line 34: quote_line_id NUMBER := FND_API.G_MISS_NUM ,

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 ;

Line 35: related_quote_line_id NUMBER := FND_API.G_MISS_NUM );

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: