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_NEXT_RULES

Line 286: from jtf_dpf_lgcl_next_rules lnr

282: where fa.application_short_name = pp_asn);
283:
284: cursor q2 (pp_q1_c2 number) is
285: select logical_page_id, logical_next_page_id
286: from jtf_dpf_lgcl_next_rules lnr
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;

Line 351: from jtf_dpf_lgcl_next_rules lnr

347: logical_page_id,
348: logical_next_page_id,
349: rule_eval_seq,
350: rule_id
351: from jtf_dpf_lgcl_next_rules lnr
352: where lnr.logical_flow_id = pp_q1_c2 and
353: lnr.default_next_flag='F'
354: order by lnr.rule_eval_seq;
355: ddindx binary_integer := 1;

Line 868: -- - jtf_dpf_lgcl_next_rules

864: -- dpf editing procedures
865: -- delete_flow. Removes all rows with logical_page_flow from tables:
866: -- - jtf_dpf_lgcl_flow_params
867: -- - jtf_dpf_logical_flows
868: -- - jtf_dpf_lgcl_next_rules
869: procedure flow_delete(p_logical_flow_id number) is
870: begin
871: delete from jtf_dpf_lgcl_flow_params
872: where logical_flow_id = p_logical_flow_id;

Line 877: delete from jtf_dpf_lgcl_next_rules

873: delete from jtf_dpf_logical_flows_b
874: where logical_flow_id = p_logical_flow_id;
875: delete from jtf_dpf_logical_flows_tl
876: where logical_flow_id = p_logical_flow_id;
877: delete from jtf_dpf_lgcl_next_rules
878: where logical_flow_id = p_logical_flow_id;
879: -- commit;
880: end;
881:

Line 1193: -- insert N new rows into table jtf_dpf_lgcl_next_rules with

