APPS.JTF_DSP_SECTION_GRP dependencies on JTF_DSP_SECTIONS_B

Line 114: CURSOR c IS SELECT rowid FROM jtf_dsp_sections_b

110: IS
111: l_display_context_id NUMBER;
112: l_deliverable_id NUMBER;
113:
114: CURSOR c IS SELECT rowid FROM jtf_dsp_sections_b
115: WHERE section_id = x_section_id;
116: CURSOR c2 IS SELECT jtf_dsp_sections_b_s1.nextval FROM dual;
117:
118: BEGIN

Line 116: CURSOR c2 IS SELECT jtf_dsp_sections_b_s1.nextval FROM dual;

112: l_deliverable_id NUMBER;
113:
114: CURSOR c IS SELECT rowid FROM jtf_dsp_sections_b
115: WHERE section_id = x_section_id;
116: CURSOR c2 IS SELECT jtf_dsp_sections_b_s1.nextval FROM dual;
117:
118: BEGIN
119:
120: -- Primary key validation check

Line 131: INSERT INTO jtf_dsp_sections_b

127: CLOSE c2;
128: END IF;
129:
130: -- insert base
131: INSERT INTO jtf_dsp_sections_b
132: (
133: section_id,
134: object_version_number,
135: access_name,

Line 321: UPDATE jtf_dsp_sections_b SET

317: IS
318: BEGIN
319:
320: -- update base
321: UPDATE jtf_dsp_sections_b SET
322: object_version_number = object_version_number + 1,
323: access_name = decode(p_access_name, FND_API.G_MISS_CHAR,
324: access_name, p_access_name),
325: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

Line 444: DELETE FROM jtf_dsp_sections_b

440: IF (sql%NOTFOUND) THEN
441: RAISE NO_DATA_FOUND;
442: END IF;
443:
444: DELETE FROM jtf_dsp_sections_b
445: WHERE section_id = p_section_id;
446:
447: IF (sql%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;

Line 650: FROM jtf_dsp_sections_b

646: l_tmp_sql_str VARCHAR2(240) := NULL;
647:
648: CURSOR c1(l_c_access_name IN VARCHAR2)
649: IS SELECT section_id
650: FROM jtf_dsp_sections_b
651: WHERE access_name = l_c_access_name;
652:
653: CURSOR c2(l_c_display_name IN VARCHAR2, l_c_tmp_sql_str IN VARCHAR2)
654: IS SELECT section_id

Line 1681: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b

1677: THEN
1678: -- If access_name specified and section_id is not specified, then
1679: -- query for section id
1680: BEGIN
1681: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b
1682: WHERE access_name = p_access_name;
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');

Line 1918: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b

1914: THEN
1915: -- 2. If access_name specified and section_id is not specified, then
1916: -- query for section id and delete all references
1917: BEGIN
1918: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b
1919: WHERE access_name = p_access_name;
1920: EXCEPTION
1921: WHEN NO_DATA_FOUND THEN
1922: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');

Line 2017: -- delete for jtf_dsp_sections_b and _tl tables

2013:
2014: -- delete for other tables (Templates, Media, etc)
2015: JTF_LOGICALCONTENT_GRP.Delete_Section(l_section_id);
2016:
2017: -- delete for jtf_dsp_sections_b and _tl tables
2018: delete_row(l_section_id);
2019:
2020: EXCEPTION
2021:

Line 2096: UPDATE jtf_dsp_sections_b

2092: -- 1. Update all rows with display_context_id set to null and
2093: -- object version number set to +1
2094:
2095: -- 1. update all rows
2096: UPDATE jtf_dsp_sections_b
2097: SET display_context_id = NULL,
2098: object_version_number = object_version_number + 1
2099: WHERE display_context_id = p_display_context_id;
2100:

Line 2190: UPDATE jtf_dsp_sections_b

2186: -- 1. Update all rows with deliverable_id set to null and
2187: -- object version number set to +1
2188:
2189: -- 1. update all rows
2190: UPDATE jtf_dsp_sections_b
2191: SET deliverable_id = NULL,
2192: object_version_number = object_version_number + 1
2193: WHERE deliverable_id = p_deliverable_id;
2194:

Line 2249: from JTF_DSP_SECTIONS_B B

2245: begin
2246: delete from JTF_DSP_SECTIONS_TL T
2247: where not exists
2248: (select NULL
2249: from JTF_DSP_SECTIONS_B B
2250: where B.SECTION_ID = T.SECTION_ID
2251: );
2252:
2253: update JTF_DSP_SECTIONS_TL T set (