APPS.AS_SALES_LEAD_OPP_PKG dependencies on AS_SALES_LEAD_OPPORTUNITY

Line 5: -- Purpose : Table handlers for AS_SALES_LEAD_OPPORTUNITY and

1: PACKAGE BODY AS_SALES_LEAD_OPP_PKG as
2: /* $Header: asxtslob.pls 120.1 2006/02/09 21:11:40 subabu noship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_OPP_PKG
5: -- Purpose : Table handlers for AS_SALES_LEAD_OPPORTUNITY and
6: -- AS_SALES_LEAD_OPP_LINES
7: -- NOTE :
8: -- History : 04/09/2001 FFANG Created
9: --

Line 56: INSERT INTO AS_SALES_LEAD_OPPORTUNITY(

52: OPEN C2;
53: FETCH C2 INTO px_LEAD_OPPORTUNITY_ID;
54: CLOSE C2;
55: End If;
56: INSERT INTO AS_SALES_LEAD_OPPORTUNITY(
57: LEAD_OPPORTUNITY_ID,
58: SALES_LEAD_ID,
59: OPPORTUNITY_ID,
60: LAST_UPDATE_DATE,

Line 153: Update AS_SALES_LEAD_OPPORTUNITY

149: -- p_SECURITY_GROUP_ID NUMBER)
150:
151: IS
152: BEGIN
153: Update AS_SALES_LEAD_OPPORTUNITY
154: SET
155: LEAD_OPPORTUNITY_ID = decode( p_LEAD_OPPORTUNITY_ID, FND_API.G_MISS_NUM,
156: LEAD_OPPORTUNITY_ID, p_LEAD_OPPORTUNITY_ID),
157: SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,

Line 226: DELETE FROM AS_SALES_LEAD_OPPORTUNITY

222: PROCEDURE LEAD_OPPORTUNITY_Delete_Row(
223: p_LEAD_OPPORTUNITY_ID NUMBER)
224: IS
225: BEGIN
226: DELETE FROM AS_SALES_LEAD_OPPORTUNITY
227: WHERE LEAD_OPPORTUNITY_ID = p_LEAD_OPPORTUNITY_ID;
228: If (SQL%NOTFOUND) then
229: RAISE NO_DATA_FOUND;
230: End If;

Line 267: FROM AS_SALES_LEAD_OPPORTUNITY

263:
264: IS
265: CURSOR C IS
266: SELECT *
267: FROM AS_SALES_LEAD_OPPORTUNITY
268: WHERE LEAD_OPPORTUNITY_ID = p_LEAD_OPPORTUNITY_ID
269: FOR UPDATE of LEAD_OPPORTUNITY_ID NOWAIT;
270: Recinfo C%ROWTYPE;
271: BEGIN