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_ACVAL_PVT dependencies on ZPB_ANALYSIS_CYCLES

Line 10: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

6:
7: -------------------------------------------------------------------------------
8:
9: PROCEDURE validate_currentrun_helper (
10: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
11: x_changeCurrentRun OUT NOCOPY VARCHAR2)
12:
13: IS
14:

Line 21: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;

17:
18: TYPE lineMemberTyp IS REF CURSOR;
19: pub_line_member lineMemberTyp;
20: edt_line_member lineMemberTyp;
21: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
22: l_edt_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
23: l_edt_query_path zpb_cycle_model_dimensions.query_object_path%type;
24: l_pub_query_path zpb_cycle_model_dimensions.query_object_path%type;
25: l_edt_status_sql zpb_status_sql.status_sql%type;

Line 22: l_edt_ac_id zpb_analysis_cycles.analysis_cycle_id%type;

18: TYPE lineMemberTyp IS REF CURSOR;
19: pub_line_member lineMemberTyp;
20: edt_line_member lineMemberTyp;
21: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
22: l_edt_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
23: l_edt_query_path zpb_cycle_model_dimensions.query_object_path%type;
24: l_pub_query_path zpb_cycle_model_dimensions.query_object_path%type;
25: l_edt_status_sql zpb_status_sql.status_sql%type;
26: l_pub_status_sql zpb_status_sql.status_sql%type;

Line 494: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

490: */
491: END validate_currentrun_helper;
492:
493: PROCEDURE validate_currentrun (
494: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
495: x_changeCurrentRun OUT NOCOPY VARCHAR2)
496:
497: IS
498:

Line 638: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type) IS

634: -- this procedure initializes the SOLVE objects so that they
635: -- can be used by multiple validation rules later without having to reset
636: -- the solve objects for every rule.
637: procedure initialize_solve_object(
638: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type) IS
639:
640: l_api_name CONSTANT VARCHAR2(50) := 'initialize_solve_object';
641: l_dataAw varchar2(100);
642: return_status varchar2(4000);

Line 692: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

688: -- 2: Solve has less line members than model
689: -- 3: Both Solve and model have line members that dont exist in the other
690: -- 4: Cycle was not completely defined yet. so no validation was performed
691: PROCEDURE val_solve_eq_model(
692: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
693: x_comparision OUT NOCOPY VARCHAR2) IS
694:
695: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_eq_model';
696: l_task_id zpb_analysis_cycle_tasks.task_id%type;

Line 776: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

772: -- line members of Solve
773: -- 'N': The union of Line Members of ALL Load Data Tasks is different from the
774: -- line members of Solve
775: procedure val_solve_eq_data_load(
776: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
777: x_isvalid OUT NOCOPY VARCHAR2,
778: x_dim_members OUT NOCOPY VARCHAR2) IS
779:
780: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_eq_model';

Line 896: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

892: -- 'Y': if all Load Data Tasks Line members are subset of line members of Solve
893: -- 'N': there exists 1 or more Load Data Tasks which have line members that are
894: -- not a subset of the line members of Solve
895: procedure val_solve_gt_than_load(
896: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
897: x_isvalid OUT NOCOPY VARCHAR2,
898: x_task_name OUT NOCOPY VARCHAR2,
899: x_dim_members OUT NOCOPY VARCHAR2) IS
900:

Line 1057: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

1053: -- are all Loaded or Calculated
1054: -- 'N': there exists 1 or more Load Data Tasks which have line members that are
1055: -- not a subset of the line members of Solve
1056: procedure validate_generate_worksheet(
1057: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
1058: x_isvalid OUT NOCOPY VARCHAR2,
1059: x_invalid_tasks_list OUT NOCOPY VARCHAR2) IS
1060:
1061: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_eq_model';

Line 1183: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

1179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1180: x_return_status OUT NOCOPY VARCHAR2 ,
1181: x_msg_count OUT NOCOPY NUMBER,
1182: x_msg_data OUT NOCOPY VARCHAR2,
1183: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
1184: p_inputDims IN VARCHAR2,
1185: x_isvalid OUT NOCOPY VARCHAR2,
1186: x_invalid_dim_list OUT NOCOPY VARCHAR2,
1187: x_invalid_linemem_list OUT NOCOPY VARCHAR2) IS

Line 1595: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

1591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1592: x_return_status OUT NOCOPY VARCHAR2 ,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2,
1595: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
1596: p_outputDims IN VARCHAR2,
1597: x_isvalid OUT NOCOPY VARCHAR2,
1598: x_invalid_linemem_list OUT NOCOPY VARCHAR2) IS
1599:

Line 1868: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

1864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1865: x_return_status OUT NOCOPY VARCHAR2 ,
1866: x_msg_count OUT NOCOPY NUMBER,
1867: x_msg_data OUT NOCOPY VARCHAR2,
1868: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
1869: x_isvalid OUT NOCOPY VARCHAR2,
1870: x_invalid_tasks_list OUT NOCOPY VARCHAR2) IS
1871:
1872: l_api_name CONSTANT VARCHAR2(30) := 'val_template_le_model';

