APPS.AS_LEADS_LOG_PKG dependencies on AS_LEADS_LOG

Line 1: PACKAGE BODY AS_LEADS_LOG_PKG as

1: PACKAGE BODY AS_LEADS_LOG_PKG as
2: /* $Header: asxtllgb.pls 115.10 2004/01/13 10:08:40 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_LEADS_LOG_PKG
5: -- Purpose :

Line 4: -- Package name : AS_LEADS_LOG_PKG

1: PACKAGE BODY AS_LEADS_LOG_PKG as
2: /* $Header: asxtllgb.pls 115.10 2004/01/13 10:08:40 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_LEADS_LOG_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_LEADS_LOG_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_LEADS_LOG_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtllgb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_LOG_ID IN OUT NOCOPY NUMBER,

Line 57: INSERT INTO AS_LEADS_LOG(

53: FETCH C2 INTO px_LOG_ID;
54: CLOSE C2;
55: End If;
56: --dbms_output.put_line('In The insert Row 2');
57: INSERT INTO AS_LEADS_LOG(
58: LOG_ID,
59: LEAD_ID,
60: CREATED_BY,
61: CREATION_DATE,

Line 169: Update AS_LEADS_LOG

165: p_TRIGGER_MODE VARCHAR2)
166: IS
167: BEGIN
168: --dbms_output.put_line('In The Update Row');
169: Update AS_LEADS_LOG
170: SET object_version_number = nvl(object_version_number,0) + 1,
171: LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
172: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
173: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 203: from AS_LEADS_LOG

199: ENDDAY_LOG_FLAG = decode( p_ENDDAY_LOG_FLAG, FND_API.G_MISS_CHAR, ENDDAY_LOG_FLAG, p_ENDDAY_LOG_FLAG),
200: CURRENT_LOG = decode( p_CURRENT_LOG, FND_API.G_MISS_NUM, CURRENT_LOG, p_CURRENT_LOG),
201: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID)
202: where LOG_ID = (SELECT max(log_id)
203: from AS_LEADS_LOG
204: where lead_id = p_OLD_LEAD_ID);
205:
206: If (SQL%NOTFOUND) then
207: --dbms_output.put_line('In AS_LEADS_LOG_PKG after Update statement : Data No found seems');

Line 207: --dbms_output.put_line('In AS_LEADS_LOG_PKG after Update statement : Data No found seems');

203: from AS_LEADS_LOG
204: where lead_id = p_OLD_LEAD_ID);
205:
206: If (SQL%NOTFOUND) then
207: --dbms_output.put_line('In AS_LEADS_LOG_PKG after Update statement : Data No found seems');
208: --dbms_output.put_line('Error Number:'||SQLCODE);
209: --dbms_output.put_line('Error Message:'|| SUBSTR(SQLERRM, 1, 200));
210: RAISE NO_DATA_FOUND;
211:

Line 220: DELETE FROM AS_LEADS_LOG

216: PROCEDURE Delete_Row(
217: p_LOG_ID NUMBER)
218: IS
219: BEGIN
220: DELETE FROM AS_LEADS_LOG
221: WHERE LOG_ID = p_LOG_ID;
222: If (SQL%NOTFOUND) then
223: RAISE NO_DATA_FOUND;
224: End If;

Line 247: FROM AS_LEADS_LOG

243:
244: IS
245: CURSOR C IS
246: SELECT *
247: FROM AS_LEADS_LOG
248: WHERE LOG_ID = p_LOG_ID
249: FOR UPDATE of LOG_ID NOWAIT;
250: Recinfo C%ROWTYPE;
251: BEGIN

Line 312: End AS_LEADS_LOG_PKG;

308: APP_EXCEPTION.RAISE_EXCEPTION;
309: End If;
310: END Lock_Row;
311:
312: End AS_LEADS_LOG_PKG;