[Home] [Help]
PACKAGE: APPS.CSC_PLAN_ENABLE_SETUP_PKG
Source
1 PACKAGE CSC_PLAN_ENABLE_SETUP_PKG AUTHID CURRENT_USER as
2 /* $Header: csctepls.pls 115.6 2002/12/03 08:17:29 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PLAN_ENABLE_SETUP_PKG
5 -- Purpose : Table handler package to perform inserts, update, deletes and lock
6 -- row operations on CSC_PLAN_ENABLE_SETUP table.
7 -- History :
8 -- MM-DD-YYYY NAME MODIFICATIONS
9 -- 01-13-2000 dejoseph Created.
10 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
11 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
12 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
13 -- 11-12-2002 bhroy NOCOPY changes made
14 -- 12-03-2002 bhroy Added check-in comments, WHENEVER OSERROR EXIT FAILURE ROLLBACK
15 -- NOTE :
16 -- End of Comments
17
18 PROCEDURE Insert_Row(
19 P_FUNCTION_ID IN NUMBER,
20 P_START_DATE_ACTIVE IN DATE,
21 P_END_DATE_ACTIVE IN DATE,
22 P_ON_INSERT_ENABLE_FLAG IN VARCHAR2,
23 P_ON_UPDATE_ENABLE_FLAG IN VARCHAR2,
24 P_CUSTOM1_ENABLE_FLAG IN VARCHAR2,
25 P_CUSTOM2_ENABLE_FLAG IN VARCHAR2,
26 P_CREATION_DATE IN DATE,
27 P_LAST_UPDATE_DATE IN DATE,
28 P_CREATED_BY IN NUMBER,
29 P_LAST_UPDATED_BY IN NUMBER,
30 P_LAST_UPDATE_LOGIN IN NUMBER,
31 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
32 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
33 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
34 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
35 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
36 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
37 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
38 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
39 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
40 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
41 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
42 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
43 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
44 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
45 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
46 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
47 X_ENABLE_SETUP_ID OUT NOCOPY NUMBER,
48 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
49
50 PROCEDURE Update_Row(
51 P_ENABLE_SETUP_ID IN NUMBER,
52 P_FUNCTION_ID IN NUMBER := NULL,
53 P_START_DATE_ACTIVE IN DATE := NULL,
54 P_END_DATE_ACTIVE IN DATE := NULL,
55 P_ON_INSERT_ENABLE_FLAG IN VARCHAR2 := NULL,
56 P_ON_UPDATE_ENABLE_FLAG IN VARCHAR2 := NULL,
57 P_CUSTOM1_ENABLE_FLAG IN VARCHAR2 := NULL,
58 P_CUSTOM2_ENABLE_FLAG IN VARCHAR2 := NULL,
59 P_LAST_UPDATE_DATE IN DATE := NULL,
60 P_LAST_UPDATED_BY IN NUMBER := NULL,
61 P_LAST_UPDATE_LOGIN IN NUMBER := NULL,
62 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
63 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
64 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
65 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
66 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
67 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
68 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
69 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
70 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
71 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
72 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
73 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
74 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
75 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
76 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
77 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
78 P_OBJECT_VERSION_NUMBER IN NUMBER,
79 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
80
81 PROCEDURE Lock_Row(
82 P_ENABLE_SETUP_ID IN NUMBER,
83 P_OBJECT_VERSION_NUMBER IN NUMBER);
84
85 PROCEDURE Delete_Row(
86 P_ENABLE_SETUP_ID IN NUMBER,
87 P_OBJECT_VERSION_NUMBER IN NUMBER);
88
89 End CSC_PLAN_ENABLE_SETUP_PKG;