[Home] [Help]
PACKAGE: APPS.CSP_PART_PRIORITIES_PKG
Source
1 PACKAGE CSP_PART_PRIORITIES_PKG AUTHID CURRENT_USER as
2 /* $Header: csptpaps.pls 115.0 2003/06/10 19:48:13 ajosephg noship $ */
3 -- Start of Comments
4 -- Package name : CSP_PART_PRIORITIES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_PART_PRIORITY_ID IN OUT NOCOPY NUMBER,
12 p_PRIORITY VARCHAR2,
13 p_LOWER_RANGE NUMBER,
14 p_UPPER_RANGE 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
21 PROCEDURE Update_Row(
22 p_PART_PRIORITY_ID NUMBER,
23 p_PRIORITY VARCHAR2,
24 p_LOWER_RANGE NUMBER,
25 p_UPPER_RANGE NUMBER,
26 p_CREATED_BY NUMBER,
27 p_CREATION_DATE DATE,
28 p_LAST_UPDATED_BY NUMBER,
29 p_LAST_UPDATE_DATE DATE,
30 p_LAST_UPDATE_LOGIN NUMBER);
31
32 PROCEDURE Lock_Row(
33 p_PART_PRIORITY_ID NUMBER,
34 p_PRIORITY VARCHAR2,
35 p_LOWER_RANGE NUMBER,
36 p_UPPER_RANGE NUMBER,
37 p_CREATED_BY NUMBER,
38 p_CREATION_DATE DATE,
39 p_LAST_UPDATED_BY NUMBER,
40 p_LAST_UPDATE_DATE DATE,
41 p_LAST_UPDATE_LOGIN NUMBER);
42
43 PROCEDURE Delete_Row(
44 p_PART_PRIORITY_ID NUMBER);
45 End CSP_PART_PRIORITIES_PKG;