[Home] [Help]
1259: p_route_id number)
1260: is
1261: select RP.sequence_no,
1262: replace(RPV.value, '''', null) value
1263: from ff_route_parameter_values RPV
1264: , ff_route_parameters RP
1265: where RPV.user_entity_id = p_user_entity_id
1266: and RP.route_id = p_route_id
1267: and RPV.route_parameter_id = RP.route_parameter_id
1373: end if;
1374: end loop; -- end of for c1rec loop
1375: --
1376: -- The following loop searches through and replaces all where clause fillers
1377: -- (Un) with the value from ff_route_parameter_values. For a text value,
1378: -- the quotes have already pre-inserted into this table.
1379: --
1380: -- Load the route parameters cache to avoid re-execution of the cursor
1381: -- when binding values to bind variables
2213: end if;
2214: end loop; -- end of for c1rec loop
2215: --
2216: -- The following loop searches through and replaces all where clause fillers
2217: -- (Un) with the value from ff_route_parameter_values.
2218: -- NOTE. This is a run result route, assume that only balance type
2219: -- is the parameter and only in non batch mode.
2220: --
2221: if (p_balance_type_column is null) then
2362: p_route_id number)
2363: is
2364: select RP.sequence_no,
2365: RPV.value
2366: from ff_route_parameter_values RPV
2367: , ff_route_parameters RP
2368: where RPV.user_entity_id = p_user_entity_id
2369: and RP.route_id = p_route_id
2370: and RPV.route_parameter_id = RP.route_parameter_id
2467: end if;
2468: end loop; -- end of for c1rec loop
2469: --
2470: -- The following loop searches through and replaces all where clause fillers
2471: -- (Un) with the value from ff_route_parameter_values. For a text value,
2472: -- the quotes have already pre-inserted into this table.
2473: --
2474: -- Load the route parameters cache to avoid re-execution of the cursor
2475: -- when binding values to bind variables