[Home] [Help]
PACKAGE: APPS.AS_PE_INT_CATEGORIES_PKG
Source
1 PACKAGE AS_PE_INT_CATEGORIES_PKG as
2 /* $Header: asxtpeis.pls 120.0 2005/06/02 17:23:01 appldev noship $ */
3 -- Start of Comments
4 -- Package name : AS_PE_INT_CATEGORIES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_PE_INT_CATEGORY_ID IN OUT NOCOPY NUMBER,
12 p_CREATED_BY NUMBER,
13 p_CREATION_DATE DATE,
14 p_LAST_UPDATED_BY NUMBER,
15 p_LAST_UPDATE_DATE DATE,
16 p_LAST_UPDATE_LOGIN NUMBER,
17 p_REQUEST_ID NUMBER,
18 p_PROGRAM_APPLICATION_ID NUMBER,
19 p_PROGRAM_ID NUMBER,
20 p_PROGRAM_UPDATE_DATE DATE,
21 p_QUOTA_ID NUMBER,
22 -- mapping type is obsoleted during uptake of product catalog
23 --p_MAPPING_TYPE VARCHAR2,
24 p_PRODUCT_CATEGORY_ID NUMBER,
25 p_PRODUCT_CAT_SET_ID NUMBER);
26
27 PROCEDURE Update_Row(
28 p_PE_INT_CATEGORY_ID NUMBER,
29 p_CREATED_BY NUMBER,
30 p_CREATION_DATE DATE,
31 p_LAST_UPDATED_BY NUMBER,
32 p_LAST_UPDATE_DATE DATE,
33 p_LAST_UPDATE_LOGIN NUMBER,
34 p_REQUEST_ID NUMBER,
35 p_PROGRAM_APPLICATION_ID NUMBER,
36 p_PROGRAM_ID NUMBER,
37 p_PROGRAM_UPDATE_DATE DATE,
38 p_QUOTA_ID NUMBER,
39 -- mapping type is obsoleted during uptake of product catalog
40 --p_MAPPING_TYPE VARCHAR2,
41 p_PRODUCT_CATEGORY_ID NUMBER,
42 p_PRODUCT_CAT_SET_ID NUMBER);
43
44 PROCEDURE Lock_Row(
45 p_PE_INT_CATEGORY_ID NUMBER,
46 p_CREATED_BY NUMBER,
47 p_CREATION_DATE DATE,
48 p_LAST_UPDATED_BY NUMBER,
49 p_LAST_UPDATE_DATE DATE,
50 p_LAST_UPDATE_LOGIN NUMBER,
51 p_REQUEST_ID NUMBER,
52 p_PROGRAM_APPLICATION_ID NUMBER,
53 p_PROGRAM_ID NUMBER,
54 p_PROGRAM_UPDATE_DATE DATE,
55 p_QUOTA_ID NUMBER,
56 -- mapping type is obsoleted during uptake of product catalog
57 --p_MAPPING_TYPE VARCHAR2,
58 p_PRODUCT_CATEGORY_ID NUMBER,
59 p_PRODUCT_CAT_SET_ID NUMBER);
60
61 PROCEDURE Delete_Row(
62 p_PE_INT_CATEGORY_ID NUMBER);
63 End AS_PE_INT_CATEGORIES_PKG;