APPS.IBE_DSP_SECTION_GRP dependencies on IBE_DSP_SECTIONS_B

Line 121: CURSOR c IS SELECT rowid FROM ibe_dsp_sections_b

117: IS
118: l_display_context_id NUMBER;
119: l_deliverable_id NUMBER;
120:
121: CURSOR c IS SELECT rowid FROM ibe_dsp_sections_b
122: WHERE section_id = x_section_id;
123: CURSOR c2 IS SELECT ibe_dsp_sections_b_s1.nextval FROM dual;
124:
125: BEGIN

Line 123: CURSOR c2 IS SELECT ibe_dsp_sections_b_s1.nextval FROM dual;

119: l_deliverable_id NUMBER;
120:
121: CURSOR c IS SELECT rowid FROM ibe_dsp_sections_b
122: WHERE section_id = x_section_id;
123: CURSOR c2 IS SELECT ibe_dsp_sections_b_s1.nextval FROM dual;
124:
125: BEGIN
126:
127: -- Primary key validation check

Line 138: INSERT INTO ibe_dsp_sections_b

134: CLOSE c2;
135: END IF;
136:
137: -- insert base
138: INSERT INTO ibe_dsp_sections_b
139: (
140: section_id,
141: object_version_number,
142: access_name,

Line 328: UPDATE ibe_dsp_sections_b SET

324: IS
325: BEGIN
326:
327: -- update base
328: UPDATE ibe_dsp_sections_b SET
329: object_version_number = object_version_number + 1,
330: access_name = decode(p_access_name, FND_API.G_MISS_CHAR,
331: access_name, p_access_name),
332: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

Line 451: DELETE FROM ibe_dsp_sections_b

447: IF (sql%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;
449: END IF;
450:
451: DELETE FROM ibe_dsp_sections_b
452: WHERE section_id = p_section_id;
453:
454: IF (sql%NOTFOUND) THEN
455: RAISE NO_DATA_FOUND;

Line 519: from ibe_dsp_sections_b

515: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
516: -- get the value of the db_luby and db_ludate from the database
517: select LAST_UPDATED_BY, LAST_UPDATE_DATE
518: into db_luby, db_ludate
519: from ibe_dsp_sections_b
520: where SECTION_ID = p_section_id;
521:
522: IF ((p_object_version_number IS NOT NULL) AND
523: (p_object_version_number <> FND_API.G_MISS_NUM))

Line 670: FROM ibe_dsp_sections_b

666: l_tmp_sql_str VARCHAR2(240) := NULL;
667:
668: CURSOR c1(l_c_access_name IN VARCHAR2)
669: IS SELECT section_id
670: FROM ibe_dsp_sections_b
671: WHERE access_name = l_c_access_name;
672:
673: -- comment out (bug 2699543, since the code using the cursor is
674: -- already commented out)

Line 1770: SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b

1766: THEN
1767: -- If access_name specified and section_id is not specified, then
1768: -- query for section id
1769: BEGIN
1770: SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b
1771: WHERE access_name = p_access_name;
1772: EXCEPTION
1773: WHEN NO_DATA_FOUND THEN
1774: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');

Line 2026: SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b

2022: THEN
2023: -- 2. If access_name specified and section_id is not specified, then
2024: -- query for section id and delete all references
2025: BEGIN
2026: SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b
2027: WHERE access_name = p_access_name;
2028: EXCEPTION
2029: WHEN NO_DATA_FOUND THEN
2030: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');

Line 2131: -- delete for ibe_dsp_sections_b and _tl tables

2127:
2128: -- delete for other tables (Templates, Media, etc)
2129: IBE_LOGICALCONTENT_GRP.Delete_Section(l_section_id);
2130:
2131: -- delete for ibe_dsp_sections_b and _tl tables
2132: delete_row(l_section_id);
2133:
2134: EXCEPTION
2135:

Line 2217: UPDATE ibe_dsp_sections_b

2213: -- 1. Update all rows with display_context_id set to null and
2214: -- object version number set to +1
2215:
2216: -- 1. update all rows
2217: UPDATE ibe_dsp_sections_b
2218: SET display_context_id = NULL,
2219: object_version_number = object_version_number + 1
2220: WHERE display_context_id = p_display_context_id;
2221:

Line 2318: UPDATE ibe_dsp_sections_b

2314: -- 1. Update all rows with deliverable_id set to null and
2315: -- object version number set to +1
2316:
2317: -- 1. update all rows
2318: UPDATE ibe_dsp_sections_b
2319: SET deliverable_id = NULL,
2320: object_version_number = object_version_number + 1
2321: WHERE deliverable_id = p_deliverable_id;
2322:

Line 2384: from IBE_DSP_SECTIONS_B B

2380: begin
2381: delete from IBE_DSP_SECTIONS_TL T
2382: where not exists
2383: (select NULL
2384: from IBE_DSP_SECTIONS_B B
2385: where B.SECTION_ID = T.SECTION_ID
2386: );
2387:
2388: update IBE_DSP_SECTIONS_TL T set (