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_SOLVE_OUTPUT_SELECTIONS

Line 188: from zpb_solve_output_selections

184: and member = l_member;
185: cursor output_selections_edt is
186: select '1'
187: from (select member, dimension,selection_name,hierarchy,match_input_flag
188: from zpb_solve_output_selections
189: where analysis_cycle_id = p_analysis_cycle_id
190: minus
191: select member, dimension,selection_name, hierarchy,match_input_flag
192: from zpb_solve_output_selections

Line 192: from zpb_solve_output_selections

188: from zpb_solve_output_selections
189: where analysis_cycle_id = p_analysis_cycle_id
190: minus
191: select member, dimension,selection_name, hierarchy,match_input_flag
192: from zpb_solve_output_selections
193: where analysis_cycle_id = l_pub_ac_id);
194:
195: cursor output_selections_pub is
196: select '1'

Line 198: from zpb_solve_output_selections

194:
195: cursor output_selections_pub is
196: select '1'
197: from (select member, dimension,selection_name,hierarchy,match_input_flag
198: from zpb_solve_output_selections
199: where analysis_cycle_id = l_pub_ac_id
200: minus
201: select member, dimension,selection_name, hierarchy,match_input_flag
202: from zpb_solve_output_selections

Line 202: from zpb_solve_output_selections

198: from zpb_solve_output_selections
199: where analysis_cycle_id = l_pub_ac_id
200: minus
201: select member, dimension,selection_name, hierarchy,match_input_flag
202: from zpb_solve_output_selections
203: where analysis_cycle_id = p_analysis_cycle_id);
204:
205:
206: cursor allocation_def_edt is

Line 1315: from zpb_solve_output_selections o

1311:
1312: -- find out the distinct output hierarchies on a dimension
1313: cursor outputhierarchy_c(p_dim in varchar2, p_input_line in varchar2) is
1314: select distinct o.hierarchy
1315: from zpb_solve_output_selections o
1316: where o.analysis_cycle_id = p_analysis_cycle_id
1317: and o.hierarchy <> 'NONE'
1318: and o.dimension = p_dim
1319: and o.member=p_input_line

Line 1326: zpb_solve_output_selections o

1322: cursor hiermember_c(p_dim in varchar2, l_selection_name in varchar2,
1323: l_hierarchy in varchar2) is
1324: select i.member
1325: from zpb_solve_input_selections i,
1326: zpb_solve_output_selections o
1327: where i.dimension = p_dim
1328: and i.analysis_cycle_id = p_analysis_cycle_id
1329: and i.member = o.member
1330: and i.analysis_cycle_id = o.analysis_cycle_id

Line 1602: l_dim zpb_solve_output_selections.dimension%type;

1598: x_invalid_linemem_list OUT NOCOPY VARCHAR2) IS
1599:
1600: l_api_name CONSTANT VARCHAR2(30) := 'validate_solve_levels';
1601: l_api_version CONSTANT NUMBER := 1.0;
1602: l_dim zpb_solve_output_selections.dimension%type;
1603: l_currentLine zpb_solve_output_selections.member%type;
1604: l_hierarchy zpb_solve_output_selections.hierarchy%type;
1605: l_outputSelection zpb_solve_output_selections.selection_name%type;
1606: l_dataAw varchar2(100);

Line 1603: l_currentLine zpb_solve_output_selections.member%type;

1599:
1600: l_api_name CONSTANT VARCHAR2(30) := 'validate_solve_levels';
1601: l_api_version CONSTANT NUMBER := 1.0;
1602: l_dim zpb_solve_output_selections.dimension%type;
1603: l_currentLine zpb_solve_output_selections.member%type;
1604: l_hierarchy zpb_solve_output_selections.hierarchy%type;
1605: l_outputSelection zpb_solve_output_selections.selection_name%type;
1606: l_dataAw varchar2(100);
1607: l_dataAwQual varchar2(100);

Line 1604: l_hierarchy zpb_solve_output_selections.hierarchy%type;

1600: l_api_name CONSTANT VARCHAR2(30) := 'validate_solve_levels';
1601: l_api_version CONSTANT NUMBER := 1.0;
1602: l_dim zpb_solve_output_selections.dimension%type;
1603: l_currentLine zpb_solve_output_selections.member%type;
1604: l_hierarchy zpb_solve_output_selections.hierarchy%type;
1605: l_outputSelection zpb_solve_output_selections.selection_name%type;
1606: l_dataAw varchar2(100);
1607: l_dataAwQual varchar2(100);
1608: l_inp_level_found varchar2(1);

