DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OWNER dependencies on AS_SALES_LEAD_OWNERS_S

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 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