DBA Data[Home] [Help]

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on DBMS_RANDOM

Line 1321: l_value := trunc(dbms_random.value(0,999999999999));

1317: l_rep_counter Number;
1318: l_org_id Number;
1319: l_new_date Date;
1320: Begin
1321: l_value := trunc(dbms_random.value(0,999999999999));
1322: if p_kanban_plan_id = -1 then
1323: l_sql := 'delete from MTL_KANBAN_PULL_SEQUENCES mkps1 where mkps1.Kanban_Plan_id = 0 and mkps1.pull_sequence_id in'||
1324: '(select syspullseq.pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES syspullseq, MTL_KANBAN_PULL_SEQUENCES prodpullSeq'||
1325: ' where syspullseq.kanban_plan_id = 0 and prodpullSeq.kanban_plan_id = -1 '||