1 PACKAGE CSC_PLAN_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: csctplns.pls 115.12 2002/11/25 08:18:03 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PLAN_LINES_PKG
5 -- Purpose : Table handler package to performs Inserts, Updates, Deletes and Lock
6 -- row operations on the CSC_PLAN_LINES table.
7 -- History :
8 -- MM-DD-YYYY NAME MODIFICATIONS
9 -- 10-21-1999 dejoseph Created.
10 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
11 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
12 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
13 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
14 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
15 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
16 --
17 -- 08-17-2001 dejoseph Made the following changes for 11.5.6 to cater to the seeding
18 -- of Relationship Plans. Ref Bug # 1895567.
19 -- - Added proc load_row to be called for the .lct file (cscpllns.lct)
20 -- - added parameter p_application_id to procedure insert_row and
21 -- update_row.
22 -- 11-12-2002 bhroy NOCOPY changes made
23 -- 11-25-2002 bhroy FND_API defaults removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
24 -- NOTE :
25 -- End of Comments
26
27 PROCEDURE Insert_Row(
28 px_LINE_ID IN OUT NOCOPY NUMBER,
29 p_PLAN_ID IN NUMBER,
30 p_CONDITION_ID IN NUMBER,
31 p_CREATION_DATE IN DATE,
32 p_LAST_UPDATE_DATE IN DATE,
33 p_CREATED_BY IN NUMBER,
34 p_LAST_UPDATED_BY IN NUMBER,
35 p_LAST_UPDATE_LOGIN IN NUMBER,
36 p_ATTRIBUTE1 IN VARCHAR2,
37 p_ATTRIBUTE2 IN VARCHAR2,
38 p_ATTRIBUTE3 IN VARCHAR2,
39 p_ATTRIBUTE4 IN VARCHAR2,
40 p_ATTRIBUTE5 IN VARCHAR2,
41 p_ATTRIBUTE6 IN VARCHAR2,
42 p_ATTRIBUTE7 IN VARCHAR2,
43 p_ATTRIBUTE8 IN VARCHAR2,
44 p_ATTRIBUTE9 IN VARCHAR2,
45 p_ATTRIBUTE10 IN VARCHAR2,
46 p_ATTRIBUTE11 IN VARCHAR2,
47 p_ATTRIBUTE12 IN VARCHAR2,
48 p_ATTRIBUTE13 IN VARCHAR2,
49 p_ATTRIBUTE14 IN VARCHAR2,
50 p_ATTRIBUTE15 IN VARCHAR2,
51 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
52 p_APPLICATION_ID IN NUMBER := NULL,
53 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
54
55 PROCEDURE Update_Row(
56 p_LINE_ID IN NUMBER,
57 p_PLAN_ID IN NUMBER,
58 p_CONDITION_ID IN NUMBER,
59 p_CREATION_DATE IN DATE,
60 p_LAST_UPDATE_DATE IN DATE,
61 p_CREATED_BY IN NUMBER,
62 p_LAST_UPDATED_BY IN NUMBER,
63 p_LAST_UPDATE_LOGIN IN NUMBER,
64 p_ATTRIBUTE1 IN VARCHAR2,
65 p_ATTRIBUTE2 IN VARCHAR2,
66 p_ATTRIBUTE3 IN VARCHAR2,
67 p_ATTRIBUTE4 IN VARCHAR2,
68 p_ATTRIBUTE5 IN VARCHAR2,
69 p_ATTRIBUTE6 IN VARCHAR2,
70 p_ATTRIBUTE7 IN VARCHAR2,
71 p_ATTRIBUTE8 IN VARCHAR2,
72 p_ATTRIBUTE9 IN VARCHAR2,
73 p_ATTRIBUTE10 IN VARCHAR2,
74 p_ATTRIBUTE11 IN VARCHAR2,
75 p_ATTRIBUTE12 IN VARCHAR2,
76 p_ATTRIBUTE13 IN VARCHAR2,
77 p_ATTRIBUTE14 IN VARCHAR2,
78 p_ATTRIBUTE15 IN VARCHAR2,
79 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
80 p_APPLICATION_ID IN NUMBER := NULL,
81 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
82
83 PROCEDURE Lock_Row(
84 p_LINE_ID IN NUMBER,
85 p_PLAN_ID IN NUMBER,
86 p_CONDITION_ID IN NUMBER,
87 p_CREATION_DATE IN DATE,
88 p_LAST_UPDATE_DATE IN DATE,
89 p_CREATED_BY IN NUMBER,
90 p_LAST_UPDATED_BY IN NUMBER,
91 p_LAST_UPDATE_LOGIN IN NUMBER,
92 p_ATTRIBUTE1 IN VARCHAR2,
93 p_ATTRIBUTE2 IN VARCHAR2,
94 p_ATTRIBUTE3 IN VARCHAR2,
95 p_ATTRIBUTE4 IN VARCHAR2,
96 p_ATTRIBUTE5 IN VARCHAR2,
97 p_ATTRIBUTE6 IN VARCHAR2,
98 p_ATTRIBUTE7 IN VARCHAR2,
99 p_ATTRIBUTE8 IN VARCHAR2,
100 p_ATTRIBUTE9 IN VARCHAR2,
101 p_ATTRIBUTE10 IN VARCHAR2,
102 p_ATTRIBUTE11 IN VARCHAR2,
103 p_ATTRIBUTE12 IN VARCHAR2,
104 p_ATTRIBUTE13 IN VARCHAR2,
105 p_ATTRIBUTE14 IN VARCHAR2,
106 p_ATTRIBUTE15 IN VARCHAR2,
107 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
108 p_OBJECT_VERSION_NUMBER IN NUMBER);
109
110 PROCEDURE Delete_Row(
111 p_LINE_ID IN NUMBER,
112 p_plan_id IN NUMBER);
113
114 PROCEDURE LOAD_ROW (
115 P_LINE_ID IN NUMBER,
116 P_PLAN_ID IN NUMBER,
117 P_CONDITION_ID IN NUMBER,
118 P_LAST_UPDATE_DATE IN DATE,
119 P_LAST_UPDATED_BY IN NUMBER,
120 P_CREATED_BY IN NUMBER,
121 P_LAST_UPDATE_LOGIN IN NUMBER,
122 P_ATTRIBUTE1 IN VARCHAR2 := NULL,
123 P_ATTRIBUTE2 IN VARCHAR2 := NULL,
124 P_ATTRIBUTE3 IN VARCHAR2 := NULL,
125 P_ATTRIBUTE4 IN VARCHAR2 := NULL,
126 P_ATTRIBUTE5 IN VARCHAR2 := NULL,
127 P_ATTRIBUTE6 IN VARCHAR2 := NULL,
128 P_ATTRIBUTE7 IN VARCHAR2 := NULL,
129 P_ATTRIBUTE8 IN VARCHAR2 := NULL,
130 P_ATTRIBUTE9 IN VARCHAR2 := NULL,
131 P_ATTRIBUTE10 IN VARCHAR2 := NULL,
132 P_ATTRIBUTE11 IN VARCHAR2 := NULL,
133 P_ATTRIBUTE12 IN VARCHAR2 := NULL,
134 P_ATTRIBUTE13 IN VARCHAR2 := NULL,
135 P_ATTRIBUTE14 IN VARCHAR2 := NULL,
136 P_ATTRIBUTE15 IN VARCHAR2 := NULL,
137 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
138 P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
139 P_APPLICATION_ID IN NUMBER,
140 P_OWNER IN VARCHAR2 );
141
142 End CSC_PLAN_LINES_PKG;