DBA Data[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;