DBA Data[Home] [Help]

APPS.ZPB_SOLVE dependencies on ZPB_COPY_DIM_MEMBERS

Line 382: DELETE ZPB_COPY_DIM_MEMBERS

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
383: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND LINE_MEMBER_ID = p_to_member;
384: END deleteInializedInputSettings;
385:
386:

Line 454: INSERT INTO zpb_copy_dim_members

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,
456: ANALYSIS_CYCLE_ID,
457: SOURCE_NUM_MEMBERS,
458: TARGET_NUM_MEMBERS,

Line 477: FROM zpb_copy_dim_members

473: SYSDATE,
474: fnd_global.LOGIN_ID,
475: SAME_SELECTION,
476: p_to_member
477: FROM zpb_copy_dim_members
478: WHERE ANALYSIS_CYCLE_ID = p_ac_id AND LINE_MEMBER_ID = p_from_member;
479:
480: END copyInializedInputSettings;
481:

Line 1177: delete from ZPB_COPY_DIM_MEMBERS where analysis_cycle_id = p_ac_id and line_member_id = p_line_member;

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);
1181: END IF;