APPS.AS_PE_INT_CATEGORIES_PKG dependencies on AS_PE_INT_CATEGORIES

Line 1: PACKAGE BODY AS_PE_INT_CATEGORIES_PKG as

1: PACKAGE BODY AS_PE_INT_CATEGORIES_PKG as
2: /* $Header: asxtpeib.pls 120.0 2005/06/02 17:18:19 appldev noship $ */
3: -- Start of Comments
4: -- Package name : AS_PE_INT_CATEGORIES_PKG
5: -- Purpose :

Line 4: -- Package name : AS_PE_INT_CATEGORIES_PKG

1: PACKAGE BODY AS_PE_INT_CATEGORIES_PKG as
2: /* $Header: asxtpeib.pls 120.0 2005/06/02 17:18:19 appldev noship $ */
3: -- Start of Comments
4: -- Package name : AS_PE_INT_CATEGORIES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 29: CURSOR C2 IS SELECT AS_PE_INT_CATEGORIES_S.nextval FROM sys.dual;

25: p_QUOTA_ID NUMBER,
26: p_PRODUCT_CATEGORY_ID NUMBER,
27: p_PRODUCT_CAT_SET_ID NUMBER)
28: IS
29: CURSOR C2 IS SELECT AS_PE_INT_CATEGORIES_S.nextval FROM sys.dual;
30: BEGIN
31: If (px_PE_INT_CATEGORY_ID IS NULL) OR (px_PE_INT_CATEGORY_ID = FND_API.G_MISS_NUM) then
32: OPEN C2;
33: FETCH C2 INTO px_PE_INT_CATEGORY_ID;

Line 36: INSERT INTO AS_PE_INT_CATEGORIES(

32: OPEN C2;
33: FETCH C2 INTO px_PE_INT_CATEGORY_ID;
34: CLOSE C2;
35: End If;
36: INSERT INTO AS_PE_INT_CATEGORIES(
37: PE_INT_CATEGORY_ID,
38: CREATED_BY,
39: CREATION_DATE,
40: LAST_UPDATED_BY,

Line 84: Update AS_PE_INT_CATEGORIES

80: p_PRODUCT_CATEGORY_ID NUMBER,
81: p_PRODUCT_CAT_SET_ID NUMBER)
82: IS
83: BEGIN
84: Update AS_PE_INT_CATEGORIES
85: SET
86: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
87: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
88: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 109: DELETE FROM AS_PE_INT_CATEGORIES

105: PROCEDURE Delete_Row(
106: p_PE_INT_CATEGORY_ID NUMBER)
107: IS
108: BEGIN
109: DELETE FROM AS_PE_INT_CATEGORIES
110: WHERE PE_INT_CATEGORY_ID = p_PE_INT_CATEGORY_ID;
111: If (SQL%NOTFOUND) then
112: RAISE NO_DATA_FOUND;
113: End If;

Line 133: FROM AS_PE_INT_CATEGORIES

129: p_PRODUCT_CAT_SET_ID NUMBER)
130: IS
131: CURSOR C IS
132: SELECT *
133: FROM AS_PE_INT_CATEGORIES
134: WHERE PE_INT_CATEGORY_ID = p_PE_INT_CATEGORY_ID
135: FOR UPDATE of PE_INT_CATEGORY_ID NOWAIT;
136: Recinfo C%ROWTYPE;
137: BEGIN

Line 192: End AS_PE_INT_CATEGORIES_PKG;

188: APP_EXCEPTION.RAISE_EXCEPTION;
189: End If;
190: END Lock_Row;
191:
192: End AS_PE_INT_CATEGORIES_PKG;