[Home] [Help]
PACKAGE: APPS.OWB_TREE
Source
1 PACKAGE OWB_TREE AS
2 /* $Header: MRPOSTRS.pls 120.0 2005/05/25 03:50:29 appldev noship $ */
3
4
5 LABEL_DELIM CONSTANT VARCHAR2(1) := '$';
6
7 --MFG_LOOKUPS
8
9 ORGANIZATIONS CONSTANT NUMBER := 2;
10 CATEGORIES CONSTANT NUMBER := 12;
11 EXCEPTIONS CONSTANT NUMBER := 18;
12 SALES_ORDERS CONSTANT NUMBER := 30;
13 SHIP_SETS CONSTANT NUMBER := 31;
14 ARRIVAL_SETS CONSTANT NUMBER := 32;
15 SHORTAGE CONSTANT NUMBER := 33;
16 LATER_THAN_OLD_SCHEDULE_DATE CONSTANT NUMBER := 34;
17 LATER_THAN_PROMISE_DATE CONSTANT NUMBER := 35;
18 LATER_THAN_REQUEST_DATE CONSTANT NUMBER := 36;
19 INSUFFICIENT_MARGIN CONSTANT NUMBER := 37;
20 MODIFIED_SOURCE CONSTANT NUMBER := 39;
21
22 SALES_ORDERS_N CONSTANT NUMBER := 40;
23 CATEGORY_SETS CONSTANT NUMBER := 41; -- not used
24 CATEGORY_SETS_N CONSTANT NUMBER := 42; -- not used
25 PRODUCT_FAMILIES_N CONSTANT NUMBER := 43;
26 ITEMS CONSTANT NUMBER := 4;
27 SHIP_SETS_N CONSTANT NUMBER := 45;
28 ARRIVAL_SETS_N CONSTANT NUMBER := 46;
29 CATEGORIES_N CONSTANT NUMBER := 47;
30 PRODUCT_FAMILIES CONSTANT NUMBER := 48;
31 ORGANIZATIONS_N CONSTANT NUMBER := 49;
32 INDEP_LINES CONSTANT NUMBER := 50;
33 SOURCES CONSTANT NUMBER := 51;
34 SOURCES_N CONSTANT NUMBER := 52;
35 ITEMS_N CONSTANT NUMBER := 53;
36 ERRORS CONSTANT NUMBER := 54;
37
38 -- I don't need Option classes in the text
39
40 EXCP_TREE CONSTANT NUMBER := 1;
41 ITEMS_TREE CONSTANT NUMBER := 2;
42 ORDERS_TREE CONSTANT NUMBER := 3;
43
44 NODES_IN_EXCP_TREE CONSTANT NUMBER := 8;
45 NODES_IN_ORDERS_TREE CONSTANT NUMBER := 5;
46 NODES_IN_ITEMS_TREE CONSTANT NUMBER := 7;
47
48 ICON_FOLDER CONSTANT VARCHAR2(10) := 'aftreecl';
49 --ICON_SALES_ORDER CONSTANT VARCHAR2(10) := 'MRPSAORD';
50 ICON_DEMAND CONSTANT VARCHAR2(10) := 'afplan';
51 ICON_MAKE_AT CONSTANT VARCHAR2(10) := 'mscmake1';
52 ICON_TRANSFER CONSTANT VARCHAR2(10) := 'msctxfer';
53 ICON_BUY CONSTANT VARCHAR2(10) := 'mscsupps';
54 ICON_SUP_CAP CONSTANT VARCHAR2(10) := 'mscsuppg';
55 ICON_SUP_CAP_CRIT CONSTANT VARCHAR2(10) := 'mscsuppr';
56 --ICON_MATERIAL_DEM CONSTANT VARCHAR2(10) := 'mscmatls';
57 ICON_MATERIAL CONSTANT VARCHAR2(10) := 'mscflagg'; -- 'mscmatlg';
58 ICON_MATERIAL_CRIT CONSTANT VARCHAR2(10) := 'mscsupc'; -- 'mscmatlr';
59 --ICON_RESOURCE_DEM CONSTANT VARCHAR2(10) := 'mschamrs';
60 ICON_RESOURCE_CAP CONSTANT VARCHAR2(10) := 'mschamrg';
61 ICON_RESOURCE_CAP_CRIT CONSTANT VARCHAR2(10) := 'mschamrr';
62 ICON_NO_PEGGING CONSTANT VARCHAR2(10) := 'mscnopeg';
63
64 LOOKUPS_COUNT CONSTANT NUMBER := 27;
65
66 TYPE number_arr IS TABLE OF number;
67 TYPE char80_arr IS TABLE of VARCHAR2(80);
68 TYPE char100_arr IS TABLE of VARCHAR2(100);
69 TYPE char240_arr IS TABLE of VARCHAR2(240);
70 TYPE char_500_arr IS TABLE of VARCHAR2(500);
71
72 -- same as lookups_count
73 TYPE char80_var_arr IS varray(27) OF VARCHAR2(80);
74
75 lookups char80_var_arr;
76
77 TYPE nodeRec IS RECORD (
78 tree_type number_arr := number_arr(),
79 parent_node_type number_arr := number_arr(),
80 state number_arr := number_arr(),
81 depth number_arr := number_arr(),
82 label char240_arr := char240_arr(),
83 icon char80_arr := char80_arr(),
84 data char80_arr := char80_arr()
85 );
86
87 TYPE nodeData IS RECORD (
88 state number_arr := number_arr(),
89 depth number_arr := number_arr(),
90 label char240_arr := char240_arr(),
91 -- many things are concatenated in the sourcing tree.
92 icon char80_arr := char80_arr(),
93 data char80_arr := char80_arr()
94 );
95
96 PROCEDURE getstructure ( p_session_id NUMBER,
97 p_mode NUMBER,
98 p_nodes OUT NoCopy noderec);
99 FUNCTION get_excp_count( p_session_id NUMBER,
100 col_num NUMBER) RETURN INTEGER ;
101 FUNCTION get_cust_hier_string
102 (dmd_class in VARCHAR2) return VARCHAR2;
103
104 PROCEDURE get_Sourcing_Nodes(p_end_pegging_id NUMBER,
105 p_session_id NUMBER,
106 p_nodes OUT NoCopy NodeData,
107 p_expand_level NUMBER,
108 p_current_node_data NUMBER,
109 p_checkbox BOOLEAN DEFAULT FALSE);
110 PROCEDURE get_lookups;
111
112 record_count NUMBER;
113
114 NULL_VALUE CONSTANT NUMBER := -1;
115
116 COLLAPSED CONSTANT NUMBER := -1;
117 EXPANDED CONSTANT NUMBER := 1;
118 LEAF_NODE CONSTANT NUMBER := 0;
119 next_level CONSTANT NUMBER := 1;
120 all_levels CONSTANT NUMBER := 9999999999;
121 constraint_level CONSTANT NUMBER := 2;
122 END OWB_TREE;