APPS.AS_FST_SALES_CATEGORIES_PKG dependencies on AS_FST_SALES_CATEGORIES

Line 1: PACKAGE BODY AS_FST_SALES_CATEGORIES_PKG as

1: PACKAGE BODY AS_FST_SALES_CATEGORIES_PKG as
2: /* $Header: asxtfstb.pls 115.5 2003/11/21 08:13:05 sumahali ship $ */
3: -- Start of Comments
4: -- Package name : AS_FST_SALES_CATEGORIES_PKG
5: -- Purpose :

Line 4: -- Package name : AS_FST_SALES_CATEGORIES_PKG

1: PACKAGE BODY AS_FST_SALES_CATEGORIES_PKG as
2: /* $Header: asxtfstb.pls 115.5 2003/11/21 08:13:05 sumahali ship $ */
3: -- Start of Comments
4: -- Package name : AS_FST_SALES_CATEGORIES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 28: CURSOR C2 IS SELECT AS_FST_SALES_CATEGORIES_S.nextval FROM sys.dual;

24: p_START_DATE_ACTIVE DATE,
25: p_END_DATE_ACTIVE DATE)
26:
27: IS
28: CURSOR C2 IS SELECT AS_FST_SALES_CATEGORIES_S.nextval FROM sys.dual;
29: BEGIN
30: If (px_FST_SALES_CATEGORY_ID IS NULL) OR (px_FST_SALES_CATEGORY_ID = FND_API.G_MISS_NUM) then
31: OPEN C2;
32: FETCH C2 INTO px_FST_SALES_CATEGORY_ID;

Line 35: INSERT INTO AS_FST_SALES_CATEGORIES(

31: OPEN C2;
32: FETCH C2 INTO px_FST_SALES_CATEGORY_ID;
33: CLOSE C2;
34: End If;
35: INSERT INTO AS_FST_SALES_CATEGORIES(
36: FST_SALES_CATEGORY_ID,
37: INTEREST_TYPE_ID,
38: PRODUCT_CATEGORY_ID,
39: PRODUCT_CAT_SET_ID,

Line 78: Update AS_FST_SALES_CATEGORIES

74: p_END_DATE_ACTIVE DATE)
75:
76: IS
77: BEGIN
78: Update AS_FST_SALES_CATEGORIES
79: SET
80: PRODUCT_CATEGORY_ID = decode( p_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, p_PRODUCT_CATEGORY_ID),
81: PRODUCT_CAT_SET_ID = decode( p_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, p_PRODUCT_CAT_SET_ID),
82: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),

Line 101: DELETE FROM AS_FST_SALES_CATEGORIES

97: PROCEDURE Delete_Row(
98: p_FST_SALES_CATEGORY_ID NUMBER)
99: IS
100: BEGIN
101: DELETE FROM AS_FST_SALES_CATEGORIES
102: WHERE FST_SALES_CATEGORY_ID = p_FST_SALES_CATEGORY_ID;
103: If (SQL%NOTFOUND) then
104: RAISE NO_DATA_FOUND;
105: End If;

Line 124: FROM AS_FST_SALES_CATEGORIES

120:
121: IS
122: CURSOR C IS
123: SELECT *
124: FROM AS_FST_SALES_CATEGORIES
125: WHERE FST_SALES_CATEGORY_ID = p_FST_SALES_CATEGORY_ID
126: FOR UPDATE of FST_SALES_CATEGORY_ID NOWAIT;
127: Recinfo C%ROWTYPE;
128: BEGIN

Line 177: End AS_FST_SALES_CATEGORIES_PKG;

173: APP_EXCEPTION.RAISE_EXCEPTION;
174: End If;
175: END Lock_Row;
176:
177: End AS_FST_SALES_CATEGORIES_PKG;