1 PACKAGE CSP_PRODUCT_POPULATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: csptprps.pls 115.3 2002/11/26 07:27:50 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_PRODUCT_POPULATIONS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_PRODUCT_POPULATION_ID IN OUT NOCOPY NUMBER
12 ,p_PLANNING_PARAMETERS_ID NUMBER
13 ,p_PRODUCT_ID NUMBER
14 ,p_CURRENT_POPULATION NUMBER
15 ,p_POPULATION_CHANGE NUMBER
16 ,p_LAST_UPDATE_DATE DATE
17 ,p_LAST_UPDATED_BY NUMBER
18 ,p_CREATION_DATE DATE
19 ,p_CREATED_BY NUMBER
20 ,p_LAST_UPDATE_LOGIN NUMBER
21 );
22 PROCEDURE Update_Row(
23 p_PRODUCT_POPULATION_ID NUMBER
24 ,p_PLANNING_PARAMETERS_ID NUMBER
25 ,p_PRODUCT_ID NUMBER
26 ,p_CURRENT_POPULATION NUMBER
27 ,p_POPULATION_CHANGE NUMBER
28 ,p_LAST_UPDATE_DATE DATE
29 ,p_LAST_UPDATED_BY NUMBER
30 ,p_CREATION_DATE DATE
31 ,p_CREATED_BY NUMBER
32 ,p_LAST_UPDATE_LOGIN NUMBER
33 );
34 PROCEDURE Lock_Row(
35 p_PRODUCT_POPULATION_ID NUMBER
36 ,p_PLANNING_PARAMETERS_ID NUMBER
37 ,p_PRODUCT_ID NUMBER
38 ,p_CURRENT_POPULATION NUMBER
39 ,p_POPULATION_CHANGE NUMBER
40 ,p_LAST_UPDATE_DATE DATE
41 ,p_LAST_UPDATED_BY NUMBER
42 ,p_CREATION_DATE DATE
43 ,p_CREATED_BY NUMBER
44 ,p_LAST_UPDATE_LOGIN NUMBER
45 );
46 PROCEDURE Delete_Row(
47 p_PRODUCT_POPULATION_ID NUMBER);
48 End CSP_PRODUCT_POPULATIONS_PKG;
[Home] [Help]