APPS.AML_PURGE_SALES_LEADS dependencies on AML_PURGE_SALES_LEADS

Line 1: PACKAGE BODY AML_PURGE_SALES_LEADS AS

1: PACKAGE BODY AML_PURGE_SALES_LEADS AS
2: /* $Header: amlslprgb.pls 115.5 2004/02/09 12:13:42 bmuthukr noship $ */
3: -- Start of Comments
4: -- Package name : AML_PURGE_SALES_LEADS
5: -- Purpose : Sales Leads Management

Line 4: -- Package name : AML_PURGE_SALES_LEADS

1: PACKAGE BODY AML_PURGE_SALES_LEADS AS
2: /* $Header: amlslprgb.pls 115.5 2004/02/09 12:13:42 bmuthukr noship $ */
3: -- Start of Comments
4: -- Package name : AML_PURGE_SALES_LEADS
5: -- Purpose : Sales Leads Management
6: -- NOTE :
7: -- History :
8: -- 10/17/2003 BMUTHUKR Created

Line 27: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AML_PURGE_SALES_LEADS';

23:
24:
25: TYPE del_count IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
26:
27: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AML_PURGE_SALES_LEADS';
28: G_FILE_NAME CONSTANT VARCHAR2(15) := 'amlslprgb.pls';
29: G_DEBUG_MODE VARCHAR2(1) := 'Y';
30: RECS_DELETED del_count;
31:

Line 79: PROCEDURE Delete_Unqualified_Leads(P_Id_Tab IN AML_PURGE_SALES_LEADS.Sales_Lead_Id_Tab) IS

75: aml_debug(1,Recs_deleted(11)||l_no_of_rows_deleted||'AS_SALES_LEADS');
76: END write_count;
77:
78:
79: PROCEDURE Delete_Unqualified_Leads(P_Id_Tab IN AML_PURGE_SALES_LEADS.Sales_Lead_Id_Tab) IS
80: BEGIN
81:
82: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
83: DELETE

Line 169: Id_Tab AML_PURGE_SALES_LEADS.Sales_Lead_Id_Tab;

165: p_end_date IN VARCHAR2,
166: p_debug_mode IN VARCHAR2 DEFAULT 'N',
167: p_trace_mode IN VARCHAR2 DEFAULT 'N') IS
168:
169: Id_Tab AML_PURGE_SALES_LEADS.Sales_Lead_Id_Tab;
170: l_status boolean;
171: l_start_date date;
172: l_end_date date;
173:

Line 257: END AML_PURGE_SALES_LEADS;

253: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
254:
255: END Purge_Unqualified_Leads;
256:
257: END AML_PURGE_SALES_LEADS;