APPS.CSP_RS_CUST_RELATIONS_PKG dependencies on CSP_RS_CUST_RELATIONS

Line 1: PACKAGE BODY CSP_RS_CUST_RELATIONS_PKG as

1: PACKAGE BODY CSP_RS_CUST_RELATIONS_PKG as
2: /* $Header: csptrcrb.pls 120.0.12010000.3 2009/10/01 23:15:38 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_RS_CUST_RELATIONS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_RS_CUST_RELATIONS_PKG

1: PACKAGE BODY CSP_RS_CUST_RELATIONS_PKG as
2: /* $Header: csptrcrb.pls 120.0.12010000.3 2009/10/01 23:15:38 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_RS_CUST_RELATIONS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_RS_CUST_RELATIONS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_RS_CUST_RELATIONS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptrcrb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_RS_CUST_RELATION_ID IN OUT NOCOPY NUMBER,

Line 41: CURSOR C2 IS SELECT CSP_RS_CUST_RELATIONS_S1.nextval FROM sys.dual;

37: p_ATTRIBUTE13 VARCHAR2,
38: p_ATTRIBUTE14 VARCHAR2,
39: p_ATTRIBUTE15 VARCHAR2)
40: IS
41: CURSOR C2 IS SELECT CSP_RS_CUST_RELATIONS_S1.nextval FROM sys.dual;
42: BEGIN
43: If (px_RS_CUST_RELATION_ID IS NULL) OR (px_RS_CUST_RELATION_ID = FND_API.G_MISS_NUM) then
44: OPEN C2;
45: FETCH C2 INTO px_RS_CUST_RELATION_ID;

Line 48: INSERT INTO CSP_RS_CUST_RELATIONS(

44: OPEN C2;
45: FETCH C2 INTO px_RS_CUST_RELATION_ID;
46: CLOSE C2;
47: End If;
48: INSERT INTO CSP_RS_CUST_RELATIONS(
49: RS_CUST_RELATION_ID,
50: RESOURCE_TYPE,
51: RESOURCE_ID,
52: CUSTOMER_ID,

Line 131: Update CSP_RS_CUST_RELATIONS

127: p_ATTRIBUTE14 VARCHAR2,
128: p_ATTRIBUTE15 VARCHAR2)
129: IS
130: BEGIN
131: Update CSP_RS_CUST_RELATIONS
132: SET
133: RESOURCE_TYPE = decode( p_RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, p_RESOURCE_TYPE),
134: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
135: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),

Line 169: DELETE FROM CSP_RS_CUST_RELATIONS

165: PROCEDURE Delete_Row(
166: p_RS_CUST_RELATION_ID NUMBER)
167: IS
168: BEGIN
169: DELETE FROM CSP_RS_CUST_RELATIONS
170: WHERE RS_CUST_RELATION_ID = p_RS_CUST_RELATION_ID;
171: If (SQL%NOTFOUND) then
172: RAISE NO_DATA_FOUND;
173: End If;

Line 205: FROM CSP_RS_CUST_RELATIONS

201: p_ATTRIBUTE15 VARCHAR2)
202: IS
203: CURSOR C IS
204: SELECT *
205: FROM CSP_RS_CUST_RELATIONS
206: WHERE RS_CUST_RELATION_ID = p_RS_CUST_RELATION_ID
207: FOR UPDATE of RS_CUST_RELATION_ID NOWAIT;
208: Recinfo C%ROWTYPE;
209: BEGIN

Line 300: End CSP_RS_CUST_RELATIONS_PKG;

296: APP_EXCEPTION.RAISE_EXCEPTION;
297: End If;
298: END Lock_Row;
299:
300: End CSP_RS_CUST_RELATIONS_PKG;