APPS.AS_LEADS_PKG dependencies on AS_LEADS_ALL

Line 9: -- use AS_LEADS_ALL.

5: -- Purpose :
6: -- History : 06/30/00 FFANG Modified.
7: -- 08/02/00 FFANG Use lead_id as lead_number when insert.
8: -- 01/15/01 FFANG For bug 1580045, instead of AS_LEADS,
9: -- use AS_LEADS_ALL.
10: -- 02/12/04 RKUMARES For Bug#3437528. Update_row of PRM_REFERRAL_CODE changed.
11: -- NOTE :
12: -- End of Comments
13:

Line 108: INSERT INTO AS_LEADS_ALL(

104: FETCH C2 INTO px_LEAD_ID;
105: CLOSE C2;
106: End If;
107: -- INSERT INTO AS_LEADS(
108: INSERT INTO AS_LEADS_ALL(
109: LEAD_ID,
110: LAST_UPDATE_DATE,
111: LAST_UPDATED_BY,
112: CREATION_DATE,

Line 355: Update AS_LEADS_ALL

351:
352: IS
353: BEGIN
354: -- Update AS_LEADS
355: Update AS_LEADS_ALL
356: SET object_version_number = nvl(object_version_number,0) + 1,
357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 446: DELETE FROM AS_LEADS_ALL

442: p_LEAD_ID NUMBER)
443: IS
444: BEGIN
445: -- DELETE FROM AS_LEADS
446: DELETE FROM AS_LEADS_ALL
447: WHERE LEAD_ID = p_LEAD_ID;
448: If (SQL%NOTFOUND) then
449: RAISE NO_DATA_FOUND;
450: End If;

Line 537: FROM AS_LEADS_ALL

533: IS
534: CURSOR C IS
535: SELECT *
536: -- FROM AS_LEADS
537: FROM AS_LEADS_ALL
538: WHERE LEAD_ID = p_LEAD_ID
539: FOR UPDATE of LEAD_ID NOWAIT;
540: Recinfo C%ROWTYPE;
541: BEGIN