APPS.IBW_PAGES_PUB dependencies on IBW_PAGES_B

Line 46: FROM ibw_pages_b

42: IS
43: CURSOR c
44: IS
45: SELECT ROWID
46: FROM ibw_pages_b
47: WHERE page_id = x_page_id;
48:
49: l_prog_appl_id ibw_pages_b.program_application_id%TYPE; -- Code Added, Notgenerated by AFTBLGEN
50: l_program_id ibw_pages_b.program_id%TYPE; -- Code Added, Not generated by AFTBLGEN

Line 49: l_prog_appl_id ibw_pages_b.program_application_id%TYPE; -- Code Added, Notgenerated by AFTBLGEN

45: SELECT ROWID
46: FROM ibw_pages_b
47: WHERE page_id = x_page_id;
48:
49: l_prog_appl_id ibw_pages_b.program_application_id%TYPE; -- Code Added, Notgenerated by AFTBLGEN
50: l_program_id ibw_pages_b.program_id%TYPE; -- Code Added, Not generated by AFTBLGEN
51: BEGIN
52:
53: dbms_output.put_line('Insert row called');

Line 50: l_program_id ibw_pages_b.program_id%TYPE; -- Code Added, Not generated by AFTBLGEN

46: FROM ibw_pages_b
47: WHERE page_id = x_page_id;
48:
49: l_prog_appl_id ibw_pages_b.program_application_id%TYPE; -- Code Added, Notgenerated by AFTBLGEN
50: l_program_id ibw_pages_b.program_id%TYPE; -- Code Added, Not generated by AFTBLGEN
51: BEGIN
52:
53: dbms_output.put_line('Insert row called');
54: l_prog_appl_id := fnd_global.prog_appl_id; -- Code Added,Not generatedby AFTBLGEN

Line 67: INSERT INTO IBW_PAGES_B

63: x_last_update_login
64: );
65: END IF;
66: dbms_output.put_line('Site area found');
67: INSERT INTO IBW_PAGES_B
68: (page_id, page_code, page_status,
69: application_context, business_context, REFERENCE,
70: page_matching_criteria, site_area_id,
71: page_matching_value, object_version_number,

Line 94: FROM ibw_pages_b M, fnd_languages l, fnd_languages b

90: program_id, program_login_id, program_application_id, request_id)
91: SELECT M.page_id, l.language_code, b.language_code, x_page_name, x_description, M.created_by, M.creation_date,
92: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,
93: M.program_id, M.program_login_id, M.program_application_id, M.request_id
94: FROM ibw_pages_b M, fnd_languages l, fnd_languages b
95: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.page_id=x_page_id;
96:
97: dbms_output.put_line('Site area found');
98:

Line 134: FROM IBW_PAGES_B

130: SELECT page_code, page_status, application_context,
131: business_context, REFERENCE, page_matching_criteria,
132: site_area_id, page_matching_value,
133: object_version_number, program_login_id, request_id
134: FROM IBW_PAGES_B
135: WHERE page_id = x_page_id
136: FOR UPDATE OF page_id NOWAIT;
137:
138: recinfo c%ROWTYPE;

Line 250: UPDATE IBW_PAGES_B

246: IS
247: BEGIN
248: IF (x_custom_mode = 'FORCE')
249: THEN
250: UPDATE IBW_PAGES_B
251: SET REFERENCE = x_reference,
252: object_version_number = x_object_version_number,
253: program_login_id = x_program_login_id,
254: request_id = x_request_id,

Line 260: UPDATE IBW_PAGES_B

256: last_updated_by = x_last_updated_by,
257: last_update_login = x_last_update_login
258: WHERE page_id = x_page_id;
259: ELSE
260: UPDATE IBW_PAGES_B
261: SET page_code = x_page_code,
262: page_status = x_page_status,
263: application_context = x_application_context,
264: business_context = x_business_context,

Line 311: DELETE FROM ibw_pages_b

307: THEN
308: RAISE NO_DATA_FOUND;
309: END IF;
310:
311: DELETE FROM ibw_pages_b
312: WHERE page_id = x_page_id;
313:
314: IF (SQL%NOTFOUND)
315: THEN

Line 325: FROM IBW_PAGES_B b

321: IS
322: BEGIN
323: DELETE FROM IBW_PAGES_TL t
324: WHERE NOT EXISTS (SELECT NULL
325: FROM IBW_PAGES_B b
326: WHERE b.page_id = t.page_id);
327:
328: UPDATE IBW_PAGES_TL t
329: SET (page_name, description) =

Line 452: FROM IBW_PAGES_B

448: SELECT page_id, last_updated_by, last_update_date,
449: object_version_number
450: INTO pg_id, db_luby, db_ludate,
451: obj_v_no
452: FROM IBW_PAGES_B
453: WHERE page_id = x_page_id;
454:
455: IF (fnd_load_util.upload_test (f_luby,
456: f_ludate,