APPS.AS_SALES_LEAD_OWNER dependencies on AS_SALES_LEAD_OWNER

Line 1: PACKAGE BODY AS_SALES_LEAD_OWNER AS

1: PACKAGE BODY AS_SALES_LEAD_OWNER AS
2: /* $Header: asxvslnb.pls 115.7 2003/11/15 00:49:50 solin ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):='AS_SALES_LEAD_OWNER';

Line 5: g_pkg_name CONSTANT VARCHAR2(30):='AS_SALES_LEAD_OWNER';

1: PACKAGE BODY AS_SALES_LEAD_OWNER AS
2: /* $Header: asxvslnb.pls 115.7 2003/11/15 00:49:50 solin ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):='AS_SALES_LEAD_OWNER';
6:
7: ---------------------------------------------------------------------
8: -- PROCEDURE
9: -- Check_Uk_Items

Line 303: FROM AS_SALES_LEAD_OWNERS

299: IS
300:
301: CURSOR c_Lead_Owner IS
302: SELECT *
303: FROM AS_SALES_LEAD_OWNERS
304: WHERE Lead_Owner_id = p_Lead_Owner_rec.Lead_Owner_id;
305:
306: l_Lead_Owner_rec c_Lead_Owner%ROWTYPE;
307:

Line 542: SELECT AS_SALES_LEAD_OWNERS_S.NEXTVAL FROM DUAL;

538:
539:
540: -- Cursor to get the sequence for Lead_Owner
541: CURSOR c_Lead_Owner_seq IS
542: SELECT AS_SALES_LEAD_OWNERS_S.NEXTVAL FROM DUAL;
543:
544: -- Cursor to validate the uniqueness
545: CURSOR c_count(cv_Lead_Owner_id IN NUMBER) IS
546: SELECT 'ANYTHING'

Line 547: FROM AS_SALES_LEAD_OWNERS

543:
544: -- Cursor to validate the uniqueness
545: CURSOR c_count(cv_Lead_Owner_id IN NUMBER) IS
546: SELECT 'ANYTHING'
547: FROM AS_SALES_LEAD_OWNERS
548: WHERE Lead_Owner_id = cv_Lead_Owner_id;
549:
550:
551: BEGIN

Line 626: INSERT INTO AS_SALES_LEAD_OWNERS (

622: RAISE FND_API.g_exc_error;
623: END IF;
624:
625: --DBMS_output.put_line(l_full_name||': start insert');
626: INSERT INTO AS_SALES_LEAD_OWNERS (
627: lead_Owner_id
628: ,category
629: ,country
630: ,from_postal_code

Line 778: DELETE FROM AS_SALES_LEAD_OWNERS

774:
775: ------------------------ delete ------------------------
776: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': delete');
777:
778: DELETE FROM AS_SALES_LEAD_OWNERS
779: WHERE Lead_Owner_id = p_Lead_Owner_id
780: AND object_version_number = p_object_version;
781:
782: IF (SQL%NOTFOUND) THEN

Line 869: FROM AS_SALES_LEAD_OWNERS

865: l_Lead_Owner_id NUMBER;
866:
867: CURSOR c_Lead_Owner IS
868: SELECT Lead_Owner_id
869: FROM AS_SALES_LEAD_OWNERS
870: WHERE Lead_Owner_id = p_Lead_Owner_id
871: AND object_version_number = p_object_version
872: FOR UPDATE OF Lead_Owner_id NOWAIT;
873:

Line 1063: UPDATE AS_SALES_LEAD_OWNERS SET

1059:
1060: -------------------------- update --------------------
1061: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': update');
1062:
1063: UPDATE AS_SALES_LEAD_OWNERS SET
1064: category = l_Lead_Owner_rec.category
1065: ,country = l_Lead_Owner_rec.country
1066: ,from_postal_code = l_Lead_Owner_rec.from_postal_code
1067: ,to_postal_code = l_Lead_Owner_rec.to_postal_code

Line 1177: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1173:
1174:
1175: CURSOR lc_lead_owners_postal(pc_lead_id NUMBER) IS
1176: SELECT aso.cm_resource_id, aso.owner_flag
1177: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1178: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1179: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1180: AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE
1181: AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;

Line 1185: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1181: AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;
1182:
1183: CURSOR lc_lead_owners_country(pc_lead_id NUMBER) IS
1184: SELECT aso.cm_resource_id, aso.owner_flag
1185: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1186: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1187: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1188: -- AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE);
1189: AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;

Line 1329: -- Search in AS_SALES_LEAD_OWNER table for the lead woner where

1325:
1326: ---------------------------------------------------------------------
1327: -- PROCEDURE
1328: -- Get_Immatured_Lead_Owner
1329: -- Search in AS_SALES_LEAD_OWNER table for the lead woner where
1330: -- CATEGORY = 'IMMATURED'
1331: ----------------------------------------------------------------------
1332: PROCEDURE Get_Immatured_Lead_Owner(
1333: p_api_version IN NUMBER

Line 1363: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1359:
1360:
1361: CURSOR lc_lead_owners_postal(pc_lead_id NUMBER) IS
1362: SELECT aso.cm_resource_id, aso.owner_flag
1363: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1364: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1365: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1366: AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE
1367: AND ASO.CATEGORY = 'IMMATURED'

Line 1372: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1368: AND ASO.OWNER_FLAG = 'Y';
1369:
1370: CURSOR lc_lead_owners_country(pc_lead_id NUMBER) IS
1371: SELECT aso.cm_resource_id, aso.owner_flag
1372: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1373: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1374: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1375: -- AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE);
1376: AND ASO.CATEGORY = 'IMMATURED'

Line 1518: END AS_SALES_LEAD_OWNER;

1514:
1515: END Get_Immatured_Lead_Owner;
1516:
1517:
1518: END AS_SALES_LEAD_OWNER;