APPS.CSP_PICKLIST_HEADERS_PKG dependencies on CSP_PICKLIST_HEADERS

Line 1: PACKAGE BODY CSP_PICKLIST_HEADERS_PKG AS

1: PACKAGE BODY CSP_PICKLIST_HEADERS_PKG AS
2: /* $Header: cspttphb.pls 115.8 2002/11/26 07:50:49 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PICKLIST_HEADERS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_PICKLIST_HEADERS_PKG

1: PACKAGE BODY CSP_PICKLIST_HEADERS_PKG AS
2: /* $Header: cspttphb.pls 115.8 2002/11/26 07:50:49 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_PICKLIST_HEADERS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 44: CURSOR C2 IS SELECT CSP_PICKLIST_HEADERS_S1.nextval FROM sys.dual;

40: p_ATTRIBUTE14 VARCHAR2,
41: p_ATTRIBUTE15 VARCHAR2)
42:
43: IS
44: CURSOR C2 IS SELECT CSP_PICKLIST_HEADERS_S1.nextval FROM sys.dual;
45: BEGIN
46: If (px_picklist_header_id IS NULL) OR (px_picklist_header_id = FND_API.G_MISS_NUM) then
47: OPEN C2;
48: FETCH C2 INTO px_picklist_header_id;

Line 51: INSERT INTO CSP_PICKLIST_HEADERS(

47: OPEN C2;
48: FETCH C2 INTO px_picklist_header_id;
49: CLOSE C2;
50: End If;
51: INSERT INTO CSP_PICKLIST_HEADERS(
52: picklist_header_id,
53: CREATED_BY,
54: CREATION_DATE,
55: LAST_UPDATED_BY,

Line 140: Update CSP_PICKLIST_HEADERS

136: p_ATTRIBUTE15 VARCHAR2)
137:
138: IS
139: BEGIN
140: Update CSP_PICKLIST_HEADERS
141: SET
142: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
143: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
144: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 179: DELETE FROM CSP_PICKLIST_HEADERS

175: PROCEDURE Delete_Row(
176: p_picklist_header_id NUMBER)
177: IS
178: BEGIN
179: DELETE FROM CSP_PICKLIST_HEADERS
180: WHERE picklist_header_id = p_picklist_header_id;
181: If (SQL%NOTFOUND) then
182: RAISE NO_DATA_FOUND;
183: End If;

Line 218: FROM CSP_PICKLIST_HEADERS

214:
215: IS
216: CURSOR C IS
217: SELECT *
218: FROM CSP_PICKLIST_HEADERS
219: WHERE picklist_header_id = p_picklist_header_id
220: FOR UPDATE of picklist_header_id NOWAIT;
221: Recinfo C%ROWTYPE;
222: BEGIN

Line 319: End CSP_PICKLIST_HEADERS_PKG;

315: APP_EXCEPTION.RAISE_EXCEPTION;
316: End If;
317: END Lock_Row;
318:
319: End CSP_PICKLIST_HEADERS_PKG;