Line 1605: l_outputSelection zpb_solve_output_selections.selection_name%type;

1601: l_api_version CONSTANT NUMBER := 1.0;
1602: l_dim zpb_solve_output_selections.dimension%type;
1603: l_currentLine zpb_solve_output_selections.member%type;
1604: l_hierarchy zpb_solve_output_selections.hierarchy%type;
1605: l_outputSelection zpb_solve_output_selections.selection_name%type;
1606: l_dataAw varchar2(100);
1607: l_dataAwQual varchar2(100);
1608: l_inp_level_found varchar2(1);
1609: l_input_valid varchar2(10);

Line 1613: l_currentDim zpb_solve_output_selections.dimension%type;

1609: l_input_valid varchar2(10);
1610: l_source_type number;
1611: l_outputvs varchar2(200);
1612: l_timedim varchar2(100);
1613: l_currentDim zpb_solve_output_selections.dimension%type;
1614: l_inputsel_bigger boolean;
1615: l_outputsel_bigger boolean;
1616: l_parentrel varchar2(100);
1617: l_hierdim varchar2(100);

Line 1628: from zpb_solve_output_selections o, zpb_solve_member_defs d,

1624:
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

Line 1646: from zpb_solve_output_selections o, zpb_solve_member_defs d,

1642: and nvl(o.selection_name,'DEFAULT') <> 'DEFAULT'
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

Line 1664: from zpb_solve_output_selections o, zpb_solve_member_defs d

1660: and nvl(o.selection_name,'DEFAULT') <> 'DEFAULT'
1661: AND NVL(o.match_input_flag, 'N') <> 'Y'
1662: union all
1663: select distinct o.selection_name, o.hierarchy
1664: from zpb_solve_output_selections o, zpb_solve_member_defs d
1665: where o.member = d.member
1666: and o.dimension = p_time_dim
1667: and o.dimension = p_dim
1668: and o.analysis_cycle_id = d.analysis_cycle_id

Line 1677: from zpb_solve_output_selections o, zpb_solve_member_defs d

1673:
1674: -- returns a member that uses an output selection
1675: cursor selection_member_c(p_dim in varchar2, l_selection_name in varchar2) is
1676: select o.member
1677: from zpb_solve_output_selections o, zpb_solve_member_defs d
1678: where o.selection_name = l_selection_name
1679: and o.member = d.member
1680: and o.dimension = p_dim
1681: and o.analysis_cycle_id = d.analysis_cycle_id

Line 1689: from zpb_solve_output_selections o

1685:
1686: cursor hiermember_c(p_dim in varchar2, l_selection_name in varchar2,
1687: l_hierarchy in varchar2) is
1688: select o.member
1689: from zpb_solve_output_selections o
1690: where o.dimension = p_dim
1691: and o.analysis_cycle_id = p_analysis_cycle_id
1692: and o.selection_name = l_selection_name
1693: and o.hierarchy = l_hierarchy

Line 2226: l_dim zpb_solve_output_selections.dimension%type;

2222: x_invalid_linemem_list OUT NOCOPY VARCHAR2) IS
2223:
2224: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_input_higher_levels';
2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_dim zpb_solve_output_selections.dimension%type;
2227: l_line_mem zpb_solve_output_selections.member%type;
2228: l_hierarchy zpb_solve_output_selections.hierarchy%type;
2229: l_output_selection_name zpb_solve_output_selections.selection_name%type;
2230: l_input_selection_name zpb_solve_input_selections.selection_name%type;

Line 2227: l_line_mem zpb_solve_output_selections.member%type;

2223:
2224: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_input_higher_levels';
2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_dim zpb_solve_output_selections.dimension%type;
2227: l_line_mem zpb_solve_output_selections.member%type;
2228: l_hierarchy zpb_solve_output_selections.hierarchy%type;
2229: l_output_selection_name zpb_solve_output_selections.selection_name%type;
2230: l_input_selection_name zpb_solve_input_selections.selection_name%type;
2231: l_dataAw varchar2(100);

Line 2228: l_hierarchy zpb_solve_output_selections.hierarchy%type;

