PACKAGE: APPS.AS_PE_INT_CATEGORIES_PKG

Source

1 PACKAGE AS_PE_INT_CATEGORIES_PKG AUTHID CURRENT_USER 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;