Line 2050: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

2046: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2047: x_return_status OUT NOCOPY VARCHAR2 ,
2048: x_msg_count OUT NOCOPY NUMBER,
2049: x_msg_data OUT NOCOPY VARCHAR2,
2050: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
2051: x_isvalid OUT NOCOPY VARCHAR2,
2052: x_dim_members OUT NOCOPY VARCHAR2) IS
2053:
2054: l_api_name CONSTANT VARCHAR2(30) := 'val_solveinp_eq_gentemp';

Line 2220: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

2216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2217: x_return_status OUT NOCOPY VARCHAR2 ,
2218: x_msg_count OUT NOCOPY NUMBER,
2219: x_msg_data OUT NOCOPY VARCHAR2,
2220: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
2221: x_isvalid OUT NOCOPY VARCHAR2,
2222: x_invalid_linemem_list OUT NOCOPY VARCHAR2) IS
2223:
2224: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_input_higher_levels';

Line 2375: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

2371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2372: x_return_status OUT NOCOPY VARCHAR2 ,
2373: x_msg_count OUT NOCOPY NUMBER,
2374: x_msg_data OUT NOCOPY VARCHAR2,
2375: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
2376: p_outputDims IN VARCHAR2,
2377: x_isvalid OUT NOCOPY VARCHAR2,
2378: x_invalid_dim_list OUT NOCOPY VARCHAR2,
2379: x_invalid_linemem_list OUT NOCOPY VARCHAR2) IS

Line 2781: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

2777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2778: x_return_status OUT NOCOPY VARCHAR2 ,
2779: x_msg_count OUT NOCOPY NUMBER,
2780: x_msg_data OUT NOCOPY VARCHAR2,
2781: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,
2782: p_hrz_level IN VARCHAR2,
2783: x_isvalid OUT NOCOPY VARCHAR2) IS
2784:
2785: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_hrzselections';

Line 2795: x_analysis_cycle_id zpb_analysis_cycles.analysis_cycle_id%type;

2791: l_hierlvlvs varchar2(100);
2792: l_hierlist varchar2(4000);
2793: l_hiername varchar2(100);
2794: sql_stmt varchar2(4000);
2795: x_analysis_cycle_id zpb_analysis_cycles.analysis_cycle_id%type;
2796:
2797:
2798: TYPE selections_cur is REF CURSOR;
2799: input_selections_cur selections_cur;

Line 2928: PROCEDURE delete_view(p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type)

2924: -------------------------------------------------------------------------------
2925:
2926: -- To delete view for an active instance
2927:
2928: PROCEDURE delete_view(p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type)
2929:
2930: IS
2931: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
2932: l_status_code varchar2(30);

Line 2931: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;

2927:
2928: PROCEDURE delete_view(p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type)
2929:
2930: IS
2931: l_pub_ac_id zpb_analysis_cycles.analysis_cycle_id%type;
2932: l_status_code varchar2(30);
2933: l_api_name CONSTANT VARCHAR2(30) := 'delete_view';
2934: l_api_version CONSTANT NUMBER := 1.0;
2935:

Line 2938: from zpb_analysis_cycles

2934: l_api_version CONSTANT NUMBER := 1.0;
2935:
2936: cursor published_ac is
2937: select status_code
2938: from zpb_analysis_cycles
2939: where analysis_cycle_id = p_analysis_cycle_id;
2940:
2941: BEGIN
2942: -- Standard Start of API savepoint

Line 2948: update zpb_analysis_cycles set status_code = 'MARKED_FOR_DELETION' where analysis_cycle_id = p_analysis_cycle_id ;

2944: open published_ac;
2945: fetch published_ac into l_status_code;
2946: close published_ac;
2947:
2948: update zpb_analysis_cycles set status_code = 'MARKED_FOR_DELETION' where analysis_cycle_id = p_analysis_cycle_id ;
2949: update ZPB_DC_OBJECTS set DELETE_INSTANCE_MEASURES_FLAG = 'Y' where ac_instance_id = p_analysis_cycle_id ;
2950:
2951: delete FROM zpb_measure_scope WHERE instance_ac_id = p_analysis_cycle_id;
2952: delete FROM zpb_measure_scope_exempt_users WHERE BUSINESS_PROCESS_ENTITY_ID = p_analysis_cycle_id;

Line 2980: l_bp_id zpb_analysis_cycles.analysis_cycle_id%type;

2976: itemkey IN varchar2,
2977: actid IN number,
2978: funcmode IN varchar2,
2979: resultout OUT nocopy varchar2) AS
2980: l_bp_id zpb_analysis_cycles.analysis_cycle_id%type;
2981: CURSOR c_val_res IS SELECT distinct message_type FROM
2982: ZPB_BP_VALIDATION_RESULTS WHERE BUS_PROC_ID = l_bp_id;
2983:
2984: CURSOR c_override_rt_warn IS SELECT value