APPS.BIS_PMV_ACTUAL_PVT dependencies on DUAL

Line 52: select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;

48: else
49: l_user_id := p_user_id;
50: end if;
51:
52: select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;
53:
54: STORE_PARAMETERS(p_region_code => p_region_code
55: ,p_function_name => l_function_name
56: ,p_user_id => l_user_id

Line 482: l_sql := 'select '||l_temp_actual_formula||' from dual';

478: /*
479: for i in 1..l_actual_count loop
480: l_temp_actual_formula := replace(l_temp_actual_formula, l_actual_base_columns(i), l_actual_values(i));
481: end loop;
482: l_sql := 'select '||l_temp_actual_formula||' from dual';
483: begin
484: execute immediate l_sql into l_actual_value;
485: exception
486: when others then

Line 513: l_sql := 'select '||l_temp_compareto_formula||' from dual';

509: /*
510: for i in 1..l_compareto_count loop
511: l_temp_compareto_formula := replace(l_temp_compareto_formula, l_compareto_base_columns(i), l_compareto_values(i));
512: end loop;
513: l_sql := 'select '||l_temp_compareto_formula||' from dual';
514: begin
515: execute immediate l_sql into l_compareto_value;
516: exception
517: when others then

Line 709: select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;

705: else
706: l_user_id := p_user_id;
707: end if;
708:
709: select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;
710: --dbms_output.put_line ('Session id '|| l_session_id);
711: -- Determine if this is a view by or non-view by report
712: if (c_viewby%ISOPEN) THEN
713: CLOSE c_viewby;

Line 1229: l_sql := 'select '||l_temp_actual_formula||' from dual';

1225: /*
1226: for i in 1..l_actual_count loop
1227: l_temp_actual_formula := replace(l_temp_actual_formula, l_actual_base_columns(i), l_actual_values(i));
1228: end loop;
1229: l_sql := 'select '||l_temp_actual_formula||' from dual';
1230: begin
1231: execute immediate l_sql into l_actual_value;
1232: exception
1233: when others then

Line 1275: l_sql := 'select '||l_temp_compareto_formula||' from dual';

1271: /*
1272: for i in 1..l_compareto_count loop
1273: l_temp_compareto_formula := replace(l_temp_compareto_formula, l_compareto_base_columns(i), l_compareto_values(i));
1274: end loop;
1275: l_sql := 'select '||l_temp_compareto_formula||' from dual';
1276: --dbms_output.put_line('sql: '||l_sql);
1277: if g_debug_on then
1278: l_debug_msg := l_debug_msg || ' sql: '||l_sql;
1279: end if;

Line 1829: select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;

1825: end if;
1826:
1827: l_parameters := p_parameters;
1828:
1829: select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;
1830: --dbms_output.put_line ('Session id '|| l_session_id);
1831:
1832: -- Determine if this is a view by or non-view by report
1833: if (c_viewby%ISOPEN) THEN

Line 2280: l_sql := 'select '||l_formula||' from dual';

2276: end loop;
2277:
2278: --dbms_output.put_line ('new formula is: '|| l_formula);
2279:
2280: l_sql := 'select '||l_formula||' from dual';
2281: --dbms_output.put_line('sql: '||l_sql);
2282:
2283: l_cursor := dbms_sql.open_cursor;
2284: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);