2224: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_input_higher_levels';
2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_dim zpb_solve_output_selections.dimension%type;
2227: l_line_mem zpb_solve_output_selections.member%type;
2228: l_hierarchy zpb_solve_output_selections.hierarchy%type;
2229: l_output_selection_name zpb_solve_output_selections.selection_name%type;
2230: l_input_selection_name zpb_solve_input_selections.selection_name%type;
2231: l_dataAw varchar2(100);
2232: l_inp_level_found varchar2(1);

Line 2229: l_output_selection_name zpb_solve_output_selections.selection_name%type;

2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_dim zpb_solve_output_selections.dimension%type;
2227: l_line_mem zpb_solve_output_selections.member%type;
2228: l_hierarchy zpb_solve_output_selections.hierarchy%type;
2229: l_output_selection_name zpb_solve_output_selections.selection_name%type;
2230: l_input_selection_name zpb_solve_input_selections.selection_name%type;
2231: l_dataAw varchar2(100);
2232: l_inp_level_found varchar2(1);
2233: l_common_hier varchar2(10);

Line 2241: from zpb_solve_output_selections o, zpb_solve_member_defs m

2237:
2238: cursor output_info is
2239: select o.member, o.dimension, o.hierarchy, o.selection_name,
2240: m.source_type
2241: from zpb_solve_output_selections o, zpb_solve_member_defs m
2242: where m.analysis_cycle_id = p_analysis_cycle_id
2243: and m.analysis_cycle_id = o.analysis_cycle_id
2244: and m.member = o.member
2245: and m.source_type <> 1200;

Line 2384: l_currentDim zpb_solve_output_selections.dimension%type ;

2380:
2381: l_api_name CONSTANT VARCHAR2(30) := 'validate_output_selections';
2382: l_api_version CONSTANT NUMBER := 1.0;
2383: l_dataAw VARCHAR2(4000);
2384: l_currentDim zpb_solve_output_selections.dimension%type ;
2385: l_fetchedDim zpb_solve_output_selections.dimension%type;
2386: l_outputSelection zpb_solve_output_selections.selection_name%type;
2387: l_currentLine zpb_solve_output_selections.member%type;
2388: l_dimCount integer;

Line 2385: l_fetchedDim zpb_solve_output_selections.dimension%type;

2381: l_api_name CONSTANT VARCHAR2(30) := 'validate_output_selections';
2382: l_api_version CONSTANT NUMBER := 1.0;
2383: l_dataAw VARCHAR2(4000);
2384: l_currentDim zpb_solve_output_selections.dimension%type ;
2385: l_fetchedDim zpb_solve_output_selections.dimension%type;
2386: l_outputSelection zpb_solve_output_selections.selection_name%type;
2387: l_currentLine zpb_solve_output_selections.member%type;
2388: l_dimCount integer;
2389: i integer := 1;

Line 2386: l_outputSelection zpb_solve_output_selections.selection_name%type;

2382: l_api_version CONSTANT NUMBER := 1.0;
2383: l_dataAw VARCHAR2(4000);
2384: l_currentDim zpb_solve_output_selections.dimension%type ;
2385: l_fetchedDim zpb_solve_output_selections.dimension%type;
2386: l_outputSelection zpb_solve_output_selections.selection_name%type;
2387: l_currentLine zpb_solve_output_selections.member%type;
2388: l_dimCount integer;
2389: i integer := 1;
2390: l_currpos integer := 1;

Line 2387: l_currentLine zpb_solve_output_selections.member%type;

2383: l_dataAw VARCHAR2(4000);
2384: l_currentDim zpb_solve_output_selections.dimension%type ;
2385: l_fetchedDim zpb_solve_output_selections.dimension%type;
2386: l_outputSelection zpb_solve_output_selections.selection_name%type;
2387: l_currentLine zpb_solve_output_selections.member%type;
2388: l_dimCount integer;
2389: i integer := 1;
2390: l_currpos integer := 1;
2391: l_nextpos integer := 1;

Line 2409: from zpb_solve_output_selections

2405: from zpb_solve_member_defs
2406: where analysis_cycle_id = p_analysis_cycle_id
2407: and source_type in (1000,1100,1130)
2408: and member not in (select member
2409: from zpb_solve_output_selections
2410: where analysis_cycle_id = p_analysis_cycle_id);
2411:
2412: -- find all the null selections
2413: cursor nullselections_c (p_dim in varchar2, p_time_dim in varchar2) is