1189: FND_GLOBAL.CONC_LOGIN_ID
1190: from jtf_dpf_logical_flows_tl o
1191: where o.logical_flow_id = p_flow_id;
1192:
1193: -- insert N new rows into table jtf_dpf_lgcl_next_rules with
1194: -- flow_id = new_flow_id, one for each row that's currently present for
1195: -- p_flow_id
1196:
1197: insert into jtf_dpf_lgcl_next_rules(

Line 1197: insert into jtf_dpf_lgcl_next_rules(

1193: -- insert N new rows into table jtf_dpf_lgcl_next_rules with
1194: -- flow_id = new_flow_id, one for each row that's currently present for
1195: -- p_flow_id
1196:
1197: insert into jtf_dpf_lgcl_next_rules(
1198: LOGICAL_NEXT_RULE_ID ,
1199: LOGICAL_PAGE_ID ,
1200: LOGICAL_NEXT_PAGE_ID ,
1201: DEFAULT_NEXT_FLAG ,

Line 1225: from jtf_dpf_lgcl_next_rules o

1221: SYSDATE,
1222: SYSDATE,
1223: FND_GLOBAL.USER_ID,
1224: FND_GLOBAL.CONC_LOGIN_ID
1225: from jtf_dpf_lgcl_next_rules o
1226: where o.logical_flow_id = p_flow_id;
1227:
1228: return 1;
1229: end;

Line 1272: -- - jtf_dpf_lgcl_next_rules

1268:
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

Line 1282: delete from jtf_dpf_lgcl_next_rules

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

Line 1569: -- row in JTF_DPF_LGCL_NEXT_RULES or insert a new one

1565:
1566: -- set next_logicals
1567: -- sets the default next logical of (flow_id, log_page_id) to
1568: -- next_log_page_id. This might either update an existing
1569: -- row in JTF_DPF_LGCL_NEXT_RULES or insert a new one
1570: -- if the new 'next' is null, it means there is no more next_logical
1571: -- for the given one.
1572: function next_logical_set_default(
1573: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,

Line 1573: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,

1569: -- row in JTF_DPF_LGCL_NEXT_RULES or insert a new one
1570: -- if the new 'next' is null, it means there is no more next_logical
1571: -- for the given one.
1572: function next_logical_set_default(
1573: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,
1574: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,
1575: p_next_log_page_id jtf_dpf_lgcl_next_rules.logical_next_page_id%type)
1576: return number is
1577: existential number;

Line 1574: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,

1570: -- if the new 'next' is null, it means there is no more next_logical
1571: -- for the given one.
1572: function next_logical_set_default(
1573: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,
1574: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,
1575: p_next_log_page_id jtf_dpf_lgcl_next_rules.logical_next_page_id%type)
1576: return number is
1577: existential number;
1578: begin

Line 1575: p_next_log_page_id jtf_dpf_lgcl_next_rules.logical_next_page_id%type)

1571: -- for the given one.
1572: function next_logical_set_default(
1573: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,
1574: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,
1575: p_next_log_page_id jtf_dpf_lgcl_next_rules.logical_next_page_id%type)
1576: return number is
1577: existential number;
1578: begin
1579:

Line 1598: delete from jtf_dpf_lgcl_next_rules

1594: end if;
1595:
1596: -- not the error case! just do the update, then...
1597: if p_next_log_page_id is null then
1598: delete from jtf_dpf_lgcl_next_rules
1599: where logical_page_id = p_log_page_id and
1600: logical_flow_id = p_flow_id;
1601: else
1602: delete from jtf_dpf_lgcl_next_rules

Line 1602: delete from jtf_dpf_lgcl_next_rules

1598: delete from jtf_dpf_lgcl_next_rules
1599: where logical_page_id = p_log_page_id and
1600: logical_flow_id = p_flow_id;
1601: else
1602: delete from jtf_dpf_lgcl_next_rules
1603: where default_next_flag = 'T' and
1604: logical_page_id = p_log_page_id and
1605: logical_flow_id = p_flow_id;
1606: insert into jtf_dpf_lgcl_next_rules (

Line 1606: insert into jtf_dpf_lgcl_next_rules (

1602: delete from jtf_dpf_lgcl_next_rules
1603: where default_next_flag = 'T' and
1604: logical_page_id = p_log_page_id and
1605: logical_flow_id = p_flow_id;
1606: insert into jtf_dpf_lgcl_next_rules (
1607: logical_next_rule_id,
1608: logical_page_id,
1609: logical_next_page_id,
1610: default_next_flag,

Line 1639: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,

1635:
1636: -- sets up the non-default next logical rules for (flow_id, log_page_id).
1637: -- if there were already non-default rules for it, it removes them first
1638: procedure next_logical_set_non_default(
1639: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,
1640: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,
1641: p_new_ones new_next_log_non_def_tbl) is
1642: idx binary_integer;
1643: begin

Line 1640: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,

1636: -- sets up the non-default next logical rules for (flow_id, log_page_id).
1637: -- if there were already non-default rules for it, it removes them first
1638: procedure next_logical_set_non_default(
1639: p_flow_id jtf_dpf_lgcl_next_rules.logical_flow_id%type,
1640: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,
1641: p_new_ones new_next_log_non_def_tbl) is
1642: idx binary_integer;
1643: begin
1644: delete from jtf_dpf_lgcl_next_rules

Line 1644: delete from jtf_dpf_lgcl_next_rules

1640: p_log_page_id jtf_dpf_lgcl_next_rules.logical_page_id%type,
1641: p_new_ones new_next_log_non_def_tbl) is
1642: idx binary_integer;
1643: begin
1644: delete from jtf_dpf_lgcl_next_rules
1645: where default_next_flag = 'F' and
1646: logical_page_id = p_log_page_id and
1647: logical_flow_id = p_flow_id;
1648:

Line 1652: insert into jtf_dpf_lgcl_next_rules(

1648:
1649: if p_new_ones is not null and p_new_ones.count <> 0 then
1650: idx := p_new_ones.first;
1651: while true loop
1652: insert into jtf_dpf_lgcl_next_rules(
1653: logical_next_rule_id,
1654: logical_page_id,
1655: logical_next_page_id,
1656: default_next_flag,