PACKAGE: APPS.AS_FST_SALES_CATEGORIES_PKG

Source

1 PACKAGE AS_FST_SALES_CATEGORIES_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtfsts.pls 115.5 2003/11/21 08:13:06 sumahali ship $ */
3 -- Start of Comments
4 -- Package name     : AS_FST_SALES_CATEGORIES_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_FST_SALES_CATEGORY_ID   IN OUT NOCOPY NUMBER,
12           p_PRODUCT_CATEGORY_ID    NUMBER,
13           p_PRODUCT_CAT_SET_ID    NUMBER,
14           p_FORECAST_CATEGORY_ID    NUMBER,
15           p_CREATED_BY    NUMBER,
16           p_CREATION_DATE    DATE,
17           p_LAST_UPDATED_BY    NUMBER,
18           p_LAST_UPDATE_DATE    DATE,
19           p_LAST_UPDATE_LOGIN    NUMBER,
20           p_START_DATE_ACTIVE    DATE,
21           p_END_DATE_ACTIVE    DATE);
22 
23 PROCEDURE Update_Row(
24           p_FST_SALES_CATEGORY_ID    NUMBER,
25           p_PRODUCT_CATEGORY_ID    NUMBER,
26           p_PRODUCT_CAT_SET_ID    NUMBER,
27           p_FORECAST_CATEGORY_ID    NUMBER,
28           p_CREATED_BY    NUMBER,
29           p_CREATION_DATE    DATE,
30           p_LAST_UPDATED_BY    NUMBER,
31           p_LAST_UPDATE_DATE    DATE,
32           p_LAST_UPDATE_LOGIN    NUMBER,
33           p_START_DATE_ACTIVE    DATE,
34           p_END_DATE_ACTIVE    DATE);
35 
36 PROCEDURE Lock_Row(
37           p_FST_SALES_CATEGORY_ID    NUMBER,
38           p_PRODUCT_CATEGORY_ID    NUMBER,
39           p_PRODUCT_CAT_SET_ID    NUMBER,
40           p_FORECAST_CATEGORY_ID    NUMBER,
41           p_CREATED_BY    NUMBER,
42           p_CREATION_DATE    DATE,
43           p_LAST_UPDATED_BY    NUMBER,
44           p_LAST_UPDATE_DATE    DATE,
45           p_LAST_UPDATE_LOGIN    NUMBER,
46           p_START_DATE_ACTIVE    DATE,
47           p_END_DATE_ACTIVE    DATE);
48 
49 PROCEDURE Delete_Row(
50     p_FST_SALES_CATEGORY_ID  NUMBER);
51 End AS_FST_SALES_CATEGORIES_PKG;