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_CYCLE_TASKS

Line 228: from zpb_analysis_cycle_tasks edt,

224: where analysis_cycle_id = p_analysis_cycle_id);
225:
226: cursor task_list is
227: select '1'
228: from zpb_analysis_cycle_tasks edt,
229: zpb_analysis_cycle_tasks pub
230: where edt.analysis_cycle_id = l_edt_ac_id
231: and pub.analysis_cycle_id = l_pub_ac_id
232: and edt.sequence = pub.sequence

Line 229: zpb_analysis_cycle_tasks pub

225:
226: cursor task_list is
227: select '1'
228: from zpb_analysis_cycle_tasks edt,
229: zpb_analysis_cycle_tasks pub
230: where edt.analysis_cycle_id = l_edt_ac_id
231: and pub.analysis_cycle_id = l_pub_ac_id
232: and edt.sequence = pub.sequence
233: and edt.task_name <> pub.task_name;

Line 237: from zpb_analysis_cycle_tasks pub

233: and edt.task_name <> pub.task_name;
234:
235: cursor task_list_pub is
236: select '1'
237: from zpb_analysis_cycle_tasks pub
238: where sequence not in (select sequence
239: from zpb_analysis_cycle_tasks edt
240: where edt.analysis_cycle_id = l_edt_ac_id)
241: and pub.analysis_cycle_id = l_pub_ac_id;

Line 239: from zpb_analysis_cycle_tasks edt

235: cursor task_list_pub is
236: select '1'
237: from zpb_analysis_cycle_tasks pub
238: where sequence not in (select sequence
239: from zpb_analysis_cycle_tasks edt
240: where edt.analysis_cycle_id = l_edt_ac_id)
241: and pub.analysis_cycle_id = l_pub_ac_id;
242:
243: cursor status_sql(l_query_path in varchar2) is

Line 696: l_task_id zpb_analysis_cycle_tasks.task_id%type;

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;
697: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
698: l_query_name zpb_cycle_model_dimensions.query_object_path%type;
699: l_query_path zpb_cycle_model_dimensions.query_object_path%type;
700: l_vs varchar2(100);

Line 784: l_task_id zpb_analysis_cycle_tasks.task_id%type;

780: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_eq_model';
781: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
782: l_query_name zpb_cycle_model_dimensions.query_object_path%type;
783: l_query_path zpb_cycle_model_dimensions.query_object_path%type;
784: l_task_id zpb_analysis_cycle_tasks.task_id%type;
785: l_vs varchar2(100);
786: l_dataAw varchar2(100);
787: l_task_exists varchar2(1);
788: l_path_exists varchar2(1);

Line 795: from zpb_analysis_cycle_tasks

791: l_pushed_solve varchar2(2) := 'N';
792:
793: cursor generate_task is
794: select task_id
795: from zpb_analysis_cycle_tasks
796: where analysis_cycle_id = p_analysis_cycle_id
797: and wf_process_name = 'LOAD_DATA';
798:
799: cursor load_data_query is

Line 905: l_task_id zpb_analysis_cycle_tasks.task_id%type;

901: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_gt_than_load';
902: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
903: l_query_name zpb_cycle_model_dimensions.query_object_path%type;
904: l_query_path zpb_cycle_model_dimensions.query_object_path%type;
905: l_task_id zpb_analysis_cycle_tasks.task_id%type;
906: l_task_name zpb_analysis_cycle_tasks.task_name%type;
907: l_vs varchar2(100);
908: l_dataAw varchar2(100);
909: l_task_exists varchar2(1);

Line 906: l_task_name zpb_analysis_cycle_tasks.task_name%type;

902: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
903: l_query_name zpb_cycle_model_dimensions.query_object_path%type;
904: l_query_path zpb_cycle_model_dimensions.query_object_path%type;
905: l_task_id zpb_analysis_cycle_tasks.task_id%type;
906: l_task_name zpb_analysis_cycle_tasks.task_name%type;
907: l_vs varchar2(100);
908: l_dataAw varchar2(100);
909: l_task_exists varchar2(1);
910: l_path_exists varchar2(1);

Line 918: from zpb_analysis_cycle_tasks

914: l_selection_type varchar2(30);
915:
916: cursor generate_task is
917: select task_id,task_name
918: from zpb_analysis_cycle_tasks
919: where analysis_cycle_id = p_analysis_cycle_id
920: and wf_process_name = 'LOAD_DATA';
921:
922: cursor load_data_query is

Line 1066: l_task_id zpb_analysis_cycle_tasks.task_id%type;

1062: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
1063: l_query_name zpb_cycle_model_dimensions.query_object_path%type;
1064: l_query_path zpb_cycle_model_dimensions.query_object_path%type;
1065: l_task_name zpb_task_parameters.name%type;
1066: l_task_id zpb_analysis_cycle_tasks.task_id%type;
1067: l_vs varchar2(100);
1068: l_dataAw varchar2(100);
1069: l_task_exists varchar2(1);
1070: l_path_exists varchar2(1);

Line 1076: from zpb_analysis_cycle_tasks

1072: l_pushed_solve varchar2(2) := 'N';
1073:
1074: cursor generate_task is
1075: select task_id, task_name
1076: from zpb_analysis_cycle_tasks
1077: where analysis_cycle_id = p_analysis_cycle_id
1078: and wf_process_name = 'GENERATE_TEMPLATE';
1079:
1080: cursor generate_worksheet_query is

Line 1874: l_task_id zpb_analysis_cycle_tasks.task_id%type;

1870: x_invalid_tasks_list OUT NOCOPY VARCHAR2) IS
1871:
1872: l_api_name CONSTANT VARCHAR2(30) := 'val_template_le_model';
1873: l_api_version CONSTANT NUMBER := 1.0;
1874: l_task_id zpb_analysis_cycle_tasks.task_id%type;
1875: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
1876: l_template_query zpb_cycle_model_dimensions.query_object_path%type;
1877: l_template_path zpb_cycle_model_dimensions.query_object_path%type;
1878: l_model_query zpb_cycle_model_dimensions.query_object_path%type;

Line 1896: from zpb_analysis_cycle_tasks

1892: and analysis_cycle_id = p_analysis_cycle_id;
1893:
1894: cursor generate_task is
1895: select task_id, task_name
1896: from zpb_analysis_cycle_tasks
1897: where analysis_cycle_id = p_analysis_cycle_id
1898: and wf_process_name = 'GENERATE_TEMPLATE';
1899:
1900: cursor generate_worksheet_query is

Line 2059: l_task_id zpb_analysis_cycle_tasks.task_id%type;

2055: l_api_version CONSTANT NUMBER := 1.0;
2056: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
2057: l_query_name zpb_cycle_model_dimensions.query_object_path%type;
2058: l_query_path zpb_cycle_model_dimensions.query_object_path%type;
2059: l_task_id zpb_analysis_cycle_tasks.task_id%type;
2060: l_vs varchar2(100);
2061: l_dataAw varchar2(100);
2062: l_task_exists varchar2(1);
2063: l_path_exists varchar2(1);

Line 2070: from zpb_analysis_cycle_tasks

2066: l_pushed_solve varchar2(2) := 'N';
2067:
2068: cursor generate_task is
2069: select task_id
2070: from zpb_analysis_cycle_tasks
2071: where analysis_cycle_id = p_analysis_cycle_id
2072: and wf_process_name = 'GENERATE_TEMPLATE';
2073:
2074: cursor load_data_query is