APPS.ECX_PURGE dependencies on ECX_PURGE

Line 1: package body ECX_PURGE as

1: package body ECX_PURGE as
2: /* $Header: ECXPRGB.pls 120.4.12010000.3 2008/10/08 21:12:12 cpeixoto ship $*/
3: -- procedure PURGE
4: -- Delete records from ecx_outbound_logs which don't have item_type, item_key
5: -- (To delete records which don't have an entry in ecx_doclogs)

Line 157: Wf_Core.Context('ECX_Purge', 'Purge_Outbound', transaction_type, transaction_subtype,party_id,party_site_id,to_char(fromDate),to_char(toDate));

153: end if;
154: END LOOP;
155: exception
156: WHEN others THEN
157: Wf_Core.Context('ECX_Purge', 'Purge_Outbound', transaction_type, transaction_subtype,party_id,party_site_id,to_char(fromDate),to_char(toDate));
158: raise;
159: end PURGE_OUTBOUND;
160: --
161: -- procedure PURGE

Line 428: Wf_Core.Context('ECX_Purge', 'Purge', item_type, item_key,transaction_type, transaction_subtype,party_id,party_site_id,to_char(fromDate),to_char(toDate));

424: end if;
425: if(get_ext_ret_error_id%ISOPEN) then
426: close get_ext_ret_error_id;
427: end if;
428: Wf_Core.Context('ECX_Purge', 'Purge', item_type, item_key,transaction_type, transaction_subtype,party_id,party_site_id,to_char(fromDate),to_char(toDate));
429: raise;
430: end PURGE;
431:
432: --

Line 531: if nvl(fnd_profile.value('ECX_PURGE_WF'),'Y') = 'N' then

527: end loop;
528: end loop; **/
529:
530: /* fix for bug 5852521 */
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

Line 636: Wf_Core.Context('ECX_Purge', 'Purge_Items', itemType, itemKey, to_char(endDate));

632: if(get_ext_ret_error_id%ISOPEN) then
633: close get_ext_ret_error_id;
634: end if;
635:
636: Wf_Core.Context('ECX_Purge', 'Purge_Items', itemType, itemKey, to_char(endDate));
637: -- raise;
638: END PURGE_ITEMS;
639: -- procedure Purge_Transactions
640: --This procedure has been incorporated to make the CP for purging obsolete ECX data.

Line 728: Wf_Core.Context('ECX_Purge', 'Purge_Transactions', transaction_Type, transaction_subtype, to_char(toDate));

724: end if;
725: if(get_ext_trans%ISOPEN) then
726: close get_ext_trans;
727: end if;
728: Wf_Core.Context('ECX_Purge', 'Purge_Transactions', transaction_Type, transaction_subtype, to_char(toDate));
729: raise;
730: END PURGE_TRANSACTIONS;
731: --
732:

Line 764: ecx_purge.commit_frequency_ecx := x_commit_frequency;

760: l_sql varchar2(500);
761: l_msg_inst varchar2(200);
762: begin
763:
764: ecx_purge.commit_frequency_ecx := x_commit_frequency;
765: ecx_purge.purge_transactions(transaction_type=>transaction_type,
766: transaction_subtype=>transaction_subtype,
767: fromdate=>l_fromdate,
768: todate=>l_todate);

Line 765: ecx_purge.purge_transactions(transaction_type=>transaction_type,

761: l_msg_inst varchar2(200);
762: begin
763:
764: ecx_purge.commit_frequency_ecx := x_commit_frequency;
765: ecx_purge.purge_transactions(transaction_type=>transaction_type,
766: transaction_subtype=>transaction_subtype,
767: fromdate=>l_fromdate,
768: todate=>l_todate);
769:

Line 793: --show errors package body ECX_PURGE

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
795: --where type = 'PACKAGE BODY'
796: --and name = 'ECX_PURGE'
797: END ecx_purge;

Line 796: --and name = 'ECX_PURGE'

792:
793: --show errors package body ECX_PURGE
794: --select to_date('SQLERROR') from user_errors
795: --where type = 'PACKAGE BODY'
796: --and name = 'ECX_PURGE'
797: END ecx_purge;

Line 797: END ecx_purge;

793: --show errors package body ECX_PURGE
794: --select to_date('SQLERROR') from user_errors
795: --where type = 'PACKAGE BODY'
796: --and name = 'ECX_PURGE'
797: END ecx_purge;