[Home] [Help]
1220: -- find all the null selections
1221: cursor nullselections_c (p_dim in varchar2, p_time_dim in varchar2) is
1222: select i.member,i.dimension, i.selection_name
1223: from zpb_solve_input_selections i, zpb_solve_member_defs d,
1224: zpb_line_dimensionality l
1225: where d.member = i.member
1226: and d.analysis_cycle_id = i.analysis_cycle_id
1227: and d.analysis_cycle_id = p_analysis_cycle_id
1228: and l.dimension = i.dimension
1237: and i.selection_name is null
1238: union all
1239: select i.member, i.dimension,i.selection_name
1240: from zpb_solve_input_selections i, zpb_solve_member_defs d,
1241: zpb_line_dimensionality l
1242: where d.member = i.member
1243: and d.analysis_cycle_id = i.analysis_cycle_id
1244: and d.analysis_cycle_id = p_analysis_cycle_id
1245: and l.dimension = i.dimension
1266: -- find all the non-null selections and evaluate them
1267: cursor nonnullselections_c(p_dim in varchar2, p_time_dim in varchar2) is
1268: select distinct i.selection_name
1269: from zpb_solve_input_selections i, zpb_solve_member_defs d,
1270: zpb_line_dimensionality l
1271: where i.member = d.member
1272: and i.dimension = p_time_dim
1273: and i.dimension = p_dim
1274: and i.analysis_cycle_id = d.analysis_cycle_id
1283: and i.selection_name is not null
1284: union all
1285: select distinct i.selection_name
1286: from zpb_solve_input_selections i, zpb_solve_member_defs d,
1287: zpb_line_dimensionality l
1288: where i.member = d.member
1289: and i.dimension <> p_time_dim
1290: and i.dimension = p_dim
1291: and i.analysis_cycle_id = d.analysis_cycle_id
1625: -- find all the non-null selections and evaluate them
1626: cursor nonnullselections_c(p_dim in varchar2, p_time_dim in varchar2) is
1627: select distinct o.selection_name, o.hierarchy
1628: from zpb_solve_output_selections o, zpb_solve_member_defs d,
1629: zpb_line_dimensionality l
1630: where o.member = d.member
1631: and o.dimension = p_time_dim
1632: and o.dimension = p_dim
1633: and o.analysis_cycle_id = d.analysis_cycle_id
1643: AND NVL(o.match_input_flag, 'N') <> 'Y'
1644: union all
1645: select distinct o.selection_name, o.hierarchy
1646: from zpb_solve_output_selections o, zpb_solve_member_defs d,
1647: zpb_line_dimensionality l
1648: where o.member = d.member
1649: and o.dimension <> p_time_dim
1650: and o.dimension = p_dim
1651: and o.analysis_cycle_id = d.analysis_cycle_id
2412: -- find all the null selections
2413: cursor nullselections_c (p_dim in varchar2, p_time_dim in varchar2) is
2414: select o.member,o.dimension, o.selection_name
2415: from zpb_solve_output_selections o, zpb_solve_member_defs d,
2416: zpb_line_dimensionality l
2417: where d.member = o.member
2418: and d.analysis_cycle_id = o.analysis_cycle_id
2419: and d.analysis_cycle_id = p_analysis_cycle_id
2420: and l.dimension = o.dimension
2430: AND NVL(o.match_input_flag, 'N') <> 'Y'
2431: union all
2432: select o.member, o.dimension,o.selection_name
2433: from zpb_solve_output_selections o, zpb_solve_member_defs d,
2434: zpb_line_dimensionality l
2435: where d.member = o.member
2436: and d.analysis_cycle_id = o.analysis_cycle_id
2437: and d.analysis_cycle_id = p_analysis_cycle_id
2438: and l.dimension = o.dimension
2461: -- find all the non-null selections and evaluate them
2462: cursor nonnullselections_c(p_dim in varchar2, p_time_dim in varchar2) is
2463: select distinct o.selection_name, o.hierarchy
2464: from zpb_solve_output_selections o, zpb_solve_member_defs d,
2465: zpb_line_dimensionality l
2466: where o.member = d.member
2467: and o.dimension = p_time_dim
2468: and o.dimension = p_dim
2469: and o.analysis_cycle_id = d.analysis_cycle_id
2479: AND NVL(o.match_input_flag, 'N') <> 'Y'
2480: union all
2481: select distinct o.selection_name, o.hierarchy
2482: from zpb_solve_output_selections o, zpb_solve_member_defs d,
2483: zpb_line_dimensionality l
2484: where o.member = d.member
2485: and o.dimension <> p_time_dim
2486: and o.dimension = p_dim
2487: and o.analysis_cycle_id = d.analysis_cycle_id
2508: AND NVL(o.match_input_flag, 'N') <> 'Y';
2509:
2510: -- returns a member that uses an output selection
2511: cursor selection_member_c(p_dim in varchar2, l_selection_name in varchar2) is select a.member
2512: from zpb_solve_output_selections a, zpb_line_dimensionality b,
2513: zpb_solve_member_defs c
2514: where a.member = b.member
2515: AND a.dimension = b.dimension
2516: AND a.member = c.member