91: ELSE
92: page_code := x_page_code;
93: END IF;
94:
95: FND_PROFILE.GET('USER_ID', created_by);
96:
97: creation_date := SYSDATE;
98:
99: last_updated_by := created_by;
99: last_updated_by := created_by;
100:
101: last_update_date := SYSDATE;
102:
103: FND_PROFILE.GET('LOGIN_ID', last_update_login);
104:
105: FND_PROFILE.GET('CONC_PROGRAM_ID', program_id);
106:
107: FND_PROFILE.GET('CONC_LOGIN_ID', program_login_id);
101: last_update_date := SYSDATE;
102:
103: FND_PROFILE.GET('LOGIN_ID', last_update_login);
104:
105: FND_PROFILE.GET('CONC_PROGRAM_ID', program_id);
106:
107: FND_PROFILE.GET('CONC_LOGIN_ID', program_login_id);
108:
109: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', program_app_id);
103: FND_PROFILE.GET('LOGIN_ID', last_update_login);
104:
105: FND_PROFILE.GET('CONC_PROGRAM_ID', program_id);
106:
107: FND_PROFILE.GET('CONC_LOGIN_ID', program_login_id);
108:
109: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', program_app_id);
110:
111: FND_PROFILE.GET('CONC_REQUEST_ID', request_id);
105: FND_PROFILE.GET('CONC_PROGRAM_ID', program_id);
106:
107: FND_PROFILE.GET('CONC_LOGIN_ID', program_login_id);
108:
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,
107: FND_PROFILE.GET('CONC_LOGIN_ID', program_login_id);
108:
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,
162:
163: BEGIN
164: x_obj_ver_number := 1;
165:
166: FND_PROFILE.GET('USER_ID', x_last_updated_by);
167:
168: x_last_update_date := SYSDATE;
169:
170: FND_PROFILE.GET('LOGIN_ID', x_last_update_login);
166: FND_PROFILE.GET('USER_ID', x_last_updated_by);
167:
168: x_last_update_date := SYSDATE;
169:
170: FND_PROFILE.GET('LOGIN_ID', x_last_update_login);
171:
172: FND_PROFILE.GET('CONC_PROGRAM_ID', x_program_id);
173:
174: FND_PROFILE.GET('CONC_LOGIN_ID', x_program_login_id);
168: x_last_update_date := SYSDATE;
169:
170: FND_PROFILE.GET('LOGIN_ID', x_last_update_login);
171:
172: FND_PROFILE.GET('CONC_PROGRAM_ID', x_program_id);
173:
174: FND_PROFILE.GET('CONC_LOGIN_ID', x_program_login_id);
175:
176: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', x_program_app_id);
170: FND_PROFILE.GET('LOGIN_ID', x_last_update_login);
171:
172: FND_PROFILE.GET('CONC_PROGRAM_ID', x_program_id);
173:
174: FND_PROFILE.GET('CONC_LOGIN_ID', x_program_login_id);
175:
176: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', x_program_app_id);
177:
178: FND_PROFILE.GET('CONC_REQUEST_ID', x_request_id);
172: FND_PROFILE.GET('CONC_PROGRAM_ID', x_program_id);
173:
174: FND_PROFILE.GET('CONC_LOGIN_ID', x_program_login_id);
175:
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
174: FND_PROFILE.GET('CONC_LOGIN_ID', x_program_login_id);
175:
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,