APPS.IBW_PAGES_PVT dependencies on IBW_PAGES_B

Line 15: -- Offline engine uses this API to insert and update IBW_PAGES_B and IBW_PAGES_TL tables.

11: -- PURPOSE
12: -- Private API for inserting and updating pages. Mainly used by offline engine
13: --
14: -- NOTES
15: -- Offline engine uses this API to insert and update IBW_PAGES_B and IBW_PAGES_TL tables.
16:
17: -- HISTORY
18: -- 05/09/2005 VEKANCHA Created
19:

Line 70: CURSOR c IS SELECT ibw_pages_b_s1.nextval FROM dual;

66: program_login_id NUMBER;
67: program_app_id NUMBER;
68: request_id NUMBER;
69:
70: CURSOR c IS SELECT ibw_pages_b_s1.nextval FROM dual;
71:
72: CURSOR c1 IS SELECT page_id FROM ibw_pages_b
73: WHERE page_id = x_page_id;
74:

Line 72: CURSOR c1 IS SELECT page_id FROM ibw_pages_b

68: request_id NUMBER;
69:
70: CURSOR c IS SELECT ibw_pages_b_s1.nextval FROM dual;
71:
72: CURSOR c1 IS SELECT page_id FROM ibw_pages_b
73: WHERE page_id = x_page_id;
74:
75: CURSOR c2 IS SELECT ibw_pages_b_s2.nextval FROM dual;
76:

Line 75: CURSOR c2 IS SELECT ibw_pages_b_s2.nextval FROM dual;

71:
72: CURSOR c1 IS SELECT page_id FROM ibw_pages_b
73: WHERE page_id = x_page_id;
74:
75: CURSOR c2 IS SELECT ibw_pages_b_s2.nextval FROM dual;
76:
77: BEGIN
78: page_status := 'Y';
79: obj_ver_number := 1;

Line 113: INSERT INTO ibw_pages_b (page_id, page_code, page_status, application_context, business_context, reference,site_area_id,

109: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', program_app_id);
110:
111: FND_PROFILE.GET('CONC_REQUEST_ID', request_id);
112:
113: INSERT INTO ibw_pages_b (page_id, page_code, page_status, application_context, business_context, reference,site_area_id,
114: page_matching_criteria, page_matching_value, created_by, creation_date,
115: last_updated_by, last_update_date, last_update_login, object_version_number,
116: program_id, program_login_id, program_application_id, request_id)
117: VALUES (x_page_id, page_code, page_status, x_app_context, x_bus_context, x_reference, site_area_id,

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

124: program_id, program_login_id, program_application_id, request_id)
125: SELECT M.page_id, l.language_code, b.language_code, x_page_name, x_description, M.created_by, M.creation_date,
126: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,
127: M.program_id, M.program_login_id, M.program_application_id, M.request_id
128: FROM ibw_pages_b M, fnd_languages l, fnd_languages b
129: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.page_id=x_page_id;
130:
131: OPEN c1;
132: FETCH c1 INTO page_id;

Line 180: UPDATE ibw_pages_b

176: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', x_program_app_id);
177:
178: FND_PROFILE.GET('CONC_REQUEST_ID', x_request_id);
179:
180: UPDATE ibw_pages_b
181: SET reference=x_reference, last_updated_by=x_last_updated_by, last_update_date=x_last_update_date,
182: last_update_login=x_last_update_login, object_version_number=object_version_number+1,
183: program_id=x_program_id, program_login_id=x_program_login_id, program_application_id=x_program_app_id,
184: request_id=x_request_id