APPS.IBE_DSP_MSITE_SCT_SECT_PVT dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 65: CURSOR c IS SELECT rowid FROM ibe_dsp_msite_sct_sects

61: x_rowid OUT NOCOPY VARCHAR2,
62: x_mini_site_section_section_id OUT NOCOPY NUMBER
63: )
64: IS
65: CURSOR c IS SELECT rowid FROM ibe_dsp_msite_sct_sects
66: WHERE mini_site_section_section_id = x_mini_site_section_section_id;
67: CURSOR c2 IS SELECT ibe_dsp_msite_sct_sects_s1.nextval FROM dual;
68:
69: BEGIN

Line 67: CURSOR c2 IS SELECT ibe_dsp_msite_sct_sects_s1.nextval FROM dual;

63: )
64: IS
65: CURSOR c IS SELECT rowid FROM ibe_dsp_msite_sct_sects
66: WHERE mini_site_section_section_id = x_mini_site_section_section_id;
67: CURSOR c2 IS SELECT ibe_dsp_msite_sct_sects_s1.nextval FROM dual;
68:
69: BEGIN
70:
71: -- Primary key validation check

Line 82: INSERT INTO ibe_dsp_msite_sct_sects

78: CLOSE c2;
79: END IF;
80:
81: -- insert base
82: INSERT INTO ibe_dsp_msite_sct_sects
83: (
84: mini_site_section_section_id,
85: object_version_number,
86: mini_site_id,

Line 156: UPDATE ibe_dsp_msite_sct_sects SET

152: IS
153: BEGIN
154:
155: -- update base
156: UPDATE ibe_dsp_msite_sct_sects SET
157: object_version_number = object_version_number + 1,
158: level_number = decode(p_level_number, FND_API.G_MISS_NUM,
159: level_number, p_level_number),
160: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,

Line 200: DELETE FROM ibe_dsp_msite_sct_sects

196: )
197: IS
198: BEGIN
199:
200: DELETE FROM ibe_dsp_msite_sct_sects
201: WHERE mini_site_section_section_id = p_mini_site_section_section_id;
202:
203: IF (sql%NOTFOUND) THEN
204: RAISE NO_DATA_FOUND;

Line 243: from ibe_dsp_msite_sct_sects

239: f_luby := fnd_load_util.owner_id(P_OWNER);
240: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
241: select LAST_UPDATED_BY, LAST_UPDATE_DATE
242: into db_luby, db_ludate
243: from ibe_dsp_msite_sct_sects
244: where mini_site_id = p_mini_site_id and child_section_id=p_child_section_id;
245:
246:
247: IF ((p_object_version_number IS NOT NULL) AND

Line 351: FROM ibe_dsp_msite_sct_sects

347:
348: IF (p_parent_section_id IS NOT NULL) THEN
349:
350: SELECT mini_site_section_section_id INTO l_tmp_msite_sct_sect_id
351: FROM ibe_dsp_msite_sct_sects
352: WHERE mini_site_id = p_mini_site_id
353: AND parent_section_id = p_parent_section_id
354: AND child_section_id = p_child_section_id;
355:

Line 359: FROM ibe_dsp_msite_sct_sects

355:
356: ELSE
357:
358: SELECT mini_site_section_section_id INTO l_tmp_msite_sct_sect_id
359: FROM ibe_dsp_msite_sct_sects
360: WHERE mini_site_id = p_mini_site_id
361: AND parent_section_id IS NULL
362: AND child_section_id = p_child_section_id;
363:

Line 1034: FROM ibe_dsp_msite_sct_sects

1030: BEGIN
1031: IF (p_parent_section_id IS NOT NULL) THEN
1032:
1033: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
1034: FROM ibe_dsp_msite_sct_sects
1035: WHERE mini_site_id = p_mini_site_id
1036: AND parent_section_id = p_parent_section_id
1037: AND child_section_id = p_child_section_id;
1038: ELSE

Line 1041: FROM ibe_dsp_msite_sct_sects

1037: AND child_section_id = p_child_section_id;
1038: ELSE
1039:
1040: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
1041: FROM ibe_dsp_msite_sct_sects
1042: WHERE mini_site_id = p_mini_site_id
1043: AND parent_section_id IS NULL
1044: AND child_section_id = p_child_section_id;
1045:

Line 1262: FROM ibe_dsp_msite_sct_sects

1258: BEGIN
1259: IF (p_parent_section_id IS NOT NULL) THEN
1260:
1261: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
1262: FROM ibe_dsp_msite_sct_sects
1263: WHERE mini_site_id = p_mini_site_id
1264: AND parent_section_id = p_parent_section_id
1265: AND child_section_id = child_section_id;
1266: ELSE

Line 1269: FROM ibe_dsp_msite_sct_sects

1265: AND child_section_id = child_section_id;
1266: ELSE
1267:
1268: SELECT mini_site_section_section_id INTO l_msite_sct_sect_id
1269: FROM ibe_dsp_msite_sct_sects
1270: WHERE mini_site_id = p_mini_site_id
1271: AND parent_section_id IS NULL
1272: AND child_section_id = child_section_id;
1273: