1 PACKAGE inv_mwb_tree1 AS
2 /* $Header: INVMWTRS.pls 120.0.12000000.2 2007/10/16 11:52:48 athammin ship $ */
3
4
5 PROCEDURE add_document_numbers(
6 x_node_value IN OUT NOCOPY NUMBER
7 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
8 ,x_tbl_index IN OUT NOCOPY NUMBER
9 );
10
11 PROCEDURE add_orgs(
12 x_node_value IN OUT NOCOPY NUMBER
13 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
14 ,x_tbl_index IN OUT NOCOPY NUMBER
15 );
16
17 PROCEDURE add_statuses(
18 x_node_value IN OUT NOCOPY NUMBER
19 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
20 ,x_tbl_index IN OUT NOCOPY NUMBER
21 );
22
23 PROCEDURE add_subs(
24 x_node_value IN OUT NOCOPY NUMBER
25 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
26 ,x_tbl_index IN OUT NOCOPY NUMBER
27 );
28
29 PROCEDURE add_locs(
30 x_node_value IN OUT NOCOPY NUMBER
31 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
32 ,x_tbl_index IN OUT NOCOPY NUMBER
33 );
34
35 PROCEDURE add_cgs(
36 x_node_value IN OUT NOCOPY NUMBER
37 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
38 ,x_tbl_index IN OUT NOCOPY NUMBER
39 );
40
41 PROCEDURE add_lpns(
42 x_node_value IN OUT NOCOPY NUMBER
43 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
44 ,x_tbl_index IN OUT NOCOPY NUMBER
45 );
46
47 PROCEDURE add_items(
48 x_node_value IN OUT NOCOPY NUMBER
49 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
50 ,x_tbl_index IN OUT NOCOPY NUMBER
51 );
52
53 PROCEDURE add_revs(
54 x_node_value IN OUT NOCOPY NUMBER
55 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
56 ,x_tbl_index IN OUT NOCOPY NUMBER
57 );
58
59 PROCEDURE add_lots(
60 x_node_value IN OUT NOCOPY NUMBER
61 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
62 ,x_tbl_index IN OUT NOCOPY NUMBER
63 );
64
65 PROCEDURE add_serials(
66 x_node_value IN OUT NOCOPY NUMBER
67 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
68 ,x_tbl_index IN OUT NOCOPY NUMBER
69 );
70
71 PROCEDURE add_grades (
72 x_node_value IN OUT NOCOPY NUMBER
73 ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
74 ,x_tbl_index IN OUT NOCOPY NUMBER
75 );
76
77 PROCEDURE get_mln_attributes_structure(
78 x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
79 ,x_attributes_count OUT NOCOPY NUMBER
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY NUMBER
83 );
84
85 PROCEDURE get_mln_attributes(
86 x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
87 ,x_attribute_prompts IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
88 ,x_attributes_count OUT NOCOPY NUMBER
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY NUMBER
92 );
93
94 PROCEDURE get_msn_attributes_structure(
95 x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
96 ,x_attributes_count OUT NOCOPY NUMBER
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY NUMBER
100 );
101
102 PROCEDURE get_msn_attributes(
103 x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
104 ,x_attribute_prompts IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
105 ,x_attributes_count OUT NOCOPY NUMBER
106 ,x_return_status OUT NOCOPY VARCHAR2
107 ,x_msg_count OUT NOCOPY NUMBER
108 ,x_msg_data OUT NOCOPY NUMBER
109 );
110
111 FUNCTION GET_ITEM( -- Bug 6350236 Starting
112 P_ITEM_ID IN NUMBER DEFAULT NULL
113 ,P_ORG_ID IN NUMBER DEFAULT NULL
114 ) RETURN VARCHAR2; -- Bug 6350236 Ending
115
116 END inv_mwb_tree1;