APPS.AS_SALES_LEAD_LINES_PKG dependencies on AS_SALES_LEAD_LINES

Line 1: PACKAGE BODY AS_SALES_LEAD_LINES_PKG as

1: PACKAGE BODY AS_SALES_LEAD_LINES_PKG as
2: /* $Header: asxtsllb.pls 115.9 2004/04/14 20:39:39 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_LINES_PKG
5: -- Purpose : Sales lead lines table handlers

Line 4: -- Package name : AS_SALES_LEAD_LINES_PKG

1: PACKAGE BODY AS_SALES_LEAD_LINES_PKG as
2: /* $Header: asxtsllb.pls 115.9 2004/04/14 20:39:39 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_LINES_PKG
5: -- Purpose : Sales lead lines table handlers
6: -- NOTE :
7: -- History : 04/09/2001 FFANG Created
8: --

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_LINES_PKG';

8: --
9: -- End of Comments
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_LINES_PKG';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtsllb.pls';
14:
15:
16: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 70: CURSOR C2 IS SELECT AS_SALES_LEAD_LINES_S.nextval FROM sys.dual;

66: p_OFFER_ID NUMBER)
67: -- p_SECURITY_GROUP_ID NUMBER)
68:
69: IS
70: CURSOR C2 IS SELECT AS_SALES_LEAD_LINES_S.nextval FROM sys.dual;
71: BEGIN
72: If (px_sales_lead_line_id IS NULL)
73: OR (px_SALES_LEAD_LINE_ID = FND_API.G_MISS_NUM)
74: Then

Line 79: INSERT INTO AS_SALES_LEAD_LINES(

75: OPEN C2;
76: FETCH C2 INTO px_sales_lead_line_id;
77: CLOSE C2;
78: End If;
79: INSERT INTO AS_SALES_LEAD_LINES(
80: SALES_LEAD_LINE_ID,
81: LAST_UPDATE_DATE,
82: LAST_UPDATED_BY,
83: CREATION_DATE,

Line 234: from AS_SALES_LEAD_LINES

230: /*l_obj_verno number;
231:
232: cursor c_obj_verno is
233: select object_version_number
234: from AS_SALES_LEAD_LINES
235: where SALES_LEAD_LINE_ID = p_SALES_LEAD_LINE_ID;
236: */
237: BEGIN
238: Update AS_SALES_LEAD_LINES

Line 238: Update AS_SALES_LEAD_LINES

234: from AS_SALES_LEAD_LINES
235: where SALES_LEAD_LINE_ID = p_SALES_LEAD_LINE_ID;
236: */
237: BEGIN
238: Update AS_SALES_LEAD_LINES
239: SET
240: SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,
241: SALES_LEAD_LINE_ID, p_SALES_LEAD_LINE_ID),
242: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,

Line 344: update as_sales_lead_lines

340: open c_obj_verno;
341: fetch c_obj_verno into l_obj_verno;
342: close c_obj_verno;
343:
344: update as_sales_lead_lines
345: set object_version_number = decode(l_obj_verno, null, 1, l_obj_verno+1)
346: where sales_lead_line_id = p_sales_lead_line_id;
347: */
348: If (SQL%NOTFOUND) then

Line 357: DELETE FROM AS_SALES_LEAD_LINES

353:
354: PROCEDURE Sales_Lead_Line_Delete_Row( p_sales_lead_line_id NUMBER)
355: IS
356: BEGIN
357: DELETE FROM AS_SALES_LEAD_LINES
358: WHERE sales_lead_line_id = p_sales_lead_line_id;
359: If (SQL%NOTFOUND) then
360: RAISE NO_DATA_FOUND;
361: End If;

Line 416: FROM AS_SALES_LEAD_LINES

412:
413: IS
414: CURSOR C IS
415: SELECT *
416: FROM AS_SALES_LEAD_LINES
417: WHERE sales_lead_line_id = p_sales_lead_line_id
418: FOR UPDATE of sales_lead_line_id NOWAIT;
419: Recinfo C%ROWTYPE;
420: BEGIN

Line 571: End AS_SALES_LEAD_LINES_PKG;

567: End If;
568: END Sales_Lead_Line_Lock_Row;
569:
570:
571: End AS_SALES_LEAD_LINES_PKG;