APPS.ASN_MIG_SALES_TEAM_PVT dependencies on ASN_MIG_SALES_TEAM_PVT

Line 1: PACKAGE BODY asn_mig_sales_team_pvt AS

1: PACKAGE BODY asn_mig_sales_team_pvt AS
2: /* $Header: asnvmstb.pls 120.7 2007/12/26 08:22:31 snsarava ship $ */
3:
4: --
5: --

Line 9: -- asn_mig_sales_team_pvt

5: --
6: -- Start of Comments
7: --
8: -- NAME
9: -- asn_mig_sales_team_pvt
10: --
11: -- PURPOSE
12: -- This package contains migration related code for sales team.
13: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):='asn_mig_sales_team_pvt';

16: -- HISTORY
17: -- sumahali 01/09/2005 Created
18: -- **********************************************************************************************************
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):='asn_mig_sales_team_pvt';
21: G_FILE_NAME CONSTANT VARCHAR2(12):='asnvmscb.pls';
22:
23: --
24: --

Line 31: 'asn.plsql.asn_mig_sales_team_pvt.FixEnddayFlags';

27: PROCEDURE FixEnddayFlags (p_lead_id IN NUMBER, p_debug_flag IN VARCHAR2)
28: IS
29:
30: l_module_name CONSTANT VARCHAR2(256) :=
31: 'asn.plsql.asn_mig_sales_team_pvt.FixEnddayFlags';
32:
33: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
34: TYPE DateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
35: TYPE Var1Tab IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 174: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Opp';

170: )
171: IS
172:
173: l_module_name CONSTANT VARCHAR2(256) :=
174: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Opp';
175:
176: l_uncommitted_opps NUMBER := 0;
177: l_remove_count NUMBER;
178: l_custfix_count NUMBER;

Line 401: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Lead';

397: )
398: IS
399:
400: l_module_name CONSTANT VARCHAR2(256) :=
401: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Lead';
402:
403: l_uncommitted_leads NUMBER := 0;
404: l_remove_count NUMBER;
405: l_updated_flag BOOLEAN;

Line 601: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Main';

597: IS
598: l_api_name CONSTANT VARCHAR2(30) :=
599: 'Mig_Dup_SalesRep_Main';
600: l_module_name CONSTANT VARCHAR2(256) :=
601: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Main';
602: l_msg_count NUMBER;
603: l_msg_data VARCHAR2(2000);
604: l_req_id NUMBER;
605: l_request_data VARCHAR2(30);

Line 1029: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Cust';

1025: )
1026: IS
1027:
1028: l_module_name CONSTANT VARCHAR2(256) :=
1029: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Dup_SalesRep_Cust';
1030:
1031: l_uncommitted_parties NUMBER := 0;
1032: l_remove_count NUMBER;
1033: l_updated_flag BOOLEAN;

Line 1241: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Customerid_Enddaylog_Main';

1237: IS
1238: l_api_name CONSTANT VARCHAR2(30) :=
1239: 'Mig_Customerid_Enddaylog_Main';
1240: l_module_name CONSTANT VARCHAR2(256) :=
1241: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Customerid_Enddaylog_Main';
1242: l_msg_count NUMBER;
1243: l_msg_data VARCHAR2(2000);
1244: l_req_id NUMBER;
1245: l_request_data VARCHAR2(30);

Line 1492: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Customerid_Enddaylog_Sub';

1488:
1489: l_api_name CONSTANT VARCHAR2(30) :=
1490: 'Mig_Customerid_Enddaylog_Sub';
1491: l_module_name CONSTANT VARCHAR2(256) :=
1492: 'asn.plsql.asn_mig_sales_team_pvt.Mig_Customerid_Enddaylog_Sub';
1493:
1494: TYPE NumTab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1495: TYPE DateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1496: TYPE Var1Tab IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 1706: END asn_mig_sales_team_pvt;

1702:
1703: END Mig_Customerid_Enddaylog_Sub;
1704: --Newly added for concurrent program ASN Post Upgrade Log and Customer Update -- End
1705:
1706: END asn_mig_sales_team_pvt;