eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_DPF dependencies on JTF_DPF_LOGICAL_PAGES_B

Line 7: t_head_log_name jtf_dpf_logical_pages_b.logical_page_name%type;

3: procedure get_dpf_tbl(p_lang varchar2, asn varchar2,
4: dpf out NOCOPY dpf_tbl) is
5: ddindx binary_integer := 1;
6: t_head_log_asn fnd_application.application_short_name%type;
7: t_head_log_name jtf_dpf_logical_pages_b.logical_page_name%type;
8: t_rtn_log_asn fnd_application.application_short_name%type;
9: t_rtn_log_name jtf_dpf_logical_pages_b.logical_page_name%type;
10: t_log_descr jtf_dpf_logical_flows_tl.logical_flow_description%type;
11:

Line 9: t_rtn_log_name jtf_dpf_logical_pages_b.logical_page_name%type;

5: ddindx binary_integer := 1;
6: t_head_log_asn fnd_application.application_short_name%type;
7: t_head_log_name jtf_dpf_logical_pages_b.logical_page_name%type;
8: t_rtn_log_asn fnd_application.application_short_name%type;
9: t_rtn_log_name jtf_dpf_logical_pages_b.logical_page_name%type;
10: t_log_descr jtf_dpf_logical_flows_tl.logical_flow_description%type;
11:
12: cursor c1 (pp_asn varchar2) is
13: select

Line 38: (select lp.application_id from jtf_dpf_logical_pages_b lp

34:
35: select application_short_name
36: into t_head_log_asn
37: from fnd_application fa where fa.application_id =
38: (select lp.application_id from jtf_dpf_logical_pages_b lp
39: where lp.logical_page_id = c1_rec.logical_flow_head_id);
40:
41: select lp2.logical_page_name
42: into t_head_log_name

Line 43: from jtf_dpf_logical_pages_b lp2

39: where lp.logical_page_id = c1_rec.logical_flow_head_id);
40:
41: select lp2.logical_page_name
42: into t_head_log_name
43: from jtf_dpf_logical_pages_b lp2
44: where lp2.logical_page_id = c1_rec.logical_flow_head_id;
45:
46: select application_short_name
47: into t_rtn_log_asn

Line 49: (select lp.application_id from jtf_dpf_logical_pages_b lp

45:
46: select application_short_name
47: into t_rtn_log_asn
48: from fnd_application fa where fa.application_id =
49: (select lp.application_id from jtf_dpf_logical_pages_b lp
50: where lp.logical_page_id = c1_rec.return_to_page_id);
51:
52: select lp2.logical_page_name
53: into t_rtn_log_name

Line 54: from jtf_dpf_logical_pages_b lp2

50: where lp.logical_page_id = c1_rec.return_to_page_id);
51:
52: select lp2.logical_page_name
53: into t_rtn_log_name
54: from jtf_dpf_logical_pages_b lp2
55: where lp2.logical_page_id = c1_rec.return_to_page_id;
56:
57: -- create the new record at index ddindx
58: dpf(ddindx).dpf_id := c1_rec.logical_flow_id;

Line 90: from jtf_dpf_logical_pages_b lp

86: -- lp.logical_page_description,
87: lp.page_controller_class,
88: lp.page_permission_name,
89: lp.logical_page_id
90: from jtf_dpf_logical_pages_b lp
91: where lp.application_id =
92: (select application_id from fnd_application fa2
93: where fa2.application_short_name = pp_asn);
94: t_asn fnd_application.application_short_name%type;

Line 189: from jtf_dpf_logical_pages_b lp, jtf_dpf_lgcl_phy_rules lpr

