PACKAGE: APPS.CSP_RS_CUST_RELATIONS_PKG

Source

1 PACKAGE CSP_RS_CUST_RELATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: csptrcrs.pls 115.5 2002/11/26 06:44:48 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name     : CSP_RS_CUST_RELATIONS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_RS_CUST_RELATION_ID   IN OUT NOCOPY NUMBER,
12           p_RESOURCE_TYPE    VARCHAR2,
13           p_RESOURCE_ID    NUMBER,
14           p_CUSTOMER_ID    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           p_ATTRIBUTE_CATEGORY    VARCHAR2,
21           p_ATTRIBUTE1    VARCHAR2,
22           p_ATTRIBUTE2    VARCHAR2,
23           p_ATTRIBUTE3    VARCHAR2,
24           p_ATTRIBUTE4    VARCHAR2,
25           p_ATTRIBUTE5    VARCHAR2,
26           p_ATTRIBUTE6    VARCHAR2,
27           p_ATTRIBUTE7    VARCHAR2,
28           p_ATTRIBUTE8    VARCHAR2,
29           p_ATTRIBUTE9    VARCHAR2,
30           p_ATTRIBUTE10    VARCHAR2,
31           p_ATTRIBUTE11    VARCHAR2,
32           p_ATTRIBUTE12    VARCHAR2,
33           p_ATTRIBUTE13    VARCHAR2,
34           p_ATTRIBUTE14    VARCHAR2,
35           p_ATTRIBUTE15    VARCHAR2);
36 
37 PROCEDURE Update_Row(
38           p_RS_CUST_RELATION_ID    NUMBER,
39           p_RESOURCE_TYPE    VARCHAR2,
40           p_RESOURCE_ID    NUMBER,
41           p_CUSTOMER_ID    NUMBER,
42           p_CREATED_BY    NUMBER,
43           p_CREATION_DATE    DATE,
44           p_LAST_UPDATED_BY    NUMBER,
45           p_LAST_UPDATE_DATE    DATE,
46           p_LAST_UPDATE_LOGIN    NUMBER,
47           p_ATTRIBUTE_CATEGORY    VARCHAR2,
48           p_ATTRIBUTE1    VARCHAR2,
49           p_ATTRIBUTE2    VARCHAR2,
50           p_ATTRIBUTE3    VARCHAR2,
51           p_ATTRIBUTE4    VARCHAR2,
52           p_ATTRIBUTE5    VARCHAR2,
53           p_ATTRIBUTE6    VARCHAR2,
54           p_ATTRIBUTE7    VARCHAR2,
55           p_ATTRIBUTE8    VARCHAR2,
56           p_ATTRIBUTE9    VARCHAR2,
57           p_ATTRIBUTE10    VARCHAR2,
58           p_ATTRIBUTE11    VARCHAR2,
59           p_ATTRIBUTE12    VARCHAR2,
60           p_ATTRIBUTE13    VARCHAR2,
61           p_ATTRIBUTE14    VARCHAR2,
62           p_ATTRIBUTE15    VARCHAR2);
63 
64 PROCEDURE Lock_Row(
65           p_RS_CUST_RELATION_ID    NUMBER,
66           p_RESOURCE_TYPE    VARCHAR2,
67           p_RESOURCE_ID    NUMBER,
68           p_CUSTOMER_ID    NUMBER,
69           p_CREATED_BY    NUMBER,
70           p_CREATION_DATE    DATE,
71           p_LAST_UPDATED_BY    NUMBER,
72           p_LAST_UPDATE_DATE    DATE,
73           p_LAST_UPDATE_LOGIN    NUMBER,
74           p_ATTRIBUTE_CATEGORY    VARCHAR2,
75           p_ATTRIBUTE1    VARCHAR2,
76           p_ATTRIBUTE2    VARCHAR2,
77           p_ATTRIBUTE3    VARCHAR2,
78           p_ATTRIBUTE4    VARCHAR2,
79           p_ATTRIBUTE5    VARCHAR2,
80           p_ATTRIBUTE6    VARCHAR2,
81           p_ATTRIBUTE7    VARCHAR2,
82           p_ATTRIBUTE8    VARCHAR2,
83           p_ATTRIBUTE9    VARCHAR2,
84           p_ATTRIBUTE10    VARCHAR2,
85           p_ATTRIBUTE11    VARCHAR2,
86           p_ATTRIBUTE12    VARCHAR2,
87           p_ATTRIBUTE13    VARCHAR2,
88           p_ATTRIBUTE14    VARCHAR2,
89           p_ATTRIBUTE15    VARCHAR2);
90 
91 PROCEDURE Delete_Row(
92     p_RS_CUST_RELATION_ID  NUMBER);
93 End CSP_RS_CUST_RELATIONS_PKG;