1 PACKAGE eam_workbench_tree AS
2 /* $Header: EAMWBTRS.pls 120.2 2006/03/27 05:18:37 kmurthy noship $ */
3
4 /**
5 * Given the search criteria, this function finds out all the asset numbers
6 * and insert those into the temp table under a group id which is returned.
7 */
8 function find_all_asset_numbers(p_org_id number,
9 p_instance_id number,
10 p_location_id number,
11 p_category_id number,
12 p_owning_dept_id number,
13 p_asset_group_id number,
14 p_asset_number varchar2,
15 p_transferred_asset varchar2,
16 p_set_name_id number
17 ) return number;
18
19
20 /**
21 * Given the search criteria, this function finds out all the applicable
22 * asset numbers and builds the hierarchy trees. And after that, it dumps
23 * all the searched asset numbers into the temp table under a group id which
24 * is returned to the user.
25 */
26 function construct_hierarchy_forest(p_org_id number,
27 p_instance_id number,
28 p_location_id number,
29 p_category_id number,
30 p_owning_dept_id number,
31 p_asset_group_id number,
32 p_asset_number varchar2,
33 p_set_name_id number
34 ) return number;
35
36
37 /**
38 * Procedure construct_hierarchy_forest must be called before this function can
39 * be called. Otherwise, it will cause unexpected behavior.
40 * Given the asset number and asset group id, this function will copy the
41 * subtree of the given asset number to the temp table. It returns the group_id
42 * back so the user can reference it. It returns -1 if the given asset number
43 * is not found.
44 */
45 function copy_subtree_to_temp_table(p_asset_group_id number,
46 p_asset_number varchar2) return number;
47
48 /**
49 * This procedure releases the resource taken explicity.
50 */
51 procedure clear_forest;
52
53 /** added by sraval to include rebuildables in activity workbench
54 */
55 function find_all_asset_numbers(p_org_id number,
56 p_instance_id number,
57 p_location_id number,
58 p_category_id number,
59 p_owning_dept_id number,
60 p_asset_group_id number,
61 p_asset_number varchar2,
62 p_include_rebuildable varchar2,
63 p_transferred_asset varchar2,
64 p_set_name_id number ) return number;
65
66 /** added by sraval to include rebuildables in activity workbench
67 */
68 function construct_hierarchy_forest(p_org_id number,
69 p_instance_id number,
70 p_location_id number,
71 p_category_id number,
72 p_owning_dept_id number,
73 p_asset_group_id number,
74 p_asset_number varchar2,
75 p_include_rebuildable varchar2,
76 p_set_name_id number ) return number;
77
78 /* This procedure is used to delete the session data from eam_asset_explosion_temp
79 table. This is added for the bug #2688078
80 */
81 procedure clear_eam_asset(p_group_id IN NUMBER);
82
83 /* Code Added for bug 3982343 Start */
84 TYPE global_group_ids IS
85 TABLE OF NUMBER
86 INDEX BY BINARY_INTEGER;
87 /* This procedure is used to delete session data from
88 * eam_asset_explosion_temp table, accepting a plsql collection of group_ids to
89 * be deleted.
90 */
91 procedure clear_eam_asset(p_global_group_ids IN global_group_ids);
92 /* Code Added for bug 3982343 End */
93
94
95 END eam_workbench_tree;