APPS.ECX_PURGE dependencies on WF_PURGE

Line 535: FOR i in 1..WF_PURGE.l_itemtypeTAB.count loop

531: if nvl(fnd_profile.value('ECX_PURGE_WF'),'Y') = 'N' then
532: return;
533: end if;
534:
535: FOR i in 1..WF_PURGE.l_itemtypeTAB.count loop
536:
537: select msgid into v_msgid from ecx_doclogs where
538: (item_type = WF_PURGE.l_itemtypeTAB(i)) and (item_key =WF_PURGE.l_itemkeyTAB(i) ) ;
539: purgable := true;

Line 538: (item_type = WF_PURGE.l_itemtypeTAB(i)) and (item_key =WF_PURGE.l_itemkeyTAB(i) ) ;

534:
535: FOR i in 1..WF_PURGE.l_itemtypeTAB.count loop
536:
537: select msgid into v_msgid from ecx_doclogs where
538: (item_type = WF_PURGE.l_itemtypeTAB(i)) and (item_key =WF_PURGE.l_itemkeyTAB(i) ) ;
539: purgable := true;
540: status := '';
541: if(purgable) then
542: open get_in_trigger_id(v_msgid);

Line 773: -- wf_purge.persistence_type := 'TEMP'; -- reset to the default value

769:
770: -- Return 0 for successful completion.
771: errbuf := '';
772: retcode := '0';
773: -- wf_purge.persistence_type := 'TEMP'; -- reset to the default value
774: --wf_purge.commit_frequency := 500; -- reset to the default value
775:
776: exception
777: when others then

Line 774: --wf_purge.commit_frequency := 500; -- reset to the default value

770: -- Return 0 for successful completion.
771: errbuf := '';
772: retcode := '0';
773: -- wf_purge.persistence_type := 'TEMP'; -- reset to the default value
774: --wf_purge.commit_frequency := 500; -- reset to the default value
775:
776: exception
777: when others then
778: -- Retrieve error message into errbuf

Line 790: -- wf_purge.persistence_type := 'TEMP';

786: -- Return 2 for error.
787: retcode := '2';
788:
789: -- Reset persistence type to the default value
790: -- wf_purge.persistence_type := 'TEMP';
791: end TotalConcurrent;
792:
793: --show errors package body ECX_PURGE
794: --select to_date('SQLERROR') from user_errors