eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_REPOS dependencies on ZPB_REPOS

Line 1: package body ZPB_REPOS AS

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

Line 11: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 14: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 15: 'Upgrading ZPB repos root to '||new_root);

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/%';

Line 21: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 28: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 35: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 42: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 49: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 56: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 63: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 70: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 77: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 84: zpb_log.write('zpb_repos.change_zpb_root',

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

Line 91: zpb_log.write('zpb_repos.change_zpb_root',

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:

Line 96: 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;