[Home] [Help]
1346: p_route_id number)
1347: is
1348: select RP.sequence_no,
1349: replace(RPV.value, '''', null) value
1350: from ff_route_parameter_values RPV
1351: , ff_route_parameters RP
1352: where RPV.user_entity_id = p_user_entity_id
1353: and RP.route_id = p_route_id
1354: and RPV.route_parameter_id = RP.route_parameter_id
1460: end if;
1461: end loop; -- end of for c1rec loop
1462: --
1463: -- The following loop searches through and replaces all where clause fillers
1464: -- (Un) with the value from ff_route_parameter_values. For a text value,
1465: -- the quotes have already pre-inserted into this table.
1466: --
1467: -- Load the route parameters cache to avoid re-execution of the cursor
1468: -- when binding values to bind variables
2380: end if;
2381: end loop; -- end of for c1rec loop
2382: --
2383: -- The following loop searches through and replaces all where clause fillers
2384: -- (Un) with the value from ff_route_parameter_values.
2385: -- NOTE. This is a run result route, assume that only balance type
2386: -- is the parameter and only in non batch mode.
2387: --
2388: if (p_balance_type_column is null) then
2533: is
2534: select RP.sequence_no,
2535: RPV.value,
2536: RP.parameter_name
2537: from ff_route_parameter_values RPV
2538: , ff_route_parameters RP
2539: where RPV.user_entity_id = p_user_entity_id
2540: and RP.route_id = p_route_id
2541: and RPV.route_parameter_id = RP.route_parameter_id
2664: end if;
2665: end loop; -- end of for c1rec loop
2666: --
2667: -- The following loop searches through and replaces all where clause fillers
2668: -- (Un) with the value from ff_route_parameter_values. For a text value,
2669: -- the quotes have already pre-inserted into this table.
2670: --
2671: -- Load the route parameters cache to avoid re-execution of the cursor
2672: -- when binding values to bind variables