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.3 2007/12/09 20:32:12 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.3 2007/12/09 20:32:12 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 109: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;

105: ,p_RESCHEDULE_RULE_ID NUMBER
106: ,p_WRP_RULE_ID NUMBER)
107: IS
108: p_PLANNING_PARAMETERS_ID Number;
109: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
110: BEGIN
111:
112: If (px_PLANNING_PARAMETERS_ID IS NULL) OR (px_PLANNING_PARAMETERS_ID = FND_API.G_MISS_NUM) then
113: OPEN C2;

Line 118: INSERT INTO CSP_PLANNING_PARAMETERS(

114: FETCH C2 INTO p_PLANNING_PARAMETERS_ID;
115: CLOSE C2;
116: End If;
117:
118: INSERT INTO CSP_PLANNING_PARAMETERS(
119: PLANNING_PARAMETERS_ID
120: ,CREATED_BY
121: ,CREATION_DATE
122: ,LAST_UPDATED_BY

Line 407: Update CSP_PLANNING_PARAMETERS

403: ,p_RESCHEDULE_RULE_ID NUMBER
404: ,p_WRP_RULE_ID NUMBER)
405: IS
406: BEGIN
407: Update CSP_PLANNING_PARAMETERS
408: SET
409: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
410: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
411: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 510: DELETE FROM CSP_PLANNING_PARAMETERS

506:
507: PROCEDURE Delete_Row( p_LEVEL_ID VARCHAR2)
508: IS
509: BEGIN
510: DELETE FROM CSP_PLANNING_PARAMETERS
511: -- WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
512: WHERE LEVEL_ID LIKE p_LEVEL_ID||'%';
513:
514: If (SQL%NOTFOUND) then

Line 617: FROM CSP_PLANNING_PARAMETERS

613: ,p_WRP_RULE_ID NUMBER)
614: IS
615: CURSOR C IS
616: SELECT *
617: FROM CSP_PLANNING_PARAMETERS
618: WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID
619: FOR UPDATE of PLANNING_PARAMETERS_ID NOWAIT;
620: Recinfo C%ROWTYPE;
621: BEGIN

Line 918: End CSP_PLANNING_PARAMETERS_PKG;

914: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
915: APP_EXCEPTION.RAISE_EXCEPTION;
916: End If;
917: END Lock_Row;
918: End CSP_PLANNING_PARAMETERS_PKG;