APPS.ICX_LOGIN dependencies on ICX_PAGES

Line 116: from icx_pages

112:
113: begin
114: select min(PAGE_ID)
115: into l_page_id
116: from icx_pages
117: where user_id = p_user_id
118: and PAGE_TYPE = 'USER';
119: exception
120: when NO_DATA_FOUND then

Line 127: select icx_pages_s.nextval, icx_page_plugs_s.nextval

123:
124: if l_page_id is null
125: then
126:
127: select icx_pages_s.nextval, icx_page_plugs_s.nextval
128: into l_page_id,l_plug_id
129: from sys.dual;
130:
131: select nvl(max(sequence_number),1)

Line 133: from icx_pages

129: from sys.dual;
130:
131: select nvl(max(sequence_number),1)
132: into l_sequence_number
133: from icx_pages
134: where user_id = icx_sec.g_user_id;
135:
136: l_main_region_id := icx_api_region.create_main_region;
137:

Line 139: -- rows in icx_pages as wells as icx_pages_tl

135:
136: l_main_region_id := icx_api_region.create_main_region;
137:
138: -- to make old PHP user data compatible with new PHP we need to insert
139: -- rows in icx_pages as wells as icx_pages_tl
140: --
141: -- 1388074 mputman added substrb to wf_core call
142:
143: ICX_PAGES_PKG.INSERT_ROW(

Line 143: ICX_PAGES_PKG.INSERT_ROW(

139: -- rows in icx_pages as wells as icx_pages_tl
140: --
141: -- 1388074 mputman added substrb to wf_core call
142:
143: ICX_PAGES_PKG.INSERT_ROW(
144: x_rowid => l_rowid,
145: x_page_id => l_page_id,
146: x_page_code => 'ICX_PAGE_' || l_page_id,
147: x_main_region_id => l_main_region_id,

Line 160: --insert into icx_pages

156: x_last_update_date => sysdate,
157: x_last_updated_by => 1,
158: x_last_update_login => 1);
159:
160: --insert into icx_pages
161: --(page_id,
162: -- page_name,
163: -- page_type,
164: -- page_description,

Line 260: from ICX_PAGES

256: ** page
257: */
258: select MIN(page_id)
259: into l_page_id
260: from ICX_PAGES
261: where user_id = p_user_id
262: and page_type = 'USER';
263:
264: return l_page_id;