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_LGCL_PHY_RULES

Line 95: t_def_phys_id jtf_dpf_lgcl_phy_rules.physical_page_id%type;

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;
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

Line 108: (select lpr.physical_page_id from jtf_dpf_lgcl_phy_rules lpr

104: where fa.application_id =
105: (select pp.application_id
106: from jtf_dpf_physical_pages_b pp
107: where pp.physical_page_id =
108: (select lpr.physical_page_id from jtf_dpf_lgcl_phy_rules lpr
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

Line 119: from jtf_dpf_lgcl_phy_rules lpr

115: o.language = p_lang;
116:
117: select lpr.physical_page_id
118: into t_def_phys_id
119: from jtf_dpf_lgcl_phy_rules lpr
120: where lpr.logical_page_id = c1_rec.logical_page_id and
121: lpr.default_page_flag = 'T';
122:
123: select pp.physical_page_name

Line 127: (select lpr.physical_page_id from jtf_dpf_lgcl_phy_rules lpr

123: select pp.physical_page_name
124: into t_phys_page_name
125: from jtf_dpf_physical_pages_b pp
126: where pp.physical_page_id =
127: (select lpr.physical_page_id from jtf_dpf_lgcl_phy_rules lpr
128: where lpr.logical_page_id = c1_rec.logical_page_id and
129: lpr.default_page_flag = 'T');
130:
131: -- create the new record

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 1273: -- - jtf_dpf_lgcl_phy_rules

1269: -- logical editing procedures:
1270: -- removes any instances with logical_page_id from tables:
1271: -- - jtf_dpf_logical_pages
1272: -- - jtf_dpf_lgcl_next_rules
1273: -- - jtf_dpf_lgcl_phy_rules
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

Line 1275: -- any jtf_dpf_lgcl_phy_rules with the same logical_page_id

1271: -- - jtf_dpf_logical_pages
1272: -- - jtf_dpf_lgcl_next_rules
1273: -- - jtf_dpf_lgcl_phy_rules
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;

Line 1284: delete from jtf_dpf_lgcl_phy_rules

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
1285: where logical_page_id=p_logical_page_id;
1286: -- commit;
1287: end;
1288:

Line 1346: delete from jtf_dpf_lgcl_phy_rules where

1342: language = userenv('LANG');
1343: end if;
1344:
1345: if fnd_api.g_miss_num <> upd.p_default_physical_id then
1346: delete from jtf_dpf_lgcl_phy_rules where
1347: default_page_flag = 'T' and
1348: logical_page_id = p_logical_page_id;
1349:
1350: insert into jtf_dpf_lgcl_phy_rules (

Line 1350: insert into jtf_dpf_lgcl_phy_rules (

1346: delete from jtf_dpf_lgcl_phy_rules where
1347: default_page_flag = 'T' and
1348: logical_page_id = p_logical_page_id;
1349:
1350: insert into jtf_dpf_lgcl_phy_rules (
1351: logical_physical_id,
1352: logical_page_id,
1353: default_page_flag,
1354: physical_page_id,

Line 1362: jtf_dpf_lgcl_phy_rules_s.nextval,

1358: LAST_UPDATE_DATE,
1359: LAST_UPDATED_BY,
1360: LAST_UPDATE_LOGIN)
1361: values (
1362: jtf_dpf_lgcl_phy_rules_s.nextval,
1363: p_logical_page_id,
1364: 'T',
1365: upd.p_default_physical_id,
1366: 1,

Line 1487: insert into jtf_dpf_lgcl_phy_rules (

1483: -- SYSDATE,
1484: -- FND_GLOBAL.USER_ID,
1485: -- FND_GLOBAL.CONC_LOGIN_ID);
1486:
1487: insert into jtf_dpf_lgcl_phy_rules (
1488: logical_physical_id,
1489: logical_page_id,
1490: default_page_flag,
1491: physical_page_id,

Line 1499: jtf_dpf_lgcl_phy_rules_s.nextval,

1495: LAST_UPDATE_DATE,
1496: LAST_UPDATED_BY,
1497: LAST_UPDATE_LOGIN)
1498: values (
1499: jtf_dpf_lgcl_phy_rules_s.nextval,
1500: t_new_logical_page_id,
1501: 'T',
1502: p_default_physical_id,
1503: 1,

Line 1514: -- updates table JTF_DPF_LGCL_PHY_RULES, so that the default_next_flag='F'

1510: -- commit;
1511: return 1;
1512: end;
1513:
1514: -- updates table JTF_DPF_LGCL_PHY_RULES, so that the default_next_flag='F'
1515: -- rows which it contains for this logical_page_id are the rules and
1516: -- results specified by p_new_ones. It first throws out any old
1517: -- rows in the table.
1518: --

Line 1525: delete from jtf_dpf_lgcl_phy_rules where

1521: procedure logical_set_non_default_phys(p_logical_page_id number,
1522: p_new_ones new_phys_non_def_tbl) is
1523: idx binary_integer;
1524: begin
1525: delete from jtf_dpf_lgcl_phy_rules where
1526: logical_page_id = p_logical_page_id and
1527: default_page_flag='F';
1528:
1529: if p_new_ones is not null and p_new_ones.count <> 0 then

Line 1532: insert into jtf_dpf_lgcl_phy_rules (

1528:
1529: if p_new_ones is not null and p_new_ones.count <> 0 then
1530: idx := p_new_ones.first;
1531: while true loop
1532: insert into jtf_dpf_lgcl_phy_rules (
1533: logical_physical_id,
1534: logical_page_id,
1535: default_page_flag,
1536: rule_eval_sequence,

Line 1546: jtf_dpf_lgcl_phy_rules_s.nextval,

1542: LAST_UPDATE_DATE,
1543: LAST_UPDATED_BY,
1544: LAST_UPDATE_LOGIN)
1545: values(
1546: jtf_dpf_lgcl_phy_rules_s.nextval,
1547: p_logical_page_id,
1548: 'F',
1549: idx,
1550: p_new_ones(idx).physical_page_id,