APPS.CSP_PACKLIST_HEADERS_PKG dependencies on CSP_PACKLIST_HEADERS

Line 1: PACKAGE BODY CSP_PACKLIST_HEADERS_PKG as

1: PACKAGE BODY CSP_PACKLIST_HEADERS_PKG as
2: /* $Header: cspttahb.pls 115.6 2002/12/12 20:31:02 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PACKLIST_HEADERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_PACKLIST_HEADERS_PKG

1: PACKAGE BODY CSP_PACKLIST_HEADERS_PKG as
2: /* $Header: cspttahb.pls 115.6 2002/12/12 20:31:02 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PACKLIST_HEADERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

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

49: p_ATTRIBUTE14 VARCHAR2,
50: p_ATTRIBUTE15 VARCHAR2)
51:
52: IS
53: CURSOR C2 IS SELECT CSP_PACKLIST_HEADERS_S1.nextval FROM sys.dual;
54: BEGIN
55: If (px_PACKLIST_HEADER_ID IS NULL) OR (px_PACKLIST_HEADER_ID = FND_API.G_MISS_NUM) then
56: OPEN C2;
57: FETCH C2 INTO px_PACKLIST_HEADER_ID;

Line 60: INSERT INTO CSP_PACKLIST_HEADERS(

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

Line 176: Update CSP_PACKLIST_HEADERS

172: p_ATTRIBUTE15 VARCHAR2)
173:
174: IS
175: BEGIN
176: Update CSP_PACKLIST_HEADERS
177: SET
178: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
179: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
180: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 224: DELETE FROM CSP_PACKLIST_HEADERS

220: PROCEDURE Delete_Row(
221: p_PACKLIST_HEADER_ID NUMBER)
222: IS
223: BEGIN
224: DELETE FROM CSP_PACKLIST_HEADERS
225: WHERE PACKLIST_HEADER_ID = p_PACKLIST_HEADER_ID;
226: If (SQL%NOTFOUND) then
227: RAISE NO_DATA_FOUND;
228: End If;

Line 272: FROM CSP_PACKLIST_HEADERS

268:
269: IS
270: CURSOR C IS
271: SELECT *
272: FROM CSP_PACKLIST_HEADERS
273: WHERE PACKLIST_HEADER_ID = p_PACKLIST_HEADER_ID
274: FOR UPDATE of PACKLIST_HEADER_ID NOWAIT;
275: Recinfo C%ROWTYPE;
276: BEGIN

Line 400: End CSP_PACKLIST_HEADERS_PKG;

396: APP_EXCEPTION.RAISE_EXCEPTION;
397: End If;
398: END Lock_Row;
399:
400: End CSP_PACKLIST_HEADERS_PKG;