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 FND_APPLICATION

Line 6: t_head_log_asn fnd_application.application_short_name%type;

2: /* $Header: jtfdpfb.pls 120.1 2005/07/02 00:40:14 appldev ship $ */
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;

Line 8: t_rtn_log_asn fnd_application.application_short_name%type;

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:
12: cursor c1 (pp_asn varchar2) is

Line 26: (select application_id from fnd_application fa2

22: lf.enabled_clone_flag,
23: lf.last_updated_by -- was: base_flow_flag
24: from jtf_dpf_logical_flows_b lf
25: where lf.application_id =
26: (select application_id from fnd_application fa2
27: where fa2.application_short_name = pp_asn);
28: begin
29: for c1_rec in c1(asn) loop
30: select logical_flow_description into t_log_descr

Line 37: from fnd_application fa where fa.application_id =

33: and lftl.language = p_lang;
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

Line 48: from fnd_application fa where fa.application_id =

44: where lp2.logical_page_id = c1_rec.logical_flow_head_id;
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

Line 92: (select application_id from fnd_application fa2

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

Line 94: t_asn fnd_application.application_short_name%type;

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

Line 103: from fnd_application fa

99: begin
100: for c1_rec in c1(asn) loop
101: select application_short_name
102: into t_asn
103: from fnd_application fa
104: where fa.application_id =
105: (select pp.application_id
106: from jtf_dpf_physical_pages_b pp
107: where pp.physical_page_id =

Line 157: (select fa.application_id from fnd_application fa

153: pp.physical_page_name
154: -- pp.physical_page_description
155: from jtf_dpf_physical_pages_b pp
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

Line 180: q2_c2 fnd_application.application_short_name%type;

176: procedure get_physical_non_default_tbl(asn varchar2,
177: retval out NOCOPY physical_non_default_tbl) is
178: ddindx binary_integer := 1;
179: q2_c1 jtf_dpf_physical_pages_b.physical_page_name%type;
180: q2_c2 fnd_application.application_short_name%type;
181: q3_c1 jtf_dpf_rules_b.rule_name%type;
182: q3_c2 fnd_application.application_short_name%type;
183: cursor c1(pp_asn varchar2) is
184: select unique

Line 182: q3_c2 fnd_application.application_short_name%type;

178: ddindx binary_integer := 1;
179: q2_c1 jtf_dpf_physical_pages_b.physical_page_name%type;
180: q2_c2 fnd_application.application_short_name%type;
181: q3_c1 jtf_dpf_rules_b.rule_name%type;
182: q3_c2 fnd_application.application_short_name%type;
183: cursor c1(pp_asn varchar2) is
184: select unique
185: lp.logical_page_name,
186: lpr.rule_eval_sequence,

Line 193: (select application_id from fnd_application fa where

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
194: fa.application_short_name = pp_asn) and
195: lpr.default_page_flag = 'F'
196: order by lp.logical_page_name, lpr.rule_eval_sequence;
197: q2_c2_temp fnd_application.application_id%type;

Line 197: q2_c2_temp fnd_application.application_id%type;

193: (select application_id from fnd_application fa where
194: fa.application_short_name = pp_asn) and
195: lpr.default_page_flag = 'F'
196: order by lp.logical_page_name, lpr.rule_eval_sequence;
197: q2_c2_temp fnd_application.application_id%type;
198: q3_c2_temp fnd_application.application_id%type;
199: begin
200: for c1_rec in c1(asn) loop
201: select pp.physical_page_name,

Line 198: q3_c2_temp fnd_application.application_id%type;

194: fa.application_short_name = pp_asn) and
195: lpr.default_page_flag = 'F'
196: order by lp.logical_page_name, lpr.rule_eval_sequence;
197: q2_c2_temp fnd_application.application_id%type;
198: q3_c2_temp fnd_application.application_id%type;
199: begin
200: for c1_rec in c1(asn) loop
201: select pp.physical_page_name,
202: pp.application_id

Line 203: -- (select application_short_name from fnd_application fa2

199: begin
200: for c1_rec in c1(asn) loop
201: select pp.physical_page_name,
202: pp.application_id
203: -- (select application_short_name from fnd_application fa2
204: -- where fa2.application_id = pp.application_id)
205: into q2_c1, q2_c2_temp
206: from jtf_dpf_physical_pages_b pp
207: where pp.physical_page_id = c1_rec.physical_page_id;

Line 211: from fnd_application fa2 where fa2.application_id = q2_c2_temp;

207: where pp.physical_page_id = c1_rec.physical_page_id;
208:
209: select application_short_name
210: into q2_c2
211: from fnd_application fa2 where fa2.application_id = q2_c2_temp;
212:
213: select
214: r.rule_name,
215: r.application_id

Line 216: -- (select application_short_name from fnd_application fa

212:
213: select
214: r.rule_name,
215: r.application_id
216: -- (select application_short_name from fnd_application fa
217: -- where fa.application_id = r.application_id)
218: into q3_c1, q3_c2_temp
219: from jtf_dpf_rules_b r
220: where r.rule_id = c1_rec.rule_id;

Line 222: select application_short_name into q3_c2 from fnd_application

218: into q3_c1, q3_c2_temp
219: from jtf_dpf_rules_b r
220: where r.rule_id = c1_rec.rule_id;
221:
222: select application_short_name into q3_c2 from fnd_application
223: where fnd_application.application_id = q3_c2_temp;
224:
225: -- write contents of the record in retval(ddindx)
226: retval(ddindx).logical_name := c1_rec.logical_page_name;

Line 223: where fnd_application.application_id = q3_c2_temp;

219: from jtf_dpf_rules_b r
220: where r.rule_id = c1_rec.rule_id;
221:
222: select application_short_name into q3_c2 from fnd_application
223: where fnd_application.application_id = q3_c2_temp;
224:
225: -- write contents of the record in retval(ddindx)
226: retval(ddindx).logical_name := c1_rec.logical_page_name;
227: retval(ddindx).rule_eval_sequence := c1_rec.rule_eval_sequence;

Line 251: (select application_id from fnd_application fa

247: from jtf_dpf_rules_b r, jtf_dpf_rule_params rp
248: where
249: r.rule_id = rp.rule_id and
250: r.application_id =
251: (select application_id from fnd_application fa
252: where fa.application_short_name = pp_asn)
253: order by rp.rule_param_sequence;
254: ddindx binary_integer := 1;
255: t_rules_descr jtf_dpf_rules_tl.rule_description%type;

Line 281: (select application_id from fnd_application fa

277: cursor q1 (pp_asn varchar2) is
278: select logical_flow_name, logical_flow_id
279: from jtf_dpf_logical_flows_b lf
280: where lf.application_id =
281: (select application_id from fnd_application fa
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

Line 290: q3_c1 fnd_application.application_short_name%type;

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

Line 292: q4_c1 fnd_application.application_short_name%type;

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;
296: begin

Line 294: q3_c1_temp fnd_application.application_id%type;

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
298: for q2_rec in q2(q1_rec.logical_flow_id) loop

Line 295: q4_c1_temp fnd_application.application_id%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
298: for q2_rec in q2(q1_rec.logical_flow_id) loop
299: select

Line 301: -- (select application_short_name from fnd_application fa

297: for q1_rec in q1(asn) loop
298: for q2_rec in q2(q1_rec.logical_flow_id) loop
299: select
300: lp.application_id,
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

Line 309: from fnd_application where application_id = q3_c1_temp;

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;
310:
311: select
312: lp.application_id,
313: -- (select application_short_name from fnd_application fa

Line 313: -- (select application_short_name from fnd_application fa

309: from fnd_application where application_id = q3_c1_temp;
310:
311: select
312: lp.application_id,
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

Line 321: from fnd_application where application_id = q4_c1_temp;

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;
322:
323: -- write the data into a new record
324: retval(ddindx).dpf_name := q1_rec.logical_flow_name;
325: retval(ddindx).dpf_id := q1_rec.logical_flow_id;

Line 342: (select application_id from fnd_application fa

338: cursor q1 (pp_asn varchar2) is
339: select logical_flow_name, logical_flow_id
340: from jtf_dpf_logical_flows_b lf
341: where lf.application_id =
342: (select application_id from fnd_application fa
343: where fa.application_short_name = pp_asn);
344:
345: cursor q2 (pp_q1_c2 number) is
346: select

Line 356: q3_c1 fnd_application.application_short_name%type;

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

Line 358: q4_c1 fnd_application.application_short_name%type;

354: order by lnr.rule_eval_seq;
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;

Line 360: q5_c1 fnd_application.application_short_name%type;

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;
364: q5_c1_temp fnd_application.application_id%type;

Line 362: q3_c1_temp fnd_application.application_id%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
366: for q1_rec in q1(asn) loop

Line 363: q4_c1_temp fnd_application.application_id%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
366: for q1_rec in q1(asn) loop
367: for q2_rec in q2(q1_rec.logical_flow_id) loop

Line 364: q5_c1_temp fnd_application.application_id%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
366: for q1_rec in q1(asn) loop
367: for q2_rec in q2(q1_rec.logical_flow_id) loop
368: select

Line 370: -- (select application_short_name from fnd_application fa

366: for q1_rec in q1(asn) loop
367: for q2_rec in q2(q1_rec.logical_flow_id) loop
368: select
369: r.application_id,
370: -- (select application_short_name from fnd_application fa
371: -- where fa.application_id = r.application_id),
372: r.rule_name
373: into q3_c1_temp, q3_c2
374: from jtf_dpf_rules_b r

Line 379: from fnd_application

375: where r.rule_id = q2_rec.rule_id;
376:
377: select application_short_name
378: into q3_c1
379: from fnd_application
380: where application_id = q3_c1_temp;
381:
382: select
383: lp.application_id,

Line 384: -- (select application_short_name from fnd_application fa

380: where application_id = q3_c1_temp;
381:
382: select
383: lp.application_id,
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

Line 393: from fnd_application

389: where lp.logical_page_id = q2_rec.logical_page_id;
390:
391: select application_short_name
392: into q4_c1
393: from fnd_application
394: where application_id = q4_c1_temp;
395:
396: select
397: lp.application_id,

Line 398: -- (select application_short_name from fnd_application fa

394: where application_id = q4_c1_temp;
395:
396: select
397: lp.application_id,
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

Line 407: from fnd_application

403: where lp.logical_page_id = q2_rec.logical_next_page_id;
404:
405: select application_short_name
406: into q5_c1
407: from fnd_application
408: where application_id = q5_c1_temp;
409:
410: -- insert a new record into the table
411: retval(ddindx).dpf_name := q1_rec.logical_flow_name;

Line 432: (select fa.application_id from fnd_application fa

428: cursor c1 (pp_asn varchar2) is
429: select pp.physical_page_id
430: from jtf_dpf_physical_pages_b pp
431: where pp.application_id =
432: (select fa.application_id from fnd_application fa
433: where fa.application_short_name = pp_asn);
434: ddindx binary_integer := 1;
435: begin
436: for c1_rec in c1(asn) loop

Line 518: from fnd_application where application_short_name = upd.p_new_asn;

514: return 3;
515: end if;
516:
517: select application_id into t_appid
518: from fnd_application where application_short_name = upd.p_new_asn;
519:
520: -- is the proposed new name already taken? count the number
521: -- of rows which already have this name and appid, but which have a
522: -- different logical_flow_id

Line 565: from fnd_application

561: begin
562: if p_name is null or 0 = length(p_name) then return 3; end if;
563:
564: select application_id into t_appid
565: from fnd_application
566: where application_short_name = p_asn;
567:
568: select count(*) into existential from jtf_dpf_rules_b
569: where rule_name = p_name and

Line 699: from fnd_application where application_short_name = upd.p_new_asn;

695: begin
696: if upd.p_name is null or 0 = length(upd.p_name) then return 3; end if;
697:
698: select application_id into t_appid
699: from fnd_application where application_short_name = upd.p_new_asn;
700:
701: -- why was this ever here!? wird; I don't remember ever thinking
702: -- that this was the right rule for physicals...
703: -- -- if there already exists a physical with this name and asn,

Line 787: from fnd_application where application_short_name = p_asn;

783: begin
784: if p_name is null or 0 = length(p_name) then return 3; end if;
785:
786: select application_id into t_appid
787: from fnd_application where application_short_name = p_asn;
788:
789: -- why was this here!? we do allow more than one physical
790: -- with the same name!
791: -- -- if there already exists a physical with this name and asn,

Line 919: from fnd_application where application_short_name = upd.p_new_asn;

915: if existential = 0 then return 4; end if;
916: end if;
917:
918: select application_id into t_appid
919: from fnd_application where application_short_name = upd.p_new_asn;
920:
921: -- is the proposed new name different from the current name, and yet
922: -- already taken? count the number of rows which already have this
923: -- name, but which have a different logical_flow_id

Line 1015: from fnd_application where application_short_name = p_new_asn;

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
1015: from fnd_application where application_short_name = p_new_asn;
1016:
1017: select count(*) into existential
1018: from jtf_dpf_logical_flows_b
1019: where application_id = t_appid and

Line 1308: from fnd_application where application_short_name = upd.p_new_asn;

1304: if existential = 0 then return 4; end if;
1305: end if;
1306:
1307: select application_id into t_appid
1308: from fnd_application where application_short_name = upd.p_new_asn;
1309:
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

Line 1402: from fnd_application where application_short_name = p_new_asn;

1398:
1399: if existential = 0 then return 4; end if;
1400:
1401: select application_id into t_appid
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