APPS.JTF_DPF_PHYSICAL_PAGES_PKG dependencies on JTF_DPF_PHYSICAL_PAGES_B

Line 7: from jtf_dpf_physical_pages_b

3: -- all pages which match the name and appid, and which are seed data
4: cursor find_match_with_owner (p_page_name varchar2, p_application_id number,
5: x_last_updated_by number) is
6: select physical_page_id
7: from jtf_dpf_physical_pages_b
8: where physical_page_name = p_page_name and
9: application_id = p_application_id and
10: last_updated_by = x_last_updated_by
11: order by last_update_date;

Line 16: from jtf_dpf_physical_pages_b

12:
13: -- same query, without the last_updated_by test
14: cursor find_match(p_page_name varchar2, p_application_id number) is
15: select physical_page_id
16: from jtf_dpf_physical_pages_b
17: where physical_page_name = p_page_name and
18: application_id = p_application_id
19: order by last_update_date;
20:

Line 34: cursor C is select ROWID from JTF_DPF_PHYSICAL_PAGES_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from JTF_DPF_PHYSICAL_PAGES_B
35: where PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID
36: ;
37: begin
38: insert into JTF_DPF_PHYSICAL_PAGES_B (

Line 38: insert into JTF_DPF_PHYSICAL_PAGES_B (

34: cursor C is select ROWID from JTF_DPF_PHYSICAL_PAGES_B
35: where PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID
36: ;
37: begin
38: insert into JTF_DPF_PHYSICAL_PAGES_B (
39: PHYSICAL_PAGE_ID,
40: PHYSICAL_PAGE_NAME,
41: APPLICATION_ID,
42: OBJECT_VERSION_NUMBER,

Line 107: from JTF_DPF_PHYSICAL_PAGES_B

103: cursor c is select
104: PHYSICAL_PAGE_NAME,
105: APPLICATION_ID,
106: OBJECT_VERSION_NUMBER
107: from JTF_DPF_PHYSICAL_PAGES_B
108: where PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID
109: for update of PHYSICAL_PAGE_ID nowait;
110: recinfo c%rowtype;
111:

Line 164: update JTF_DPF_PHYSICAL_PAGES_B set

160: X_LAST_UPDATED_BY in NUMBER,
161: X_LAST_UPDATE_LOGIN in NUMBER
162: ) is
163: begin
164: update JTF_DPF_PHYSICAL_PAGES_B set
165: PHYSICAL_PAGE_NAME = X_PHYSICAL_PAGE_NAME,
166: APPLICATION_ID = X_APPLICATION_ID,
167: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
168: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 202: delete from JTF_DPF_PHYSICAL_PAGES_B

198: if (sql%notfound) then
199: raise no_data_found;
200: end if;
201:
202: delete from JTF_DPF_PHYSICAL_PAGES_B
203: where PHYSICAL_PAGE_ID = X_PHYSICAL_PAGE_ID;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 216: from JTF_DPF_PHYSICAL_PAGES_B B

212: begin
213: delete from JTF_DPF_PHYSICAL_PAGES_TL T
214: where not exists
215: (select NULL
216: from JTF_DPF_PHYSICAL_PAGES_B B
217: where B.PHYSICAL_PAGE_ID = T.PHYSICAL_PAGE_ID
218: );
219:
220: update JTF_DPF_PHYSICAL_PAGES_TL T set (

Line 340: -- jtf_dpf_physical_pages_b where physical_page_id<10000;

336: l_new_phys_id := null;
337: -- arsingh: prevent use of same id by different threads.
338: select JTF_DPF_PHYSICAL_PAGES_S.nextval into l_new_phys_id from dual;
339: -- select max(physical_page_id) into l_new_phys_id from
340: -- jtf_dpf_physical_pages_b where physical_page_id<10000;
341: -- if l_new_phys_id is null then
342: -- l_new_phys_id := 1;
343: -- else
344: -- l_new_phys_id := l_new_phys_id+1;