APPS.AS_SALES_LEADS_PKG dependencies on AS_SALES_LEADS

Line 1: PACKAGE BODY AS_SALES_LEADS_PKG as

1: PACKAGE BODY AS_SALES_LEADS_PKG as
2: /* $Header: asxtslmb.pls 115.34 2004/04/14 20:39:28 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEADS_PKG
5: -- Purpose : Sales leads table handlers

Line 4: -- Package name : AS_SALES_LEADS_PKG

1: PACKAGE BODY AS_SALES_LEADS_PKG as
2: /* $Header: asxtslmb.pls 115.34 2004/04/14 20:39:28 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEADS_PKG
5: -- Purpose : Sales leads table handlers
6: -- NOTE :
7: -- History : 06/05/2000 FFANG Generated by Table Handler Generater.
8: -- 06/06/2000 FFANG Modified according to data schema

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PKG';

13: --
14: -- End of Comments
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEADS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtslmb.pls';
19:
20: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 139: CURSOR C2 IS SELECT AS_SALES_LEADS_S.nextval FROM sys.dual;

135:
136:
137: )
138: IS
139: CURSOR C2 IS SELECT AS_SALES_LEADS_S.nextval FROM sys.dual;
140: BEGIN
141: If (px_SALES_LEAD_ID IS NULL) OR (px_SALES_LEAD_ID = FND_API.G_MISS_NUM) then
142: OPEN C2;
143: FETCH C2 INTO px_SALES_LEAD_ID;

Line 148: INSERT INTO AS_SALES_LEADS(

144: CLOSE C2;
145: End If;
146:
147:
148: INSERT INTO AS_SALES_LEADS(
149: SALES_LEAD_ID,
150: LAST_UPDATE_DATE,
151: LAST_UPDATED_BY,
152: CREATION_DATE,

Line 529: from as_sales_leads

525: l_obj_verno number;
526:
527: cursor c_obj_verno is
528: select object_version_number
529: from as_sales_leads
530: where sales_lead_id = p_SALES_LEAD_ID;
531: */
532: BEGIN
533: Update AS_SALES_LEADS

Line 533: Update AS_SALES_LEADS

529: from as_sales_leads
530: where sales_lead_id = p_SALES_LEAD_ID;
531: */
532: BEGIN
533: Update AS_SALES_LEADS
534: SET
535: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
536: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
537: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

Line 831: update as_sales_leads

827: /* open c_obj_verno;
828: fetch c_obj_verno into l_obj_verno;
829: close c_obj_verno;
830:
831: update as_sales_leads
832: set object_version_number = decode(l_obj_verno, null, 1, l_obj_verno+1)
833: where sales_lead_id = p_SALES_LEAD_ID;
834: */
835: If (SQL%NOTFOUND) then

Line 964: FROM AS_SALES_LEADS

960:
961: IS
962: CURSOR C IS
963: SELECT *
964: FROM AS_SALES_LEADS
965: WHERE SALES_LEAD_ID = p_SALES_LEAD_ID
966: FOR UPDATE of SALES_LEAD_ID NOWAIT;
967: Recinfo C%ROWTYPE;
968: BEGIN

Line 1356: End AS_SALES_LEADS_PKG;

1352: End If;
1353: END Sales_Lead_Lock_Row;
1354:
1355:
1356: End AS_SALES_LEADS_PKG;