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.15.12020000.2 2012/07/12 11:02:33 jmaddila 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 167: Wf_Core.Context('ECX_Purge', 'Purge_Outbound', transaction_type, transaction_subtype,party_id,party_site_id,to_char(fromDate),to_char(toDate));

163: /* Fix for Bug# 12860076 */
164: IF get_out_error_id%ISOPEN THEN
165: CLOSE get_out_error_id;
166: END IF;
167: Wf_Core.Context('ECX_Purge', 'Purge_Outbound', transaction_type, transaction_subtype,party_id,party_site_id,to_char(fromDate),to_char(toDate));
168: raise;
169: end PURGE_OUTBOUND;
170: --
171: -- procedure PURGE

Line 443: 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));

439: end if;
440: if(get_ext_ret_error_id%ISOPEN) then
441: close get_ext_ret_error_id;
442: end if;
443: 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));
444: raise;
445: end PURGE;
446:
447: --

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

542: end loop;
543: end loop; **/
544:
545: /* fix for bug 5852521 */
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

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

647: if(get_ext_ret_error_id%ISOPEN) then
648: close get_ext_ret_error_id;
649: end if;
650:
651: Wf_Core.Context('ECX_Purge', 'Purge_Items', itemType, itemKey, to_char(endDate));
652: -- raise;
653: END PURGE_ITEMS;
654: -- procedure Purge_Transactions
655: --This procedure has been incorporated to make the CP for purging obsolete ECX data.

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

739: end if;
740: if(get_ext_trans%ISOPEN) then
741: close get_ext_trans;
742: end if;
743: Wf_Core.Context('ECX_Purge', 'Purge_Transactions', transaction_Type, transaction_subtype, to_char(toDate));
744: raise;
745: END PURGE_TRANSACTIONS;
746: --
747:

Line 779: ecx_purge.commit_frequency_ecx := x_commit_frequency;

775: l_sql varchar2(500);
776: l_msg_inst varchar2(200);
777: begin
778:
779: ecx_purge.commit_frequency_ecx := x_commit_frequency;
780: ecx_purge.purge_transactions(transaction_type=>transaction_type,
781: transaction_subtype=>transaction_subtype,
782: fromdate=>l_fromdate,
783: todate=>l_todate);

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

776: l_msg_inst varchar2(200);
777: begin
778:
779: ecx_purge.commit_frequency_ecx := x_commit_frequency;
780: ecx_purge.purge_transactions(transaction_type=>transaction_type,
781: transaction_subtype=>transaction_subtype,
782: fromdate=>l_fromdate,
783: todate=>l_todate);
784:

Line 808: --show errors package body ECX_PURGE

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
810: --where type = 'PACKAGE BODY'
811: --and name = 'ECX_PURGE'
812: END ecx_purge;

Line 811: --and name = 'ECX_PURGE'

807:
808: --show errors package body ECX_PURGE
809: --select to_date('SQLERROR') from user_errors
810: --where type = 'PACKAGE BODY'
811: --and name = 'ECX_PURGE'
812: END ecx_purge;

Line 812: END ecx_purge;

808: --show errors package body ECX_PURGE
809: --select to_date('SQLERROR') from user_errors
810: --where type = 'PACKAGE BODY'
811: --and name = 'ECX_PURGE'
812: END ecx_purge;