[Home] [Help]
39:
40: l_zpb_pref:= zpb_aw.get_schema;
41:
42: select data_aw, annotation_aw into l_shar_aw, l_annot_aw
43: from zpb_business_areas
44: where business_area_id=p_business_area_id;
45:
46: -- attempt to grant priviliges to business area shared data and code AWs to user.
47: -- This will only succeed if the apps schema has been granted the privilege to grant
63: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_log for zpb_log';
64: execute immediate 'grant execute on zpb_util_pvt to ' || p_schema_name;
65: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_util_pvt for zpb_util_pvt';
66: -- Create necessary synonyms and grant privileges to execute SQL initialization procedure
67: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_business_areas for zpb_business_areas';
68: execute immediate 'grant select on ZPB_BUSINESS_AREAS to ' || p_schema_name;
69: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_oracle_userid for fnd_oracle_userid';
70: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_application for fnd_application';
71: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_product_installations for fnd_product_installations';
64: execute immediate 'grant execute on zpb_util_pvt to ' || p_schema_name;
65: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_util_pvt for zpb_util_pvt';
66: -- Create necessary synonyms and grant privileges to execute SQL initialization procedure
67: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_business_areas for zpb_business_areas';
68: execute immediate 'grant select on ZPB_BUSINESS_AREAS to ' || p_schema_name;
69: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_oracle_userid for fnd_oracle_userid';
70: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_application for fnd_application';
71: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_product_installations for fnd_product_installations';
72: execute immediate 'grant select on fnd_oracle_userid to ' || p_schema_name;
80: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_analysis_cycle_tasks for zpb_analysis_cycle_tasks';
81: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_analysis_cycle_instances for zpb_analysis_cycle_instances';
82: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_analysis_cycles for zpb_analysis_cycles';
83: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_solve_output_selections for zpb_solve_output_selections';
84: execute immediate 'create or replace synonym ' || p_schema_name || '.zpb_business_areas_vl for zpb_business_areas_vl';
85: execute immediate 'create or replace synonym ' || p_schema_name || '.fnd_lookup_values_vl for fnd_lookup_values_vl';
86: execute immediate 'grant select on zpb_ac_param_values to ' || p_schema_name;
87: execute immediate 'grant select on zpb_cycle_datasets to ' || p_schema_name;
88: execute immediate 'grant select on zpb_cycle_currencies to ' || p_schema_name;
90: execute immediate 'grant select on zpb_analysis_cycle_tasks to ' || p_schema_name;
91: execute immediate 'grant select on zpb_analysis_cycle_instances to ' || p_schema_name;
92: execute immediate 'grant select on zpb_analysis_cycles to ' || p_schema_name;
93: execute immediate 'grant select on zpb_solve_output_selections to ' || p_schema_name;
94: execute immediate 'grant select on zpb_business_areas_vl to ' || p_schema_name;
95: execute immediate 'grant select on fnd_lookup_values_vl to ' || p_schema_name;
96:
97: -- Grant select priviliges on all of the pre-defined open-sql views (metadata open-sql views)
98: execute immediate 'grant select on ZPB_OS_ATTRIBUTES_V to ' || p_schema_name;