APPS.CSP_DEDICATED_SITES_PKG dependencies on CSP_DEDICATED_SITES

Line 1: PACKAGE BODY CSP_DEDICATED_SITES_PKG as

1: PACKAGE BODY CSP_DEDICATED_SITES_PKG as
2: /* $Header: csptdsib.pls 120.1 2010/12/03 19:58:24 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_DEDICATED_SITES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_DEDICATED_SITES_PKG

1: PACKAGE BODY CSP_DEDICATED_SITES_PKG as
2: /* $Header: csptdsib.pls 120.1 2010/12/03 19:58:24 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_DEDICATED_SITES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_DEDICATED_SITES_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_DEDICATED_SITES_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptdsib.pls';
12:
13: PROCEDURE Insert_Row(
14: px_DEDICATED_SITES_ID NUMBER

Line 26: CURSOR C2 IS SELECT csp_dedicated_sites_S1.nextval FROM sys.dual;

22: )
23: IS
24:
25: p_DEDICATED_SITES_ID Number;
26: CURSOR C2 IS SELECT csp_dedicated_sites_S1.nextval FROM sys.dual;
27: BEGIN
28:
29: If (px_DEDICATED_SITES_ID IS NULL) OR (px_DEDICATED_SITES_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;

Line 36: INSERT INTO csp_dedicated_sites(

32: CLOSE C2;
33: End If;
34:
35:
36: INSERT INTO csp_dedicated_sites(
37: DEDICATED_SITES_ID
38: ,PLANNING_PARAMETERS_ID
39: ,PARTY_SITE_ID
40: ,CREATED_BY

Line 69: Update csp_dedicated_sites

65: ,p_LAST_UPDATE_LOGIN NUMBER
66: ) IS
67:
68: BEGIN
69: Update csp_dedicated_sites
70: SET
71: DEDICATED_SITES_ID = decode( p_DEDICATED_SITES_ID, FND_API.G_MISS_NUM, DEDICATED_SITES_ID, p_DEDICATED_SITES_ID)
72: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)
73: ,PARTY_SITE_ID = decode( p_PARTY_SITE_ID, FND_API.G_MISS_NUM, PARTY_SITE_ID, p_PARTY_SITE_ID)

Line 94: DELETE FROM csp_dedicated_sites

90: ,p_PARTY_SITE_ID NUMBER
91: )
92: IS
93: BEGIN
94: DELETE FROM csp_dedicated_sites
95: where DEDICATED_SITES_ID = p_DEDICATED_SITES_ID
96: AND PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID
97: AND PARTY_SITE_ID = P_PARTY_SITE_ID;
98:

Line 117: FROM csp_dedicated_sites

113: )
114: IS
115: CURSOR C IS
116: SELECT *
117: FROM csp_dedicated_sites
118: WHERE PARTY_SITE_ID = p_PARTY_SITE_ID
119: FOR UPDATE of PARTY_SITE_ID NOWAIT;
120: Recinfo C%ROWTYPE;
121: BEGIN

Line 159: End CSP_DEDICATED_SITES_PKG;

155: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: End If;
158: END Lock_Row;
159: End CSP_DEDICATED_SITES_PKG;