APPS.CSP_PICKLIST_LINES_PKG dependencies on CSP_PICKLIST_LINES

Line 1: PACKAGE BODY CSP_PICKLIST_LINES_PKG AS

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

Line 4: -- Package name : CSP_PICKLIST_LINES_PKG

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

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

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

Line 47: CURSOR C2 IS SELECT CSP_PICKLIST_LINES_S1.nextval FROM sys.dual;

43: p_ATTRIBUTE14 VARCHAR2,
44: p_ATTRIBUTE15 VARCHAR2)
45:
46: IS
47: CURSOR C2 IS SELECT CSP_PICKLIST_LINES_S1.nextval FROM sys.dual;
48: BEGIN
49:
50: If (px_picklist_line_id IS NULL) OR (px_picklist_line_id = FND_API.G_MISS_NUM) then
51: OPEN C2;

Line 55: INSERT INTO CSP_PICKLIST_LINES(

51: OPEN C2;
52: FETCH C2 INTO px_picklist_line_id;
53: CLOSE C2;
54: End If;
55: INSERT INTO CSP_PICKLIST_LINES(
56: picklist_line_id,
57: CREATED_BY,
58: CREATION_DATE,
59: LAST_UPDATED_BY,

Line 153: Update CSP_PICKLIST_LINES

149: p_ATTRIBUTE15 VARCHAR2)
150:
151: IS
152: BEGIN
153: Update CSP_PICKLIST_LINES
154: SET
155: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
156: CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
157: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 195: DELETE FROM CSP_PICKLIST_LINES

191: PROCEDURE Delete_Row(
192: p_picklist_line_id NUMBER)
193: IS
194: BEGIN
195: DELETE FROM CSP_PICKLIST_LINES
196: WHERE picklist_line_id = p_picklist_line_id;
197: If (SQL%NOTFOUND) then
198: RAISE NO_DATA_FOUND;
199: End If;

Line 237: FROM CSP_PICKLIST_LINES

233:
234: IS
235: CURSOR C IS
236: SELECT *
237: FROM CSP_PICKLIST_LINES
238: WHERE picklist_line_id = p_picklist_line_id
239: FOR UPDATE of picklist_line_id NOWAIT;
240: Recinfo C%ROWTYPE;
241: BEGIN

Line 348: End CSP_PICKLIST_LINES_PKG;

344: APP_EXCEPTION.RAISE_EXCEPTION;
345: End If;
346: END Lock_Row;
347:
348: End CSP_PICKLIST_LINES_PKG;