PACKAGE BODY: APPS.ZPB_REPOS

Source

1 package body ZPB_REPOS AS
2 /* $Header: ZPBVREPB.plb 120.0.12010.4 2006/08/03 12:07:22 appldev noship $ */
3 
4 procedure upgrade_zpb_root(p_bus_area_id varchar2)
5 is
6    system_path varchar2(5000);
7    new_root varchar2(5000);
8 begin
9   new_root := 'oracle/apps/zpb/BusArea'||p_bus_area_id||'/';
10 
11   zpb_log.write('zpb_repos.change_zpb_root',
12                  'Begin upgrade of repository related tables');
13 
14   zpb_log.write('zpb_repos.change_zpb_root',
15                  'Upgrading ZPB repos root to '||new_root);
16 
17   update ZPB_CYCLE_MODEL_DIMENSIONS
18   set QUERY_OBJECT_PATH = new_root||QUERY_OBJECT_PATH
19   where QUERY_OBJECT_PATH like 'ZPBSystem/%';
20 
21   zpb_log.write('zpb_repos.change_zpb_root',
22                  'Upgrade of ZPB_CYCLE_MODEL_DIMENSIONS complete');
23 
24   update ZPB_DC_OBJECTS
25   set target_obj_path = new_root||target_obj_path
26   where target_obj_path like 'ZPBSystem/%';
27 
28   zpb_log.write('zpb_repos.change_zpb_root',
29                  'Upgrade of ZPB_DC_OBJECTS complete');
30 
31   update ZPB_DC_OBJECTS
32   set dataentry_obj_path = new_root||dataentry_obj_path
33   where dataentry_obj_path like 'ZPBSystem/%';
34 
35   zpb_log.write('zpb_repos.change_zpb_root',
36                  'Upgrade of ZPB_DC_OBJECTS complete');
37 
38   update zpb_status_sql
39   set QUERY_PATH = new_root||QUERY_PATH
40   where QUERY_PATH like 'ZPBSystem/%';
41 
42   zpb_log.write('zpb_repos.change_zpb_root',
43                  'Upgrade of zpb_status_sql complete');
44 
45   update ZPB_DEPENDENT_OBJECTS
46   set document_name = new_root||document_name
47   where document_name like '%/%';
48 
49   zpb_log.write('zpb_repos.change_zpb_root',
50                  'Upgrade of ZPB_DEPENDENT_OBJECTS complete');
51 
52   update ZPB_DEPENDENT_OBJECTS
53   set saved_selection_name = new_root||saved_selection_name
54   where saved_selection_name like '%/%';
55 
56   zpb_log.write('zpb_repos.change_zpb_root',
57                  'Upgrade of ZPB_DEPENDENT_OBJECTS complete');
58 
59   update ZPB_WRITEBACK_TRANSACTION
60   set QDR = new_root||QDR
61   where QDR like 'ZPBSystem/%';
62 
63   zpb_log.write('zpb_repos.change_zpb_root',
64                  'Upgrade of ZPB_WRITEBACK_TRANSACTION complete');
65 
66   update zpb_line_dimensionality
67   set sum_selection_path = new_root||sum_selection_path
68   where sum_selection_path like 'ZPBSystem/%';
69 
70   zpb_log.write('zpb_repos.change_zpb_root',
71                  'Upgrade of zpb_line_dimensionality complete');
72 
73   update zpb_task_parameters
74   set VALUE = new_root||VALUE
75   where value like 'ZPBSystem/%';
76 
77   zpb_log.write('zpb_repos.change_zpb_root',
78                  'Upgrade of zpb_task_parameters complete');
79 
80   update ZPB_SOLVE_OUTPUT_SELECTIONS
81   set selection_path = new_root||selection_path
82   where selection_path like 'ZPBSystem/%';
83 
84   zpb_log.write('zpb_repos.change_zpb_root',
85                  'Upgrade of ZPB_SOLVE_OUTPUT_SELECTIONS complete');
86 
87   update ZPB_SOLVE_INPUT_SELECTIONS
88   set selection_path = new_root||selection_path
89   where selection_path like 'ZPBSystem/%';
90 
91   zpb_log.write('zpb_repos.change_zpb_root',
92                  'Upgrade of ZPB_SOLVE_INPUT_SELECTIONS complete');
93 
94 
95 
96   zpb_log.write('zpb_repos.change_zpb_root',
97                  'Upgrade of Repository-related tables complete');
98 
99 
100 end upgrade_zpb_root;
101 
102 END;
103