APPS.AS_LEAD_ORDERS_PKG dependencies on AS_LEAD_ORDERS

Line 1: PACKAGE BODY AS_LEAD_ORDERS_PKG as

1: PACKAGE BODY AS_LEAD_ORDERS_PKG as
2: /* $Header: asxtordb.pls 115.5 2002/12/13 11:57:43 nkamble ship $ */
3: -- Start of Comments
4: -- Package name : AS_LEAD_ORDERS_PKG
5: -- Purpose :

Line 4: -- Package name : AS_LEAD_ORDERS_PKG

1: PACKAGE BODY AS_LEAD_ORDERS_PKG as
2: /* $Header: asxtordb.pls 115.5 2002/12/13 11:57:43 nkamble ship $ */
3: -- Start of Comments
4: -- Package name : AS_LEAD_ORDERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 47: CURSOR C2 IS SELECT AS_LEAD_ORDERS_S.nextval FROM sys.dual;

43: -- p_SECURITY_GROUP_ID NUMBER
44: )
45:
46: IS
47: CURSOR C2 IS SELECT AS_LEAD_ORDERS_S.nextval FROM sys.dual;
48: BEGIN
49: If (px_LEAD_ORDER_ID IS NULL) OR (px_LEAD_ORDER_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_LEAD_ORDER_ID;

Line 54: INSERT INTO AS_LEAD_ORDERS(

50: OPEN C2;
51: FETCH C2 INTO px_LEAD_ORDER_ID;
52: CLOSE C2;
53: End If;
54: INSERT INTO AS_LEAD_ORDERS(
55: LEAD_ORDER_ID,
56: LAST_UPDATE_DATE,
57: LAST_UPDATED_BY,
58: CREATION_DATE,

Line 151: Update AS_LEAD_ORDERS

147: )
148:
149: IS
150: BEGIN
151: Update AS_LEAD_ORDERS
152: SET
153: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
154: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
155: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 193: DELETE FROM AS_LEAD_ORDERS

189: PROCEDURE Delete_Row(
190: p_LEAD_ORDER_ID NUMBER)
191: IS
192: BEGIN
193: DELETE FROM AS_LEAD_ORDERS
194: WHERE LEAD_ORDER_ID = p_LEAD_ORDER_ID;
195: If (SQL%NOTFOUND) then
196: RAISE NO_DATA_FOUND;
197: End If;

Line 235: FROM AS_LEAD_ORDERS

231:
232: IS
233: CURSOR C IS
234: SELECT *
235: FROM AS_LEAD_ORDERS
236: WHERE LEAD_ORDER_ID = p_LEAD_ORDER_ID
237: FOR UPDATE of LEAD_ORDER_ID NOWAIT;
238: Recinfo C%ROWTYPE;
239: BEGIN

Line 342: End AS_LEAD_ORDERS_PKG;

338: APP_EXCEPTION.RAISE_EXCEPTION;
339: End If;
340: END Lock_Row;
341:
342: End AS_LEAD_ORDERS_PKG;