185: lp.logical_page_name,
186: lpr.rule_eval_sequence,
187: lpr.physical_page_id,
188: lpr.rule_id
189: from jtf_dpf_logical_pages_b lp, jtf_dpf_lgcl_phy_rules lpr
190: where
191: lp.logical_page_id = lpr.logical_page_id and
192: lp.application_id =
193: (select application_id from fnd_application fa where

Line 291: q3_c2 jtf_dpf_logical_pages_b.logical_page_name%type;

287: where lnr.logical_flow_id = pp_q1_c2 and
288: lnr.default_next_flag='T';
289: ddindx binary_integer := 1;
290: q3_c1 fnd_application.application_short_name%type;
291: q3_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
292: q4_c1 fnd_application.application_short_name%type;
293: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
294: q3_c1_temp fnd_application.application_id%type;
295: q4_c1_temp fnd_application.application_id%type;

Line 293: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;

289: ddindx binary_integer := 1;
290: q3_c1 fnd_application.application_short_name%type;
291: q3_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
292: q4_c1 fnd_application.application_short_name%type;
293: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
294: q3_c1_temp fnd_application.application_id%type;
295: q4_c1_temp fnd_application.application_id%type;
296: begin
297: for q1_rec in q1(asn) loop

Line 305: from jtf_dpf_logical_pages_b lp

301: -- (select application_short_name from fnd_application fa
302: -- where fa.application_id = lp.application_id),
303: lp.logical_page_name
304: into q3_c1_temp, q3_c2
305: from jtf_dpf_logical_pages_b lp
306: where lp.logical_page_id = q2_rec.logical_page_id;
307:
308: select application_short_name into q3_c1
309: from fnd_application where application_id = q3_c1_temp;

Line 317: from jtf_dpf_logical_pages_b lp

313: -- (select application_short_name from fnd_application fa
314: -- where fa.application_id = lp.application_id),
315: lp.logical_page_name
316: into q4_c1_temp, q4_c2
317: from jtf_dpf_logical_pages_b lp
318: where lp.logical_page_id = q2_rec.logical_next_page_id;
319:
320: select application_short_name into q4_c1
321: from fnd_application where application_id = q4_c1_temp;

Line 359: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;

355: ddindx binary_integer := 1;
356: q3_c1 fnd_application.application_short_name%type;
357: q3_c2 jtf_dpf_rules_b.rule_name%type;
358: q4_c1 fnd_application.application_short_name%type;
359: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
360: q5_c1 fnd_application.application_short_name%type;
361: q5_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
362: q3_c1_temp fnd_application.application_id%type;
363: q4_c1_temp fnd_application.application_id%type;

Line 361: q5_c2 jtf_dpf_logical_pages_b.logical_page_name%type;

357: q3_c2 jtf_dpf_rules_b.rule_name%type;
358: q4_c1 fnd_application.application_short_name%type;
359: q4_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
360: q5_c1 fnd_application.application_short_name%type;
361: q5_c2 jtf_dpf_logical_pages_b.logical_page_name%type;
362: q3_c1_temp fnd_application.application_id%type;
363: q4_c1_temp fnd_application.application_id%type;
364: q5_c1_temp fnd_application.application_id%type;
365: begin

Line 388: from jtf_dpf_logical_pages_b lp

384: -- (select application_short_name from fnd_application fa
385: -- where fa.application_id = lp.application_id),
386: lp.logical_page_name
387: into q4_c1_temp, q4_c2
388: from jtf_dpf_logical_pages_b lp
389: where lp.logical_page_id = q2_rec.logical_page_id;
390:
391: select application_short_name
392: into q4_c1

Line 402: from jtf_dpf_logical_pages_b lp

398: -- (select application_short_name from fnd_application fa
399: -- where fa.application_id = lp.application_id),
400: lp.logical_page_name
401: into q5_c1_temp, q5_c2
402: from jtf_dpf_logical_pages_b lp
403: where lp.logical_page_id = q2_rec.logical_next_page_id;
404:
405: select application_short_name
406: into q5_c1

Line 895: -- the jtf_dpf_logical_pages_b table.

891:
892: -- is either logical_page_id bad? The logical_page_id variables are
893: -- p_new_header_logical_page_id and p_rtn_to_logical_page_id. One of these
894: -- is 'bad' if it's not G_MISS_NUM and it doesn't point at a logical in
895: -- the jtf_dpf_logical_pages_b table.
896: --
897: -- if either is bad, then return 4.
898:
899: if upd.p_new_header_logical_page_id is null or

Line 906: from jtf_dpf_logical_pages_b

902: end if;
903:
904: if fnd_api.g_miss_num <> upd.p_new_header_logical_page_id then
905: select count(*) into existential
906: from jtf_dpf_logical_pages_b
907: where logical_page_id = upd.p_new_header_logical_page_id;
908: if existential = 0 then return 4; end if;
909: end if;
910:

Line 913: from jtf_dpf_logical_pages_b

909: end if;
910:
911: if fnd_api.g_miss_num <> upd.p_rtn_to_logical_page_id then
912: select count(*) into existential
913: from jtf_dpf_logical_pages_b
914: where logical_page_id = upd.p_rtn_to_logical_page_id;
915: if existential = 0 then return 4; end if;
916: end if;
917:

Line 1006: from jtf_dpf_logical_pages_b

1002: p_rtn_to_logical_page_id is null then
1003: return 4;
1004: end if;
1005: select count(*) into existential
1006: from jtf_dpf_logical_pages_b
1007: where logical_page_id = p_new_header_logical_page_id;
1008: if existential = 0 then return 4; end if;
1009: select count(*) into existential
1010: from jtf_dpf_logical_pages_b

Line 1010: from jtf_dpf_logical_pages_b

1006: from jtf_dpf_logical_pages_b
1007: where logical_page_id = p_new_header_logical_page_id;
1008: if existential = 0 then return 4; end if;
1009: select count(*) into existential
1010: from jtf_dpf_logical_pages_b
1011: where logical_page_id = p_rtn_to_logical_page_id;
1012: if existential = 0 then return 4; end if;
1013:
1014: select application_id into t_appid

Line 1278: delete from jtf_dpf_logical_pages_b

1274: -- removes the logical from JTF_DPF_LOGICAL_PAGES. Also removes
1275: -- any jtf_dpf_lgcl_phy_rules with the same logical_page_id
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

Line 1314: from jtf_dpf_logical_pages_b

1310: -- is the proposed new name already taken? count the number
1311: -- of rows which already have this name, but which have a different
1312: -- logical_flow_id
1313: select count(*) into existential
1314: from jtf_dpf_logical_pages_b
1315: where logical_page_id <> p_logical_page_id and
1316: logical_page_name = upd.p_new_name and
1317: application_id = t_appid;
1318:

Line 1321: update jtf_dpf_logical_pages_b set

1317: application_id = t_appid;
1318:
1319: if existential > 0 then return 2; end if;
1320:
1321: update jtf_dpf_logical_pages_b set
1322: logical_page_name = upd.p_new_name,
1323: logical_page_type = upd.p_new_type,
1324: application_id = t_appid,
1325: -- logical_page_description = upd.p_new_descr,

Line 1406: from jtf_dpf_logical_pages_b

1402: from fnd_application where application_short_name = p_new_asn;
1403:
1404: -- if a logical with this name and appid already exist, then return 2
1405: select count(*) into existential
1406: from jtf_dpf_logical_pages_b
1407: where application_id = t_appid and
1408: logical_page_name = p_new_name;
1409:
1410: if existential <> 0 then return 2; end if;

Line 1432: -- insert into jtf_dpf_logical_pages_b(

1428: X_LAST_UPDATE_DATE => SYSDATE,
1429: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1430: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1431:
1432: -- insert into jtf_dpf_logical_pages_b(
1433: -- enabled_flag,
1434: -- logical_page_id,
1435: -- logical_page_name,
1436: -- logical_page_type,

Line 1583: from jtf_dpf_logical_pages_b

1579:
1580: -- see if this is an error case; return '2' if either p_log_page_id
1581: -- isn't there, or if p_next_log_page_id is both not null and not there
1582: select count(*) into existential
1583: from jtf_dpf_logical_pages_b
1584: where logical_page_id = p_log_page_id;
1585:
1586: if existential = 0 then return 2; end if;
1587:

Line 1590: from jtf_dpf_logical_pages_b

1586: if existential = 0 then return 2; end if;
1587:
1588: if p_next_log_page_id is not null then
1589: select count(*) into existential
1590: from jtf_dpf_logical_pages_b
1591: where logical_page_id = p_next_log_page_id;
1592:
1593: if existential = 0 then return 2; end if;
1594: end if;