APPS.AP_WEB_DB_PAGE_SETTING_PKG dependencies on OIE_CURRENT_PAGE_SETTING

Line 33: FROM OIE_CURRENT_PAGE_SETTING

29: PRAGMA AUTONOMOUS_TRANSACTION;
30:
31: CURSOR settingCursor IS
32: SELECT *
33: FROM OIE_CURRENT_PAGE_SETTING
34: WHERE user_id = p_userId
35: AND page_Name = p_pageName
36: AND object_Name = p_objectName
37: AND object_Type_code = p_objectTypeCode

Line 50: INSERT INTO OIE_CURRENT_PAGE_SETTING(

46: FETCH settingCursor INTO settingRec;
47:
48: IF settingCursor%NOTFOUND THEN
49: -- create new record
50: INSERT INTO OIE_CURRENT_PAGE_SETTING(
51: USER_ID,
52: PAGE_NAME,
53: OBJECT_NAME,
54: OBJECT_TYPE_CODE,

Line 81: UPDATE OIE_CURRENT_PAGE_SETTING

77: nvl(fnd_global.user_id, -1));
78:
79: ELSE
80: -- update the current record
81: UPDATE OIE_CURRENT_PAGE_SETTING
82: SET hide_flag = p_hideFlag,
83: selected_tab = p_selectedTab,
84: sorted_column = p_sortedColumn,
85: sort_order_code = p_sortOrderCode