Line 2415: from zpb_solve_output_selections o, zpb_solve_member_defs d,

2411:
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

Line 2433: from zpb_solve_output_selections o, zpb_solve_member_defs d,

2429: and o.selection_name is null
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

Line 2451: from zpb_solve_output_selections o, zpb_solve_member_defs d

2447: and o.selection_name is null
2448: AND NVL(o.match_input_flag, 'N') <> 'Y'
2449: union all
2450: select o.member, o.dimension,o.selection_name
2451: from zpb_solve_output_selections o, zpb_solve_member_defs d
2452: where d.member = o.member
2453: and d.analysis_cycle_id = o.analysis_cycle_id
2454: and d.analysis_cycle_id = p_analysis_cycle_id
2455: and d.source_type in (1100,1130)

Line 2464: from zpb_solve_output_selections o, zpb_solve_member_defs d,

2460:
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

Line 2482: from zpb_solve_output_selections o, zpb_solve_member_defs d,

2478: and o.selection_name is not null
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

Line 2500: from zpb_solve_output_selections o, zpb_solve_member_defs d

2496: and o.selection_name is not null
2497: AND NVL(o.match_input_flag, 'N') <> 'Y'
2498: union all
2499: select distinct o.selection_name, o.hierarchy
2500: from zpb_solve_output_selections o, zpb_solve_member_defs d
2501: where o.member = d.member
2502: and o.dimension <> p_time_dim
2503: and o.dimension = p_dim
2504: and o.analysis_cycle_id = d.analysis_cycle_id

Line 2512: from zpb_solve_output_selections a, zpb_line_dimensionality b,

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

Line 2527: from zpb_solve_output_selections a,

2523: AND a.dimension= p_dim
2524: AND NVL(a.match_input_flag, 'N') <> 'Y'
2525: union
2526: select a.member
2527: from zpb_solve_output_selections a,
2528: zpb_solve_member_defs b
2529: where a.member = b.member
2530: AND a.analysis_cycle_id = b.analysis_cycle_id
2531: AND b.analysis_cycle_id = p_analysis_cycle_id

Line 2541: from zpb_solve_output_selections o

2537:
2538: cursor hiermember_c(p_dim in varchar2, l_selection_name in varchar2,
2539: l_hierarchy in varchar2) is
2540: select o.member
2541: from zpb_solve_output_selections o
2542: where o.dimension = p_dim
2543: and o.analysis_cycle_id = p_analysis_cycle_id
2544: and o.selection_name = l_selection_name
2545: and o.hierarchy = l_hierarchy

Line 2787: l_hierarchy zpb_solve_output_selections.hierarchy%type;

2783: x_isvalid OUT NOCOPY VARCHAR2) IS
2784:
2785: l_api_name CONSTANT VARCHAR2(30) := 'val_solve_hrzselections';
2786: l_api_version CONSTANT NUMBER := 1.0;
2787: l_hierarchy zpb_solve_output_selections.hierarchy%type;
2788: l_dataAw varchar2(100);
2789: l_timedim varchar2(100);
2790: l_hierdim varchar2(100);
2791: l_hierlvlvs varchar2(100);

Line 2871: ' zpb_solve_output_selections a where ' ||

2867:
2868: --check that there isn't any member that does not share any output hierarchy
2869: -- with the hierarchy list
2870: sql_stmt := ' select member from ' ||
2871: ' zpb_solve_output_selections a where ' ||
2872: ' :1 = a.analysis_cycle_id and ' ||
2873: ' :2 = a.dimension ' ||
2874: ' and not exists ( select b.hierarchy from ' ||
2875: ' zpb_solve_output_selections b where ' ||

Line 2875: ' zpb_solve_output_selections b where ' ||

2871: ' zpb_solve_output_selections a where ' ||
2872: ' :1 = a.analysis_cycle_id and ' ||
2873: ' :2 = a.dimension ' ||
2874: ' and not exists ( select b.hierarchy from ' ||
2875: ' zpb_solve_output_selections b where ' ||
2876: ' a.analysis_cycle_id = b.analysis_cycle_id ' ||
2877: ' and a.member = b.member ' ||
2878: ' and a.dimension = b.dimension ' ||
2879: ' and b.hierarchy in ' || l_hierlist || ')';