APPS.OE_UI_QUERIES_PKG dependencies on OE_UI_QUERIES_TL

Line 21: cursor C is select ROWID from OE_UI_QUERIES_TL

17: X_ORG_ACCESS_TYPE in VARCHAR2 default NULL,
18: X_ORG_ID in NUMBER default NULL
19: ) is
20: X_ROWID ROWID;
21: cursor C is select ROWID from OE_UI_QUERIES_TL
22: where QUERY_ID = X_QUERY_ID
23: and LANGUAGE = userenv('LANG')
24: ;
25: begin

Line 26: insert into OE_UI_QUERIES_TL (

22: where QUERY_ID = X_QUERY_ID
23: and LANGUAGE = userenv('LANG')
24: ;
25: begin
26: insert into OE_UI_QUERIES_TL (
27: CREATION_DATE,
28: CREATED_BY,
29: LAST_UPDATE_DATE,
30: LAST_UPDATED_BY,

Line 82: from OE_UI_QUERIES_TL

78: cursor c1 is select
79: PUBLIC_FLAG,
80: NAME,
81: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
82: from OE_UI_QUERIES_TL
83: where QUERY_ID = X_QUERY_ID
84: for update of QUERY_ID nowait;
85: begin
86: for tlinfo in c1 loop

Line 113: update OE_UI_QUERIES_TL set

109: X_LAST_UPDATED_BY in NUMBER,
110: X_LAST_UPDATE_LOGIN in NUMBER
111: ) is
112: begin
113: update OE_UI_QUERIES_TL set
114: DELETE_FLAG = X_DELETE_FLAG,
115: PUBLIC_FLAG = X_PUBLIC_FLAG,
116: NAME = X_NAME,
117: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 133: delete from OE_UI_QUERIES_TL

129: procedure DELETE_ROW (
130: X_QUERY_ID in NUMBER
131: ) is
132: begin
133: delete from OE_UI_QUERIES_TL
134: where QUERY_ID = X_QUERY_ID;
135:
136: if (sql%notfound) then
137: raise no_data_found;