APPS.JTF_DPF dependencies on JTF_DPF_LOGICAL_PAGES_TL

Line 98: t_log_page_descr jtf_dpf_logical_pages_tl.logical_page_description%type;

94: t_asn fnd_application.application_short_name%type;
95: t_def_phys_id jtf_dpf_lgcl_phy_rules.physical_page_id%type;
96: t_phys_page_name jtf_dpf_physical_pages_b.physical_page_name%type;
97: ddindx binary_integer := 1;
98: t_log_page_descr jtf_dpf_logical_pages_tl.logical_page_description%type;
99: begin
100: for c1_rec in c1(asn) loop
101: select application_short_name
102: into t_asn

Line 113: from jtf_dpf_logical_pages_tl o

109: where lpr.logical_page_id = c1_rec.logical_page_id and
110: lpr.default_page_flag='T'));
111:
112: select logical_page_description into t_log_page_descr
113: from jtf_dpf_logical_pages_tl o
114: where o.logical_page_id = c1_rec.logical_page_id and
115: o.language = p_lang;
116:
117: select lpr.physical_page_id

Line 1280: delete from jtf_dpf_logical_pages_tl

1276: procedure logical_delete(p_logical_page_id number) is
1277: begin
1278: delete from jtf_dpf_logical_pages_b
1279: where logical_page_id=p_logical_page_id;
1280: delete from jtf_dpf_logical_pages_tl
1281: where logical_page_id=p_logical_page_id;
1282: delete from jtf_dpf_lgcl_next_rules
1283: where logical_page_id=p_logical_page_id;
1284: delete from jtf_dpf_lgcl_phy_rules

Line 1335: update jtf_dpf_logical_pages_tl set

1331: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1332: where logical_page_id = p_logical_page_id;
1333:
1334: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
1335: update jtf_dpf_logical_pages_tl set
1336: logical_page_description = upd.p_new_descr,
1337: -- object_version_number = OBJECT_VERSION_NUMBER+1,
1338: last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,

Line 1464: -- insert into jtf_dpf_logical_pages_tl(

1460: -- FND_GLOBAL.USER_ID,
1461: -- FND_GLOBAL.CONC_LOGIN_ID)
1462: -- returning logical_page_id into t_new_logical_page_id;
1463: --
1464: -- insert into jtf_dpf_logical_pages_tl(
1465: -- logical_page_id,
1466: -- language,
1467: -- source_lang,
1468: -- logical_page_description,