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_SOLVE dependencies on ZPB_DATA_INITIALIZATION_DEFS

Line 374: PROCEDURE deleteInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,

370: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
371: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_to_member;
372: END removeCalcObjectInfo;
373:
374: PROCEDURE deleteInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
375: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
376: IS
377: BEGIN
378: DELETE ZPB_DATA_INITIALIZATION_DEFS

Line 375: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)

371: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_to_member;
372: END removeCalcObjectInfo;
373:
374: PROCEDURE deleteInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
375: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
376: IS
377: BEGIN
378: DELETE ZPB_DATA_INITIALIZATION_DEFS
379: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_to_member;

Line 378: DELETE ZPB_DATA_INITIALIZATION_DEFS

374: PROCEDURE deleteInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
375: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
376: IS
377: BEGIN
378: DELETE ZPB_DATA_INITIALIZATION_DEFS
379: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_to_member;
380:
381:
382: DELETE ZPB_COPY_DIM_MEMBERS

Line 387: PROCEDURE copyInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,

383: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND LINE_MEMBER_ID = p_to_member;
384: END deleteInializedInputSettings;
385:
386:
387: PROCEDURE copyInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
388: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE,
389: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
390: IS
391:

Line 388: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE,

384: END deleteInializedInputSettings;
385:
386:
387: PROCEDURE copyInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
388: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE,
389: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
390: IS
391:
392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;

Line 389: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)

385:
386:
387: PROCEDURE copyInializedInputSettings(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
388: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE,
389: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
390: IS
391:
392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;
393: l_target_query_name ZPB_DATA_INITIALIZATION_DEFS.TARGET_QUERY_NAME%TYPE;

Line 392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;

388: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE,
389: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
390: IS
391:
392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;
393: l_target_query_name ZPB_DATA_INITIALIZATION_DEFS.TARGET_QUERY_NAME%TYPE;
394:
395: CURSOR src_trg_qry_names_cur(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
396: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE) IS

Line 393: l_target_query_name ZPB_DATA_INITIALIZATION_DEFS.TARGET_QUERY_NAME%TYPE;

389: p_to_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE)
390: IS
391:
392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;
393: l_target_query_name ZPB_DATA_INITIALIZATION_DEFS.TARGET_QUERY_NAME%TYPE;
394:
395: CURSOR src_trg_qry_names_cur(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
396: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE) IS
397: SELECT SOURCE_QUERY_NAME,TARGET_QUERY_NAME

Line 395: CURSOR src_trg_qry_names_cur(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,

391:
392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;
393: l_target_query_name ZPB_DATA_INITIALIZATION_DEFS.TARGET_QUERY_NAME%TYPE;
394:
395: CURSOR src_trg_qry_names_cur(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
396: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE) IS
397: SELECT SOURCE_QUERY_NAME,TARGET_QUERY_NAME
398: FROM ZPB_DATA_INITIALIZATION_DEFS
399: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;

Line 396: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE) IS

392: l_source_query_name ZPB_DATA_INITIALIZATION_DEFS.SOURCE_QUERY_NAME%TYPE;
393: l_target_query_name ZPB_DATA_INITIALIZATION_DEFS.TARGET_QUERY_NAME%TYPE;
394:
395: CURSOR src_trg_qry_names_cur(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
396: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE) IS
397: SELECT SOURCE_QUERY_NAME,TARGET_QUERY_NAME
398: FROM ZPB_DATA_INITIALIZATION_DEFS
399: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
400:

Line 398: FROM ZPB_DATA_INITIALIZATION_DEFS

394:
395: CURSOR src_trg_qry_names_cur(p_ac_id IN ZPB_DATA_INITIALIZATION_DEFS.ANALYSIS_CYCLE_ID%TYPE,
396: p_from_member IN ZPB_DATA_INITIALIZATION_DEFS.MEMBER%TYPE) IS
397: SELECT SOURCE_QUERY_NAME,TARGET_QUERY_NAME
398: FROM ZPB_DATA_INITIALIZATION_DEFS
399: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
400:
401: BEGIN
402: /* Bug#5092815, Commented for because we copy the initialize settings

Line 417: --INSERT into ZPB_DATA_INITIALIZATION_DEFS table.

413: l_target_query_name := 'CD_TARGET_'||p_to_member;
414: END IF;
415: */
416:
417: --INSERT into ZPB_DATA_INITIALIZATION_DEFS table.
418: INSERT INTO ZPB_DATA_INITIALIZATION_DEFS
419: (ANALYSIS_CYCLE_ID,
420: MEMBER,
421: SOURCE_VIEW,

Line 418: INSERT INTO ZPB_DATA_INITIALIZATION_DEFS

414: END IF;
415: */
416:
417: --INSERT into ZPB_DATA_INITIALIZATION_DEFS table.
418: INSERT INTO ZPB_DATA_INITIALIZATION_DEFS
419: (ANALYSIS_CYCLE_ID,
420: MEMBER,
421: SOURCE_VIEW,
422: LAG_TIME_PERIODS,

Line 451: FROM ZPB_DATA_INITIALIZATION_DEFS

447: fnd_global.USER_ID,
448: SYSDATE,
449: fnd_global.LOGIN_ID,
450: PROPAGATED_FLAG
451: FROM ZPB_DATA_INITIALIZATION_DEFS
452: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND MEMBER = p_from_member;
453:
454: INSERT INTO zpb_copy_dim_members
455: (DIM,

Line 585: UPDATE ZPB_DATA_INITIALIZATION_DEFS

581: --Bug#5092815, mark the source line as propagated, so that
582: --the same settings can be copied to target line
583: IF fromsource=INIT_WS_INPUT_SOURCE THEN
584:
585: UPDATE ZPB_DATA_INITIALIZATION_DEFS
586: SET propagated_flag='Y'
587: WHERE ANALYSIS_CYCLE_ID=p_ac_id
588: AND MEMBER=p_from_member;
589:

Line 1166: from zpb_data_initialization_defs

1162: IF p_src_type <> INIT_WS_INPUT_SOURCE THEN
1163: -- for bug 5001437
1164: delete from zpb_status_sql
1165: where query_path in (select query_path||'/'||target_query_name
1166: from zpb_data_initialization_defs
1167: where analysis_cycle_id = p_ac_id
1168: and member = p_line_member);
1169:
1170: delete from zpb_status_sql

Line 1172: from zpb_data_initialization_defs

1168: and member = p_line_member);
1169:
1170: delete from zpb_status_sql
1171: where query_path in (select query_path||'/'||source_query_name
1172: from zpb_data_initialization_defs
1173: where analysis_cycle_id = p_ac_id
1174: and member = p_line_member);
1175:
1176: delete from ZPB_DATA_INITIALIZATION_DEFS where analysis_cycle_id = p_ac_id and member = p_line_member;

Line 1176: delete from ZPB_DATA_INITIALIZATION_DEFS where analysis_cycle_id = p_ac_id and member = p_line_member;

1172: from zpb_data_initialization_defs
1173: where analysis_cycle_id = p_ac_id
1174: and member = p_line_member);
1175:
1176: delete from ZPB_DATA_INITIALIZATION_DEFS where analysis_cycle_id = p_ac_id and member = p_line_member;
1177: delete from ZPB_COPY_DIM_MEMBERS where analysis_cycle_id = p_ac_id and line_member_id = p_line_member;
1178: END IF;
1179: IF p_src_type <> CALCULATED_SOURCE then
1180: removeCalcObjectInfo(p_ac_id,p_line_member);