APPS.ZPB_ACVAL_PVT dependencies on ZPB_TASK_PARAMETERS

Line 801: from zpb_task_parameters

797: and wf_process_name = 'LOAD_DATA';
798:
799: cursor load_data_query is
800: select name,value
801: from zpb_task_parameters
802: where task_id = l_task_id
803: and name in ('QUERY_OBJECT_PATH','QUERY_OBJECT_NAME', 'DATA_SELECTION_TYPE'
804: );
805: begin

Line 924: from zpb_task_parameters

920: and wf_process_name = 'LOAD_DATA';
921:
922: cursor load_data_query is
923: select name,value
924: from zpb_task_parameters
925: where task_id = l_task_id
926: and name in ('QUERY_OBJECT_PATH','QUERY_OBJECT_NAME','DATA_SELECTION_TYPE');
927:
928: begin

Line 1065: l_task_name zpb_task_parameters.name%type;

1061: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_eq_model';
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);

Line 1082: from zpb_task_parameters

1078: and wf_process_name = 'GENERATE_TEMPLATE';
1079:
1080: cursor generate_worksheet_query is
1081: select name,value
1082: from zpb_task_parameters
1083: where task_id = l_task_id
1084: and name in ('TEMPLATE_DATAENTRY_OBJ_PATH','TEMPLATE_DATAENTRY_OBJ_NAME');
1085: begin
1086:

Line 1882: l_task_name zpb_task_parameters.name%type;

1878: l_model_query zpb_cycle_model_dimensions.query_object_path%type;
1879: l_vs varchar2(100);
1880: l_pushed_solve varchar2(2) := 'N';
1881: l_lines_compare integer;
1882: l_task_name zpb_task_parameters.name%type;
1883: l_dataAw varchar2(100);
1884: l_task_exists varchar2(1);
1885: l_path_exists varchar2(1);
1886: l_name_exists varchar2(1);

Line 1902: from zpb_task_parameters

1898: and wf_process_name = 'GENERATE_TEMPLATE';
1899:
1900: cursor generate_worksheet_query is
1901: select name,value
1902: from zpb_task_parameters
1903: where task_id = l_task_id
1904: and name in ('TEMPLATE_DATAENTRY_OBJ_PATH','TEMPLATE_DATAENTRY_OBJ_NAME');
1905:
1906: begin

Line 2076: from zpb_task_parameters

2072: and wf_process_name = 'GENERATE_TEMPLATE';
2073:
2074: cursor load_data_query is
2075: select name,value
2076: from zpb_task_parameters
2077: where task_id = l_task_id
2078: and name in ('TEMPLATE_DATAENTRY_OBJ_PATH','TEMPLATE_DATAENTRY_OBJ_NAME');
2079:
2080: begin