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_AC_OPS dependencies on ZPB_CYCLE_MODEL_DIMENSIONS

Line 293: INSERT INTO zpb_cycle_model_dimensions

289: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
290: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
291: IS
292: BEGIN
293: INSERT INTO zpb_cycle_model_dimensions
294: (ANALYSIS_CYCLE_ID,
295: DIMENSION_NAME,
296: QUERY_OBJECT_NAME,
297: QUERY_OBJECT_PATH,

Line 322: FROM zpb_cycle_model_dimensions

318: SYSDATE,
319: fnd_global.USER_ID,
320: SYSDATE,
321: fnd_global.USER_ID
322: FROM zpb_cycle_model_dimensions
323: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
324:
325: END copy_cycle_model_dim_recs;
326:

Line 1165: DELETE FROM zpb_cycle_model_dimensions

1161:
1162: DELETE FROM zpb_cycle_comments
1163: WHERE analysis_cycle_id = ac_id_in;
1164:
1165: DELETE FROM zpb_cycle_model_dimensions
1166: WHERE analysis_cycle_id = ac_id_in;
1167:
1168: DELETE FROM zpb_ac_param_values
1169: WHERE analysis_cycle_id = ac_id_in;

Line 2551: md_rec zpb_cycle_model_dimensions%rowtype;

2547: procedure create_cycle_model_dimensions( p_ac_id in number,
2548: dimension_list in varchar2,
2549: p_apps_user_id in number) AS
2550:
2551: md_rec zpb_cycle_model_dimensions%rowtype;
2552: dimension varchar2(100);
2553: i integer;
2554: j integer;
2555:

Line 2574: INSERT INTO zpb_cycle_model_dimensions(ANALYSIS_CYCLE_ID,

2570: dimension := substr(dimension_list, i,j - i);
2571: i := j + 1;
2572: end if;
2573: md_rec.dimension_name := dimension;
2574: INSERT INTO zpb_cycle_model_dimensions(ANALYSIS_CYCLE_ID,
2575: DIMENSION_NAME,
2576: QUERY_OBJECT_NAME,
2577: QUERY_OBJECT_PATH,
2578: LAST_UPDATE_LOGIN,

Line 3176: update zpb_cycle_model_dimensions set last_updated_by = p_apps_user_id,

3172:
3173: copy_ac_table_rec(p_analysis_cycle_id, new_ac_id);
3174: copy_cycle_model_dim_recs(p_analysis_cycle_id, new_ac_id);
3175:
3176: update zpb_cycle_model_dimensions set last_updated_by = p_apps_user_id,
3177: created_by = p_apps_user_id,
3178: last_update_login = p_apps_user_id
3179: where analysis_cycle_id = new_ac_id;
3180: