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_CYCLE_MODEL_DIMENSIONS

Line 23: l_edt_query_path zpb_cycle_model_dimensions.query_object_path%type;

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;
27: l_sql zpb_status_sql.status_sql%type;

Line 24: l_pub_query_path zpb_cycle_model_dimensions.query_object_path%type;

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;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;

Line 28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%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;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;
31: l_removed_dim zpb_cycle_model_dimensions.remove_dimension_flag%type;
32: l_pub_member varchar2(100);

Line 29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;

25: l_edt_status_sql zpb_status_sql.status_sql%type;
26: l_pub_status_sql zpb_status_sql.status_sql%type;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;
31: l_removed_dim zpb_cycle_model_dimensions.remove_dimension_flag%type;
32: l_pub_member varchar2(100);
33: l_edt_member varchar2(100);

Line 30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;

26: l_pub_status_sql zpb_status_sql.status_sql%type;
27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;
31: l_removed_dim zpb_cycle_model_dimensions.remove_dimension_flag%type;
32: l_pub_member varchar2(100);
33: l_edt_member varchar2(100);
34: l_lines_compare integer;

Line 31: l_removed_dim zpb_cycle_model_dimensions.remove_dimension_flag%type;

27: l_sql zpb_status_sql.status_sql%type;
28: l_cycle_dim zpb_cycle_model_dimensions.dimension_name%type;
29: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
30: l_dataset_dim zpb_cycle_model_dimensions.dataset_dimension_flag%type;
31: l_removed_dim zpb_cycle_model_dimensions.remove_dimension_flag%type;
32: l_pub_member varchar2(100);
33: l_edt_member varchar2(100);
34: l_lines_compare integer;
35: l_edt_inp_sel_path varchar(200);

Line 105: from zpb_cycle_model_dimensions

101:
102:
103: cursor model_dimensions_edt is
104: select dimension_name,dataset_dimension_flag,remove_dimension_flag
105: from zpb_cycle_model_dimensions
106: where analysis_cycle_id = p_analysis_cycle_id
107: minus
108: select dimension_name,dataset_dimension_flag,remove_dimension_flag
109: from zpb_cycle_model_dimensions

Line 109: from zpb_cycle_model_dimensions

105: from zpb_cycle_model_dimensions
106: where analysis_cycle_id = p_analysis_cycle_id
107: minus
108: select dimension_name,dataset_dimension_flag,remove_dimension_flag
109: from zpb_cycle_model_dimensions
110: where analysis_cycle_id = l_pub_ac_id;
111:
112: cursor model_dimensions_pub is
113: select dimension_name,dataset_dimension_flag,remove_dimension_flag

Line 114: from zpb_cycle_model_dimensions

110: where analysis_cycle_id = l_pub_ac_id;
111:
112: cursor model_dimensions_pub is
113: select dimension_name,dataset_dimension_flag,remove_dimension_flag
114: from zpb_cycle_model_dimensions
115: where analysis_cycle_id = l_pub_ac_id
116: minus
117: select dimension_name,dataset_dimension_flag,remove_dimension_flag
118: from zpb_cycle_model_dimensions

Line 118: from zpb_cycle_model_dimensions

114: from zpb_cycle_model_dimensions
115: where analysis_cycle_id = l_pub_ac_id
116: minus
117: select dimension_name,dataset_dimension_flag,remove_dimension_flag
118: from zpb_cycle_model_dimensions
119: where analysis_cycle_id = p_analysis_cycle_id;
120:
121: cursor query_identifier(l_ac_id in number) is
122: select query_object_path|| '/' || query_object_name

Line 123: from zpb_cycle_model_dimensions

119: where analysis_cycle_id = p_analysis_cycle_id;
120:
121: cursor query_identifier(l_ac_id in number) is
122: select query_object_path|| '/' || query_object_name
123: from zpb_cycle_model_dimensions
124: where dimension_name = l_line_dim
125: and analysis_cycle_id = l_ac_id;
126:
127: cursor source_type is

Line 607: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;

603: l_api_name CONSTANT VARCHAR2(30) := 'compare_line_members';
604: l_dataAw varchar2(30);
605: l_dataAwQual varchar2(70);
606: l_temp_vs varchar2(100);
607: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
608:
609: begin
610:
611: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

Line 697: l_line_dim zpb_cycle_model_dimensions.dimension_name%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);
701: l_dataAw varchar2(100);

Line 698: l_query_name zpb_cycle_model_dimensions.query_object_path%type;

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);
701: l_dataAw varchar2(100);
702: l_pushed_solve varchar2(2) := 'N';

Line 699: l_query_path zpb_cycle_model_dimensions.query_object_path%type;

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);
701: l_dataAw varchar2(100);
702: l_pushed_solve varchar2(2) := 'N';
703:

Line 706: from zpb_cycle_model_dimensions

702: l_pushed_solve varchar2(2) := 'N';
703:
704: cursor query_identifier is
705: select query_object_path|| '/' || query_object_name
706: from zpb_cycle_model_dimensions
707: where dimension_name = l_line_dim
708: and analysis_cycle_id = p_analysis_cycle_id;
709:
710: begin

Line 781: l_line_dim zpb_cycle_model_dimensions.dimension_name%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';
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);

Line 782: l_query_name zpb_cycle_model_dimensions.query_object_path%type;

778: x_dim_members OUT NOCOPY VARCHAR2) IS
779:
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);

Line 783: l_query_path zpb_cycle_model_dimensions.query_object_path%type;

779:
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);

Line 902: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;

898: x_task_name OUT NOCOPY VARCHAR2,
899: x_dim_members OUT NOCOPY VARCHAR2) IS
900:
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;

Line 903: l_query_name zpb_cycle_model_dimensions.query_object_path%type;

899: x_dim_members OUT NOCOPY VARCHAR2) IS
900:
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);

Line 904: l_query_path zpb_cycle_model_dimensions.query_object_path%type;

900:
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);

Line 1062: l_line_dim zpb_cycle_model_dimensions.dimension_name%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';
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;

Line 1063: l_query_name zpb_cycle_model_dimensions.query_object_path%type;

1059: x_invalid_tasks_list OUT NOCOPY VARCHAR2) IS
1060:
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);

Line 1064: l_query_path zpb_cycle_model_dimensions.query_object_path%type;

1060:
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);

Line 1875: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;

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;
1879: l_vs varchar2(100);

Line 1876: l_template_query zpb_cycle_model_dimensions.query_object_path%type;

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;
1879: l_vs varchar2(100);
1880: l_pushed_solve varchar2(2) := 'N';

Line 1877: l_template_path zpb_cycle_model_dimensions.query_object_path%type;

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;
1879: l_vs varchar2(100);
1880: l_pushed_solve varchar2(2) := 'N';
1881: l_lines_compare integer;

Line 1878: l_model_query zpb_cycle_model_dimensions.query_object_path%type;

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;
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;

Line 1890: from zpb_cycle_model_dimensions

1886: l_name_exists varchar2(1);
1887:
1888: cursor query_model is
1889: select query_object_path|| '/' || query_object_name
1890: from zpb_cycle_model_dimensions
1891: where dimension_name = l_line_dim
1892: and analysis_cycle_id = p_analysis_cycle_id;
1893:
1894: cursor generate_task is

Line 2056: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;

2052: x_dim_members OUT NOCOPY VARCHAR2) IS
2053:
2054: l_api_name CONSTANT VARCHAR2(30) := 'val_solveinp_eq_gentemp';
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);

Line 2057: l_query_name zpb_cycle_model_dimensions.query_object_path%type;

2053:
2054: l_api_name CONSTANT VARCHAR2(30) := 'val_solveinp_eq_gentemp';
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);

Line 2058: l_query_path zpb_cycle_model_dimensions.query_object_path%type;

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