APPS.JTF_DPF_LOGICAL_PAGES_PKG dependencies on JTF_DPF_LOGICAL_PAGES_B

Line 7: from jtf_dpf_logical_pages_b

3: -- select instances of this rule, identified by appid and name
4: cursor get_logical_id(
5: x_logical_page_name varchar2,
6: x_application_id number) is select logical_page_id
7: from jtf_dpf_logical_pages_b
8: where application_id = x_application_id and
9: logical_page_name=x_logical_page_name;
10:
11: procedure INSERT_ROW (

Line 28: cursor C is select ROWID from JTF_DPF_LOGICAL_PAGES_B

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from JTF_DPF_LOGICAL_PAGES_B
29: where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
30: ;
31: begin
32: insert into JTF_DPF_LOGICAL_PAGES_B (

Line 32: insert into JTF_DPF_LOGICAL_PAGES_B (

28: cursor C is select ROWID from JTF_DPF_LOGICAL_PAGES_B
29: where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
30: ;
31: begin
32: insert into JTF_DPF_LOGICAL_PAGES_B (
33: LOGICAL_PAGE_ID,
34: LOGICAL_PAGE_NAME,
35: LOGICAL_PAGE_TYPE,
36: APPLICATION_ID,

Line 117: from JTF_DPF_LOGICAL_PAGES_B

113: ENABLED_FLAG,
114: PAGE_CONTROLLER_CLASS,
115: PAGE_PERMISSION_NAME,
116: OBJECT_VERSION_NUMBER
117: from JTF_DPF_LOGICAL_PAGES_B
118: where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
119: for update of LOGICAL_PAGE_ID nowait;
120: recinfo c%rowtype;
121:

Line 185: update JTF_DPF_LOGICAL_PAGES_B set

181: X_LAST_UPDATED_BY in NUMBER,
182: X_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update JTF_DPF_LOGICAL_PAGES_B set
186: LOGICAL_PAGE_NAME = X_LOGICAL_PAGE_NAME,
187: LOGICAL_PAGE_TYPE = X_LOGICAL_PAGE_TYPE,
188: APPLICATION_ID = X_APPLICATION_ID,
189: ENABLED_FLAG = X_ENABLED_FLAG,

Line 227: delete from JTF_DPF_LOGICAL_PAGES_B

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from JTF_DPF_LOGICAL_PAGES_B
228: where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID;
229:
230: if (sql%notfound) then
231: raise no_data_found;

Line 241: from JTF_DPF_LOGICAL_PAGES_B B

237: begin
238: delete from JTF_DPF_LOGICAL_PAGES_TL T
239: where not exists
240: (select NULL
241: from JTF_DPF_LOGICAL_PAGES_B B
242: where B.LOGICAL_PAGE_ID = T.LOGICAL_PAGE_ID
243: );
244:
245: update JTF_DPF_LOGICAL_PAGES_TL T set (

Line 392: -- from jtf_dpf_logical_pages_b

388: -- get a new pseudo-sequence number
389: -- arsingh: prevent use of same id by different threads.
390: select JTF_DPF_LOGICAL_PAGES_S.nextval into t_new_logical_id from dual;
391: -- select max(logical_page_id) into t_new_logical_id
392: -- from jtf_dpf_logical_pages_b
393: -- where logical_page_id < 10000;
394: -- if t_new_logical_id is null then
395: -- t_new_logical_id := 1;
396: -- else