DBA Data[Home] [Help]

APPS.XDP_PROC_CTL dependencies on DUAL

Line 292: select 1 into l_ParamCount from dual

288: ErrStr := null;
289:
290: if ParamType = 'WORKITEM' then
291: begin
292: select 1 into l_ParamCount from dual
293: where exists ( select LOOKUP_CODE
294: from CSI_LOOKUPS
295: where LOOKUP_CODE = Param
296: and lookup_type = 'CSI_EXTEND_ATTRIB_POOL');

Line 308: select 1 into l_ParamCount from dual

304: end;
305:
306: elsif ParamType = 'FA' then
307: begin
308: select 1 into l_ParamCount from dual
309: where exists (
310: select XFA.PARAMETER_NAME
311: from XDP_FA_PARAMETERS XFA
312: where FULFILLMENT_ACTION_ID = FAID

Line 1430: FROM dual;

1426:
1427: l_temp := REPLACE(l_Temp, ' ', '_');
1428:
1429: SELECT XDP_CHANNEL_S.NEXTVAL into l_Seq
1430: FROM dual;
1431:
1432: l_PipeName := to_char(l_Seq);
1433:
1434: l_SeqLen := LENGTH(l_PipeName);

Line 2677: select 1 into l_ParamCount from dual

2673: * If not there return an error message
2674: */
2675:
2676: begin
2677: select 1 into l_ParamCount from dual
2678: where exists (
2679: select FE_ATTRIBUTE_ID
2680: from XDP_FE_ATTRIBUTE_DEF xad, XDP_FE_SW_GEN_LOOKUP xfl
2681: where xad.FE_ATTRIBUTE_NAME = Param