APPS.ECX_PURGE dependencies on WF_PURGE

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

546: if nvl(fnd_profile.value('ECX_PURGE_WF'),'Y') = 'N' then
547: return;
548: end if;
549:
550: FOR i in 1..WF_PURGE.l_itemtypeTAB.count loop
551:
552: select msgid into v_msgid from ecx_doclogs where
553: (item_type = WF_PURGE.l_itemtypeTAB(i)) and (item_key =WF_PURGE.l_itemkeyTAB(i) ) ;
554: purgable := true;

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

549:
550: FOR i in 1..WF_PURGE.l_itemtypeTAB.count loop
551:
552: select msgid into v_msgid from ecx_doclogs where
553: (item_type = WF_PURGE.l_itemtypeTAB(i)) and (item_key =WF_PURGE.l_itemkeyTAB(i) ) ;
554: purgable := true;
555: status := '';
556: if(purgable) then
557: open get_in_trigger_id(v_msgid);

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

784:
785: -- Return 0 for successful completion.
786: errbuf := '';
787: retcode := '0';
788: -- wf_purge.persistence_type := 'TEMP'; -- reset to the default value
789: --wf_purge.commit_frequency := 500; -- reset to the default value
790:
791: exception
792: when others then

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

785: -- Return 0 for successful completion.
786: errbuf := '';
787: retcode := '0';
788: -- wf_purge.persistence_type := 'TEMP'; -- reset to the default value
789: --wf_purge.commit_frequency := 500; -- reset to the default value
790:
791: exception
792: when others then
793: -- Retrieve error message into errbuf

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

801: -- Return 2 for error.
802: retcode := '2';
803:
804: -- Reset persistence type to the default value
805: -- wf_purge.persistence_type := 'TEMP';
806: end TotalConcurrent;
807:
808: --show errors package body ECX_PURGE
809: --select to_date('SQLERROR') from user_errors