APPS.AS_PROD_WORKSHEET_LINES_PKG dependencies on AS_PROD_WORKSHEET_LINES

Line 1: PACKAGE BODY AS_PROD_WORKSHEET_LINES_PKG as

1: PACKAGE BODY AS_PROD_WORKSHEET_LINES_PKG as
2: /* $Header: asxtpwlb.pls 115.8 2004/01/13 10:08:50 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_PROD_WORKSHEET_LINES_PKG
5: -- Purpose :

Line 4: -- Package name : AS_PROD_WORKSHEET_LINES_PKG

1: PACKAGE BODY AS_PROD_WORKSHEET_LINES_PKG as
2: /* $Header: asxtpwlb.pls 115.8 2004/01/13 10:08:50 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_PROD_WORKSHEET_LINES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 76: CURSOR C2 IS SELECT AS_PROD_WORKSHEET_LINES_S.nextval FROM sys.dual;

72: P_PRODUCT_CATEGORY_ID NUMBER,
73: P_PRODUCT_CAT_SET_ID NUMBER)
74:
75: IS
76: CURSOR C2 IS SELECT AS_PROD_WORKSHEET_LINES_S.nextval FROM sys.dual;
77: BEGIN
78: If (px_PROD_WORKSHEET_LINE_ID IS NULL) OR (px_PROD_WORKSHEET_LINE_ID = FND_API.G_MISS_NUM) then
79: OPEN C2;
80: FETCH C2 INTO px_PROD_WORKSHEET_LINE_ID;

Line 83: INSERT INTO AS_PROD_WORKSHEET_LINES(

79: OPEN C2;
80: FETCH C2 INTO px_PROD_WORKSHEET_LINE_ID;
81: CLOSE C2;
82: End If;
83: INSERT INTO AS_PROD_WORKSHEET_LINES(
84: PROD_WORKSHEET_LINE_ID,
85: FORECAST_WORKSHEET_ID,
86: CREATED_BY,
87: CREATION_DATE,

Line 268: Update AS_PROD_WORKSHEET_LINES

264: P_PRODUCT_CAT_SET_ID NUMBER)
265:
266: IS
267: BEGIN
268: Update AS_PROD_WORKSHEET_LINES
269: SET object_version_number = nvl(object_version_number,0) + 1,
270: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, FORECAST_WORKSHEET_ID, p_FORECAST_WORKSHEET_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 403: DELETE FROM AS_PROD_WORKSHEET_LINES

399: PROCEDURE Delete_Row(
400: p_PROD_WORKSHEET_LINE_ID NUMBER)
401: IS
402: BEGIN
403: DELETE FROM AS_PROD_WORKSHEET_LINES
404: WHERE PROD_WORKSHEET_LINE_ID = p_PROD_WORKSHEET_LINE_ID;
405: If (SQL%NOTFOUND) then
406: RAISE NO_DATA_FOUND;
407: End If;

Line 474: FROM AS_PROD_WORKSHEET_LINES

470:
471: IS
472: CURSOR C IS
473: SELECT *
474: FROM AS_PROD_WORKSHEET_LINES
475: WHERE PROD_WORKSHEET_LINE_ID = p_PROD_WORKSHEET_LINE_ID
476: FOR UPDATE of PROD_WORKSHEET_LINE_ID NOWAIT;
477: Recinfo C%ROWTYPE;
478: BEGIN

Line 671: End AS_PROD_WORKSHEET_LINES_PKG;

667: APP_EXCEPTION.RAISE_EXCEPTION;
668: End If;
669: END Lock_Row;
670:
671: End AS_PROD_WORKSHEET_LINES_PKG;