60: x_rowid OUT VARCHAR2,
61: x_mini_site_section_section_id OUT NUMBER
62: )
63: IS
64: CURSOR c IS SELECT rowid FROM jtf_dsp_msite_sct_sects
65: WHERE mini_site_section_section_id = x_mini_site_section_section_id;
66: CURSOR c2 IS SELECT jtf_dsp_msite_sct_sects_s1.nextval FROM dual;
67:
68: BEGIN
62: )
63: IS
64: CURSOR c IS SELECT rowid FROM jtf_dsp_msite_sct_sects
65: WHERE mini_site_section_section_id = x_mini_site_section_section_id;
66: CURSOR c2 IS SELECT jtf_dsp_msite_sct_sects_s1.nextval FROM dual;
67:
68: BEGIN
69:
70: -- Primary key validation check
77: CLOSE c2;
78: END IF;
79:
80: -- insert base
81: INSERT INTO jtf_dsp_msite_sct_sects
82: (
83: mini_site_section_section_id,
84: object_version_number,
85: mini_site_id,
151: IS
152: BEGIN
153:
154: -- update base
155: UPDATE jtf_dsp_msite_sct_sects SET
156: object_version_number = object_version_number + 1,
157: level_number = decode(p_level_number, FND_API.G_MISS_NUM,
158: level_number, p_level_number),
159: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
195: )
196: IS
197: BEGIN
198:
199: DELETE FROM jtf_dsp_msite_sct_sects
200: WHERE mini_site_section_section_id = p_mini_site_section_section_id;
201:
202: IF (sql%NOTFOUND) THEN
203: RAISE NO_DATA_FOUND;
337:
338: IF (p_parent_section_id IS NOT NULL) THEN
339:
340: SELECT mini_site_section_section_id INTO l_tmp_msite_sct_sect_id
341: FROM jtf_dsp_msite_sct_sects
342: WHERE mini_site_id = p_mini_site_id
343: AND parent_section_id = p_parent_section_id
344: AND child_section_id = p_child_section_id;
345:
345:
346: ELSE
347:
348: SELECT mini_site_section_section_id INTO l_tmp_msite_sct_sect_id
349: FROM jtf_dsp_msite_sct_sects
350: WHERE mini_site_id = p_mini_site_id
351: AND parent_section_id IS NULL
352: AND child_section_id = p_child_section_id;
353:
965: BEGIN
966: IF (p_parent_section_id IS NOT NULL) THEN
967:
968: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
969: FROM jtf_dsp_msite_sct_sects
970: WHERE mini_site_id = p_mini_site_id
971: AND parent_section_id = p_parent_section_id
972: AND child_section_id = p_child_section_id;
973: ELSE
972: AND child_section_id = p_child_section_id;
973: ELSE
974:
975: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
976: FROM jtf_dsp_msite_sct_sects
977: WHERE mini_site_id = p_mini_site_id
978: AND parent_section_id IS NULL
979: AND child_section_id = p_child_section_id;
980:
1174: BEGIN
1175: IF (p_parent_section_id IS NOT NULL) THEN
1176:
1177: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
1178: FROM jtf_dsp_msite_sct_sects
1179: WHERE mini_site_id = p_mini_site_id
1180: AND parent_section_id = p_parent_section_id
1181: AND child_section_id = child_section_id;
1182: ELSE
1181: AND child_section_id = child_section_id;
1182: ELSE
1183:
1184: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
1185: FROM jtf_dsp_msite_sct_sects
1186: WHERE mini_site_id = p_mini_site_id
1187: AND parent_section_id IS NULL
1188: AND child_section_id = child_section_id;
1189: