APPS.AS_SALES_LEAD_OPP_PKG dependencies on AS_SALES_LEAD_OPP_LINES

Line 6: -- AS_SALES_LEAD_OPP_LINES

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: --
10: -- End of Comments

Line 406: CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_LINES_S.nextval FROM sys.dual;

402: p_ATTRIBUTE15 VARCHAR2)
403: -- p_SECURITY_GROUP_ID NUMBER)
404:
405: IS
406: CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_LINES_S.nextval FROM sys.dual;
407: BEGIN
408: If (px_LEAD_OPP_LINE_ID IS NULL) OR (px_LEAD_OPP_LINE_ID = FND_API.G_MISS_NUM
409: ) then
410: OPEN C2;

Line 415: INSERT INTO AS_SALES_LEAD_OPP_LINES(

411: FETCH C2 INTO px_LEAD_OPP_LINE_ID;
412: CLOSE C2;
413: End If;
414:
415: INSERT INTO AS_SALES_LEAD_OPP_LINES(
416: LEAD_OPP_LINE_ID,
417: SALES_LEAD_LINE_ID,
418: OPP_LINE_ID,
419: LAST_UPDATE_DATE,

Line 519: Update AS_SALES_LEAD_OPP_LINES

515: -- p_SECURITY_GROUP_ID NUMBER)
516:
517: IS
518: BEGIN
519: Update AS_SALES_LEAD_OPP_LINES
520: SET
521: SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,
522: SALES_LEAD_LINE_ID, p_SALES_LEAD_LINE_ID),
523: OPP_LINE_ID = decode( p_OPP_LINE_ID, FND_API.G_MISS_NUM, OPP_LINE_ID,

Line 590: DELETE FROM AS_SALES_LEAD_OPP_LINES

586: PROCEDURE LEAD_OPP_LINES_Delete_Row(
587: p_LEAD_OPP_LINE_ID NUMBER)
588: IS
589: BEGIN
590: DELETE FROM AS_SALES_LEAD_OPP_LINES
591: WHERE LEAD_OPP_LINE_ID = p_LEAD_OPP_LINE_ID;
592: If (SQL%NOTFOUND) then
593: RAISE NO_DATA_FOUND;
594: End If;

Line 631: FROM AS_SALES_LEAD_OPP_LINES

627:
628: IS
629: CURSOR C IS
630: SELECT *
631: FROM AS_SALES_LEAD_OPP_LINES
632: WHERE LEAD_OPP_LINE_ID = p_LEAD_OPP_LINE_ID
633: FOR UPDATE of LEAD_OPP_LINE_ID NOWAIT;
634: Recinfo C%ROWTYPE;
635: BEGIN