1 PACKAGE IBE_DSP_MSITE_SCT_SECT_PVT AS
2 /* $Header: IBEVCMSS.pls 120.2 2006/06/30 22:32:31 abhandar noship $ */
3
4 -- HISTORY
5 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6
7 PROCEDURE insert_row
8 (
9 p_mini_site_section_section_id IN NUMBER,
10 p_object_version_number IN NUMBER,
11 p_mini_site_id IN NUMBER,
12 p_parent_section_id IN NUMBER,
13 p_child_section_id IN NUMBER,
14 p_start_date_active IN DATE,
15 p_end_date_active IN DATE,
16 p_level_number IN NUMBER,
17 p_sort_order IN NUMBER,
18 p_concat_ids IN VARCHAR2,
19 p_creation_date IN DATE,
20 p_created_by IN NUMBER,
21 p_last_update_date IN DATE,
22 p_last_updated_by IN NUMBER,
23 p_last_update_login IN NUMBER,
24 x_rowid OUT NOCOPY VARCHAR2,
25 x_mini_site_section_section_id OUT NOCOPY NUMBER
26 );
27
28 PROCEDURE update_row
29 (
30 p_mini_site_section_section_id IN NUMBER,
31 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
32 p_start_date_active IN DATE,
33 p_end_date_active IN DATE,
34 p_level_number IN NUMBER,
35 p_sort_order IN NUMBER,
36 p_concat_ids IN VARCHAR2,
37 p_last_update_date IN DATE,
38 p_last_updated_by IN NUMBER,
39 p_last_update_login IN NUMBER
40 );
41
42 PROCEDURE delete_row
43 (
44 p_mini_site_section_section_id IN NUMBER
45 );
46
47 --
48 -- To be called from ibemste.lct only
49 --
50 PROCEDURE load_row
51 (
52 p_owner IN VARCHAR2,
53 p_mini_site_section_section_id IN NUMBER,
54 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
55 p_mini_site_id IN NUMBER,
56 p_parent_section_id IN NUMBER,
57 p_child_section_id IN NUMBER,
58 p_start_date_active IN DATE,
59 p_end_date_active IN DATE,
60 p_level_number IN NUMBER,
61 p_sort_order IN NUMBER,
62 p_concat_ids IN VARCHAR2,
63 P_LAST_UPDATE_DATE IN VARCHAR2,
64 P_CUSTOM_MODE IN VARCHAR2
65 );
66
67 PROCEDURE Create_MSite_Section_Section
68 (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_mini_site_id IN NUMBER,
74 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_child_section_id IN NUMBER,
76 p_start_date_active IN DATE,
77 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
78 p_level_number IN NUMBER := FND_API.G_MISS_NUM,
79 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80 p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 x_mini_site_section_section_id OUT NOCOPY NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE Update_MSite_Section_Section
88 (
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91 p_commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94 p_object_version_number IN NUMBER,
95 p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97 p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100 p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
102 p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE Delete_MSite_Section_Section
109 (
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114 p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115 p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
117 p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE Update_MSite_Section_Sections
124 (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127 p_commit IN VARCHAR2 := FND_API.G_FALSE,
128 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129 p_msite_section_section_ids IN JTF_NUMBER_TABLE,
130 p_object_version_numbers IN JTF_NUMBER_TABLE,
131 p_start_date_actives IN JTF_DATE_TABLE,
132 p_end_date_actives IN JTF_DATE_TABLE,
133 p_sort_orders IN JTF_NUMBER_TABLE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139 PROCEDURE Update_Delete_Sct_Scts
140 (
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143 p_commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145 p_msite_section_section_ids IN JTF_NUMBER_TABLE,
146 p_object_version_numbers IN JTF_NUMBER_TABLE,
147 p_start_date_actives IN JTF_DATE_TABLE,
148 p_end_date_actives IN JTF_DATE_TABLE,
149 p_sort_orders IN JTF_NUMBER_TABLE,
150 p_delete_flags IN JTF_VARCHAR2_TABLE_300,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE LOAD_SEED_ROW
157 (
158 P_MINI_SITE_SECTION_SECTION_ID IN NUMBER,
159 P_OWNER IN VARCHAR2,
160 P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
161 P_MINI_SITE_ID IN NUMBER,
162 P_PARENT_SECTION_ID IN NUMBER,
163 P_CHILD_SECTION_ID IN NUMBER,
164 P_START_DATE_ACTIVE IN VARCHAR2, --IN DATE,
165 P_END_DATE_ACTIVE IN VARCHAR2, --IN DATE,
166 P_LEVEL_NUMBER IN NUMBER,
167 P_SORT_ORDER IN NUMBER,
168 P_CONCAT_IDS IN VARCHAR2,
169 P_LAST_UPDATE_DATE IN VARCHAR2,
170 P_CUSTOM_MODE IN VARCHAR2,
171 P_UPLOAD_MODE IN VARCHAR2
172 );
173
174
175 END IBE_DSP_MSITE_SCT_SECT_PVT;