DBA Data[Home] [Help]

APPS.MSC_WS_SRP dependencies on DUAL

Line 149: FROM dual;

145:
146: BEGIN
147: SELECT decode(archiveCurrVersPlan, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no)
148: INTO l_val_archivePlan
149: FROM dual;
150:
151: END;
152: -- populating PLAN_TYPE_DUMMY hidden parameter
153: -- Original default logic is "SELECT inventory_atp_flag from msc_designators d where

Line 224: FROM dual;

220: -- snapstaticentities, netchange, can be either Y or N, converted to 1 or 2
221: BEGIN
222: SELECT to_number(decode(snapstaticentities, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))
223: INTO l_val_snapstaticentities
224: FROM dual;
225:
226: SELECT to_number(decode(netchange, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))
227: INTO l_val_netchange
228: FROM dual;

Line 228: FROM dual;

224: FROM dual;
225:
226: SELECT to_number(decode(netchange, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))
227: INTO l_val_netchange
228: FROM dual;
229: END;
230:
231: processid := fnd_request.submit_request(
232: 'MSC', -- application