APPS.CSP_PACKLIST_LINES_PKG dependencies on CSP_PACKLIST_LINES

Line 1: PACKAGE BODY CSP_PACKLIST_LINES_PKG AS

1: PACKAGE BODY CSP_PACKLIST_LINES_PKG AS
2: /* $Header: cspttalb.pls 115.7 2002/11/26 07:38:51 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PACKLIST_LINES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_PACKLIST_LINES_PKG

1: PACKAGE BODY CSP_PACKLIST_LINES_PKG AS
2: /* $Header: cspttalb.pls 115.7 2002/11/26 07:38:51 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PACKLIST_LINES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PACKLIST_LINES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspttalb.pls';
13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
15:

Line 53: CURSOR C2 IS SELECT CSP_PACKLIST_LINES_S1.nextval FROM sys.dual;

49: p_UOM_CODE VARCHAR2,
50: p_LINE_ID NUMBER)
51:
52: IS
53: CURSOR C2 IS SELECT CSP_PACKLIST_LINES_S1.nextval FROM sys.dual;
54: BEGIN
55: If (px_PACKLIST_LINE_ID IS NULL) OR (px_PACKLIST_LINE_ID = FND_API.G_MISS_NUM) then
56: OPEN C2;
57: FETCH C2 INTO px_PACKLIST_LINE_ID;

Line 60: INSERT INTO CSP_PACKLIST_LINES(

56: OPEN C2;
57: FETCH C2 INTO px_PACKLIST_LINE_ID;
58: CLOSE C2;
59: End If;
60: INSERT INTO CSP_PACKLIST_LINES(
61: PACKLIST_LINE_ID,
62: CREATED_BY,
63: CREATION_DATE,
64: LAST_UPDATED_BY,

Line 170: Update CSP_PACKLIST_LINES

166: p_LINE_ID NUMBER)
167:
168: IS
169: BEGIN
170: Update CSP_PACKLIST_LINES
171: SET
172: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
173: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
174: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 216: DELETE FROM CSP_PACKLIST_LINES

212: PROCEDURE Delete_Row(
213: p_PACKLIST_LINE_ID NUMBER)
214: IS
215: BEGIN
216: DELETE FROM CSP_PACKLIST_LINES
217: WHERE PACKLIST_LINE_ID = p_PACKLIST_LINE_ID;
218: If (SQL%NOTFOUND) then
219: RAISE NO_DATA_FOUND;
220: End If;

Line 262: FROM CSP_PACKLIST_LINES

258:
259: IS
260: CURSOR C IS
261: SELECT *
262: FROM CSP_PACKLIST_LINES
263: WHERE PACKLIST_LINE_ID = p_PACKLIST_LINE_ID
264: FOR UPDATE of PACKLIST_LINE_ID NOWAIT;
265: Recinfo C%ROWTYPE;
266: BEGIN

Line 384: End CSP_PACKLIST_LINES_PKG;

380: APP_EXCEPTION.RAISE_EXCEPTION;
381: End If;
382: END Lock_Row;
383:
384: End CSP_PACKLIST_LINES_PKG;