[Home] [Help]
PACKAGE: APPS.CSP_POPULATION_CHANGES_PKG
Source
1 PACKAGE CSP_POPULATION_CHANGES_PKG AUTHID CURRENT_USER as
2 /* $Header: csptppcs.pls 120.2 2005/12/16 10:08:18 phegde noship $ */
3 -- Start of Comments
4 -- Package name : CSP_POPULATION_CHANGES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_POPULATION_CHANGES_ID IN OUT NOCOPY NUMBER,
12 p_ORGANIZATION_ID NUMBER,
13 -- p_INVENTORY_ITEM_ID NUMBER,
14 p_START_DATE DATE,
15 p_END_DATE DATE,
16 p_POPULATION_CHANGE NUMBER,
17 p_CREATION_DATE DATE,
18 p_CREATED_BY NUMBER,
19 p_LAST_UPDATE_DATE DATE,
20 p_LAST_UPDATED_BY NUMBER,
21 p_LAST_UPDATE_LOGIN NUMBER,
22 p_PRODUCT_ID NUMBER );
23
24 PROCEDURE Update_Row(
25 p_POPULATION_CHANGES_ID NUMBER,
26 p_ORGANIZATION_ID NUMBER,
27 --p_INVENTORY_ITEM_ID NUMBER,
28 p_START_DATE DATE,
29 p_END_DATE DATE,
30 p_POPULATION_CHANGE NUMBER,
31 p_CREATION_DATE DATE,
32 p_CREATED_BY NUMBER,
33 p_LAST_UPDATE_DATE DATE,
34 p_LAST_UPDATED_BY NUMBER,
35 p_LAST_UPDATE_LOGIN NUMBER,
36 p_PRODUCT_ID NUMBER );
37
38 PROCEDURE Lock_Row(
39 p_POPULATION_CHANGES_ID NUMBER,
40 p_ORGANIZATION_ID NUMBER,
41 --p_INVENTORY_ITEM_ID NUMBER,
42 p_START_DATE DATE,
43 p_END_DATE DATE,
44 p_POPULATION_CHANGE NUMBER,
45 p_CREATION_DATE DATE,
46 p_CREATED_BY NUMBER,
47 p_LAST_UPDATE_DATE DATE,
48 p_LAST_UPDATED_BY NUMBER,
49 p_LAST_UPDATE_LOGIN NUMBER,
50 p_PRODUCT_ID NUMBER);
51
52 PROCEDURE Delete_Row(
53 p_POPULATION_CHANGES_ID NUMBER);
54 End CSP_POPULATION_CHANGES_PKG;