APPS.JTF_DPF dependencies on JTF_DPF_PHYSICAL_PAGES_TL

Line 160: t_phys_page_descr jtf_dpf_physical_pages_tl.physical_page_description%type;

156: where pp.application_id =
157: (select fa.application_id from fnd_application fa
158: where fa.application_short_name = pp_asn);
159: ddindx binary_integer := 1;
160: t_phys_page_descr jtf_dpf_physical_pages_tl.physical_page_description%type;
161: begin
162: for c1_rec in c1(asn) loop
163: select physical_page_description into t_phys_page_descr
164: from jtf_dpf_physical_pages_tl ptl

Line 164: from jtf_dpf_physical_pages_tl ptl

160: t_phys_page_descr jtf_dpf_physical_pages_tl.physical_page_description%type;
161: begin
162: for c1_rec in c1(asn) loop
163: select physical_page_description into t_phys_page_descr
164: from jtf_dpf_physical_pages_tl ptl
165: where ptl.physical_page_id = c1_rec.physical_page_id and
166: ptl.language = p_lang;
167: -- create the new record
168: log(ddindx).id := c1_rec.physical_page_id;

Line 687: delete from jtf_dpf_physical_pages_tl where physical_page_id=p_ppid;

683: -- then this has no effect.
684: procedure phys_delete(p_ppid number) is
685: begin
686: delete from jtf_dpf_physical_pages_b where physical_page_id=p_ppid;
687: delete from jtf_dpf_physical_pages_tl where physical_page_id=p_ppid;
688: -- commit;
689: end;
690:
691: function phys_update(p_ppid number,

Line 725: update jtf_dpf_physical_pages_tl

721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
722: where physical_page_id = p_ppid;
723:
724: if upd.p_descr is null or fnd_api.g_miss_char <> upd.p_descr then
725: update jtf_dpf_physical_pages_tl
726: set
727: physical_page_description = upd.p_descr,
728: -- object_version_number = OBJECT_VERSION_NUMBER+1,
729: last_update_date = sysdate,

Line 837: -- insert into jtf_dpf_physical_pages_tl(

833: -- SYSDATE,
834: -- FND_GLOBAL.USER_ID,
835: -- FND_GLOBAL.CONC_LOGIN_ID);
836: --
837: -- insert into jtf_dpf_physical_pages_tl(
838: -- PHYSICAL_PAGE_ID,
839: -- LANGUAGE,
840: -- SOURCE_LANG,
841: -- PHYSICAL_PAGE_DESCRIPTION,