1 PACKAGE JTF_DSP_MSITE_SCT_SECT_PVT AUTHID CURRENT_USER AS
2 /* $Header: JTFVCMSS.pls 115.13 2004/07/09 18:51:41 applrt ship $ */
3
4 PROCEDURE insert_row
5 (
6 p_mini_site_section_section_id IN NUMBER,
7 p_object_version_number IN NUMBER,
8 p_mini_site_id IN NUMBER,
9 p_parent_section_id IN NUMBER,
10 p_child_section_id IN NUMBER,
11 p_start_date_active IN DATE,
12 p_end_date_active IN DATE,
13 p_level_number IN NUMBER,
14 p_sort_order IN NUMBER,
15 p_concat_ids IN VARCHAR2,
16 p_creation_date IN DATE,
17 p_created_by IN NUMBER,
18 p_last_update_date IN DATE,
19 p_last_updated_by IN NUMBER,
20 p_last_update_login IN NUMBER,
21 x_rowid OUT VARCHAR2,
22 x_mini_site_section_section_id OUT NUMBER
23 );
24
25 PROCEDURE update_row
26 (
27 p_mini_site_section_section_id IN NUMBER,
28 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
29 p_start_date_active IN DATE,
30 p_end_date_active IN DATE,
31 p_level_number IN NUMBER,
32 p_sort_order IN NUMBER,
33 p_concat_ids IN VARCHAR2,
34 p_last_update_date IN DATE,
35 p_last_updated_by IN NUMBER,
36 p_last_update_login IN NUMBER
37 );
38
39 PROCEDURE delete_row
40 (
41 p_mini_site_section_section_id IN NUMBER
42 );
43
44 --
45 -- To be called from jtfmste.lct only
46 --
47 PROCEDURE load_row
48 (
49 p_owner IN VARCHAR2,
50 p_mini_site_section_section_id IN NUMBER,
51 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
52 p_mini_site_id IN NUMBER,
53 p_parent_section_id IN NUMBER,
54 p_child_section_id IN NUMBER,
55 p_start_date_active IN DATE,
56 p_end_date_active IN DATE,
57 p_level_number IN NUMBER,
58 p_sort_order IN NUMBER,
59 p_concat_ids IN VARCHAR2
60 );
61
62 PROCEDURE Create_MSite_Section_Section
63 (
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 p_mini_site_id IN NUMBER,
69 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70 p_child_section_id IN NUMBER,
71 p_start_date_active IN DATE,
72 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73 p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75 p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 x_mini_site_section_section_id OUT NUMBER,
77 x_return_status OUT VARCHAR2,
78 x_msg_count OUT NUMBER,
79 x_msg_data OUT VARCHAR2
80 );
81
82 PROCEDURE Update_MSite_Section_Section
83 (
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89 p_object_version_number IN NUMBER,
90 p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92 p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95 p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97 p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 x_return_status OUT VARCHAR2,
99 x_msg_count OUT NUMBER,
100 x_msg_data OUT VARCHAR2
101 );
102
103 PROCEDURE Delete_MSite_Section_Section
104 (
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109 p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110 p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112 p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113 x_return_status OUT VARCHAR2,
114 x_msg_count OUT NUMBER,
115 x_msg_data OUT VARCHAR2
116 );
117
118 PROCEDURE Update_MSite_Section_Sections
119 (
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124 p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125 p_object_version_numbers IN JTF_NUMBER_TABLE,
126 p_start_date_actives IN JTF_DATE_TABLE,
127 p_end_date_actives IN JTF_DATE_TABLE,
128 p_sort_orders IN JTF_NUMBER_TABLE,
129 x_return_status OUT VARCHAR2,
130 x_msg_count OUT NUMBER,
131 x_msg_data OUT VARCHAR2
132 );
133
134 PROCEDURE Update_Delete_Sct_Scts
135 (
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140 p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141 p_object_version_numbers IN JTF_NUMBER_TABLE,
142 p_start_date_actives IN JTF_DATE_TABLE,
143 p_end_date_actives IN JTF_DATE_TABLE,
144 p_sort_orders IN JTF_NUMBER_TABLE,
145 p_delete_flags IN JTF_VARCHAR2_TABLE_300,
146 x_return_status OUT VARCHAR2,
147 x_msg_count OUT NUMBER,
148 x_msg_data OUT VARCHAR2
149 );
150
151 END JTF_DSP_MSITE_SCT_SECT_PVT;