APPS.CSP_PLANNING_PARAMETERS_PKG dependencies on CSP_PLANNING_PARAMETERS

Line 1: PACKAGE BODY CSP_PLANNING_PARAMETERS_PKG as

1: PACKAGE BODY CSP_PLANNING_PARAMETERS_PKG as
2: /* $Header: csptpprb.pls 120.4 2010/12/07 06:23:43 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PLANNING_PARAMETERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_PLANNING_PARAMETERS_PKG

1: PACKAGE BODY CSP_PLANNING_PARAMETERS_PKG as
2: /* $Header: csptpprb.pls 120.4 2010/12/07 06:23:43 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PLANNING_PARAMETERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PLANNING_PARAMETERS_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpprb.pls';
12: PROCEDURE Insert_Row(
13: px_PLANNING_PARAMETERS_ID NUMBER
14: ,p_CREATED_BY NUMBER

Line 121: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;

117: ,P_HZ_LOCATION_ID NUMBER
118: )
119: IS
120: p_PLANNING_PARAMETERS_ID Number;
121: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
122: BEGIN
123:
124: If (px_PLANNING_PARAMETERS_ID IS NULL) OR (px_PLANNING_PARAMETERS_ID = FND_API.G_MISS_NUM) then
125: OPEN C2;

Line 130: INSERT INTO CSP_PLANNING_PARAMETERS(

126: FETCH C2 INTO p_PLANNING_PARAMETERS_ID;
127: CLOSE C2;
128: End If;
129:
130: INSERT INTO CSP_PLANNING_PARAMETERS(
131: PLANNING_PARAMETERS_ID
132: ,CREATED_BY
133: ,CREATION_DATE
134: ,LAST_UPDATED_BY

Line 454: Update CSP_PLANNING_PARAMETERS

450: ,P_HZ_LOCATION_ID NUMBER
451: )
452: IS
453: BEGIN
454: Update CSP_PLANNING_PARAMETERS
455: SET
456: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 569: DELETE FROM CSP_PLANNING_PARAMETERS

565:
566: PROCEDURE Delete_Row( p_LEVEL_ID VARCHAR2)
567: IS
568: BEGIN
569: DELETE FROM CSP_PLANNING_PARAMETERS
570: -- WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
571: WHERE LEVEL_ID LIKE p_LEVEL_ID||'%';
572:
573: If (SQL%NOTFOUND) then

Line 688: FROM CSP_PLANNING_PARAMETERS

684: )
685: IS
686: CURSOR C IS
687: SELECT *
688: FROM CSP_PLANNING_PARAMETERS
689: WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID
690: FOR UPDATE of PLANNING_PARAMETERS_ID NOWAIT;
691: Recinfo C%ROWTYPE;
692: BEGIN

Line 1033: End CSP_PLANNING_PARAMETERS_PKG;

1029: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1030: APP_EXCEPTION.RAISE_EXCEPTION;
1031: End If;
1032: END Lock_Row;
1033: End CSP_PLANNING_PARAMETERS_PKG;