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.WF_LOOKUP_TYPES_PUB dependencies on WF_LOOKUPS

Line 34: p_wf_lookups_tbl OUT NOCOPY wf_lookup_types_pub.wf_lookups_tbl_type) IS

30: PROCEDURE fetch_lookup_types
31: (p_item_type IN VARCHAR2,
32: p_lookup_type IN VARCHAR2,
33: p_wf_lookup_types_tbl OUT NOCOPY wf_lookup_types_pub.wf_lookup_types_tbl_type,
34: p_wf_lookups_tbl OUT NOCOPY wf_lookup_types_pub.wf_lookups_tbl_type) IS
35:
36: CURSOR fetch_lookup_types (c_item_type IN VARCHAR2) IS
37: SELECT row_id,
38: lookup_type,

Line 85: FROM wf_lookups wl, wf_lookup_types wlt

81: wl.protect_level,
82: wl.custom_level,
83: wl.meaning,
84: wl.description
85: FROM wf_lookups wl, wf_lookup_types wlt
86: WHERE wlt.item_type = c_item_type
87: AND wlt.lookup_type = wl.lookup_type
88: ORDER BY wlt.display_name, wl.meaning;
89:

Line 116: FROM wf_lookups wl, wf_lookup_types wlt

112: wl.protect_level,
113: wl.custom_level,
114: wl.meaning,
115: wl.description
116: FROM wf_lookups wl, wf_lookup_types wlt
117: WHERE wlt.item_type = c_item_type
118: AND wlt.lookup_type = c_lookup_type
119: AND wlt.lookup_type = wl.lookup_type
120: ORDER BY wlt.display_name, wl.meaning;

Line 160: ** filling in the p_wf_lookups_tbl

156: OPEN fetch_lookups_for_type (p_item_type, p_lookup_type);
157:
158: /*
159: ** Loop through all the lookup_code rows for the given lookup_type
160: ** filling in the p_wf_lookups_tbl
161: */
162: LOOP
163:
164: l_record_num := l_record_num + 1;

Line 166: FETCH fetch_lookups_for_type INTO p_wf_lookups_tbl(l_record_num);

162: LOOP
163:
164: l_record_num := l_record_num + 1;
165:
166: FETCH fetch_lookups_for_type INTO p_wf_lookups_tbl(l_record_num);
167:
168: EXIT WHEN fetch_lookups_for_type%NOTFOUND;
169:
170: END LOOP;

Line 180: ** filling in the p_wf_lookups_tbl

176: OPEN fetch_lookup_types (p_item_type);
177:
178: /*
179: ** Loop through all the lookup_code rows for the given lookup_type
180: ** filling in the p_wf_lookups_tbl
181: */
182: LOOP
183:
184: l_record_num := l_record_num + 1;

Line 200: ** filling in the p_wf_lookups_tbl

196: OPEN fetch_lookups (p_item_type);
197:
198: /*
199: ** Loop through all the lookup_code rows for the given lookup_type
200: ** filling in the p_wf_lookups_tbl
201: */
202: LOOP
203:
204: l_record_num := l_record_num + 1;

Line 206: FETCH fetch_lookups INTO p_wf_lookups_tbl(l_record_num);

202: LOOP
203:
204: l_record_num := l_record_num + 1;
205:
206: FETCH fetch_lookups INTO p_wf_lookups_tbl(l_record_num);
207:
208: EXIT WHEN fetch_lookups%NOTFOUND;
209:
210: END LOOP;

Line 296: FROM wf_lookups

292: ** Use a max() so you don't need a exception for no data found
293: */
294: SELECT MAX(meaning)
295: INTO l_code_display_name
296: FROM wf_lookups
297: WHERE lookup_type = p_type_internal_name
298: AND lookup_code = p_code_internal_name;
299:
300: /*

Line 346: p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,

342:
343: ============================================================================*/
344: PROCEDURE draw_lookup_type_list
345: (p_wf_lookup_types_tbl IN wf_lookup_types_pub.wf_lookup_types_tbl_type,
346: p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
347: p_effective_date IN DATE,
348: p_indent_level IN NUMBER) IS
349:
350: l_lookup_type_record_num NUMBER;

Line 354: l_wf_lookups_tbl wf_lookup_types_pub.wf_lookups_tbl_type;

350: l_lookup_type_record_num NUMBER;
351: l_lookup_record_num NUMBER := 1;
352: ii NUMBER := 0;
353: l_cur_lookup_record_num NUMBER := 1;
354: l_wf_lookups_tbl wf_lookup_types_pub.wf_lookups_tbl_type;
355:
356:
357: BEGIN
358:

Line 387: ** current lookup type. The p_wf_lookups_vl_tbl is ordered by display

383: p_indent_level+1);
384:
385: /*
386: ** Here we look for all the lookup types that are related to the
387: ** current lookup type. The p_wf_lookups_vl_tbl is ordered by display
388: ** name and then by lookup type display name. As long as we stay
389: ** in sync we should be able to correctly create the temp attribute list
390: ** for the current lookup type. We could create a cursor here for the child
391: ** attributes but that would break the rule of separating the UI layer

Line 394: l_wf_lookups_tbl.delete;

390: ** for the current lookup type. We could create a cursor here for the child
391: ** attributes but that would break the rule of separating the UI layer
392: ** and the data layer
393: */
394: l_wf_lookups_tbl.delete;
395: l_cur_lookup_record_num := 1;
396:
397: /*
398: ** Make sure there is at least on record in the lookup

Line 403: l_lookup_record_num <= p_wf_lookups_tbl.count AND

399: ** list. If there is not then the l_lookup_record_num index of 1
400: ** will cause a 6502-PL*SQL numeric or value error exception.
401: */
402: WHILE (
403: l_lookup_record_num <= p_wf_lookups_tbl.count AND
404: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name =
405: p_wf_lookups_tbl(l_lookup_record_num).lookup_type_display_name
406: ) LOOP
407:

Line 405: p_wf_lookups_tbl(l_lookup_record_num).lookup_type_display_name

401: */
402: WHILE (
403: l_lookup_record_num <= p_wf_lookups_tbl.count AND
404: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name =
405: p_wf_lookups_tbl(l_lookup_record_num).lookup_type_display_name
406: ) LOOP
407:
408: /*
409: ** We have found an attribute for the current lookup type. Copy the

Line 414: l_wf_lookups_tbl(l_cur_lookup_record_num) :=

410: ** contents of that list to a temp attr list and then pass the
411: ** temp list to the lookupsibute display function to display
412: ** the results.
413: */
414: l_wf_lookups_tbl(l_cur_lookup_record_num) :=
415: p_wf_lookups_tbl(l_lookup_record_num);
416:
417: l_lookup_record_num := l_lookup_record_num + 1;
418: l_cur_lookup_record_num := l_cur_lookup_record_num + 1;

Line 415: p_wf_lookups_tbl(l_lookup_record_num);

411: ** temp list to the lookupsibute display function to display
412: ** the results.
413: */
414: l_wf_lookups_tbl(l_cur_lookup_record_num) :=
415: p_wf_lookups_tbl(l_lookup_record_num);
416:
417: l_lookup_record_num := l_lookup_record_num + 1;
418: l_cur_lookup_record_num := l_cur_lookup_record_num + 1;
419:

Line 436: l_wf_lookups_tbl,

432: ** we found above. Add two to the current indent level so it
433: ** is pushed in past the start of the lookup type list.
434: */
435: wf_lookup_types_pub.draw_lookup_list (
436: l_wf_lookups_tbl,
437: p_effective_date,
438: p_indent_level + 2);
439:
440: END IF;

Line 462: (p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,

458: output.
459:
460: ============================================================================*/
461: PROCEDURE draw_lookup_list
462: (p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
463: p_effective_date IN DATE,
464: p_indent_level IN NUMBER) IS
465:
466: l_record_num NUMBER;

Line 481: FOR l_record_num IN 1..p_wf_lookups_tbl.count LOOP

477:
478: /*
479: ** Print out all lookup display names in the pl*sql table
480: */
481: FOR l_record_num IN 1..p_wf_lookups_tbl.count LOOP
482:
483: /*
484: ** The creation of the anchor from the summary frame to the detail
485: ** frame was very complex so I've extracted the function into its

Line 489: p_wf_lookups_tbl(l_record_num).item_type,

485: ** frame was very complex so I've extracted the function into its
486: ** own routine.
487: */
488: wf_item_definition_util_pub.create_hotlink_to_details (
489: p_wf_lookups_tbl(l_record_num).item_type,
490: p_effective_date,
491: 'LOOKUP',
492: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
493: p_wf_lookups_tbl(l_record_num).lookup_code,

Line 492: p_wf_lookups_tbl(l_record_num).lookup_type||':'||

488: wf_item_definition_util_pub.create_hotlink_to_details (
489: p_wf_lookups_tbl(l_record_num).item_type,
490: p_effective_date,
491: 'LOOKUP',
492: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
493: p_wf_lookups_tbl(l_record_num).lookup_code,
494: p_wf_lookups_tbl(l_record_num).meaning,
495: NULL,
496: p_indent_level+1);

Line 493: p_wf_lookups_tbl(l_record_num).lookup_code,

489: p_wf_lookups_tbl(l_record_num).item_type,
490: p_effective_date,
491: 'LOOKUP',
492: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
493: p_wf_lookups_tbl(l_record_num).lookup_code,
494: p_wf_lookups_tbl(l_record_num).meaning,
495: NULL,
496: p_indent_level+1);
497:

Line 494: p_wf_lookups_tbl(l_record_num).meaning,

490: p_effective_date,
491: 'LOOKUP',
492: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
493: p_wf_lookups_tbl(l_record_num).lookup_code,
494: p_wf_lookups_tbl(l_record_num).meaning,
495: NULL,
496: p_indent_level+1);
497:
498: END LOOP;

Line 519: p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,

515: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
516: ============================================================================*/
517: PROCEDURE draw_lookup_type_details
518: (p_wf_lookup_types_tbl IN wf_lookup_types_pub.wf_lookup_types_tbl_type,
519: p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
520: p_indent_level IN NUMBER) IS
521:
522: l_lookup_type_record_num NUMBER;
523: ii NUMBER := 0;

Line 526: l_wf_lookups_tbl wf_lookup_types_pub.wf_lookups_tbl_type;

522: l_lookup_type_record_num NUMBER;
523: ii NUMBER := 0;
524: l_lookup_record_num NUMBER := 1;
525: l_cur_lookup_record_num NUMBER := 1;
526: l_wf_lookups_tbl wf_lookup_types_pub.wf_lookups_tbl_type;
527:
528: BEGIN
529:
530: /*

Line 590: ** lookup type. The p_wf_lookups_tbl is ordered by display

586: htp.tableClose;
587:
588: /*
589: ** Here we look for all the lookups that are related to the current
590: ** lookup type. The p_wf_lookups_tbl is ordered by display
591: ** name and then by lookup meaning. As long as we stay
592: ** in sync we should be able to correctly create the temp lookup list
593: ** for the current lookup type. We could create a cursor here for
594: ** the child lookups but that would break the rule of separating

Line 597: l_wf_lookups_tbl.delete;

593: ** for the current lookup type. We could create a cursor here for
594: ** the child lookups but that would break the rule of separating
595: ** the UI layer and the data layer
596: */
597: l_wf_lookups_tbl.delete;
598: l_cur_lookup_record_num := 1;
599:
600: /*
601: ** Make sure there is at least on record in the lookups

Line 606: l_lookup_record_num <= p_wf_lookups_tbl.count AND

602: ** list. If there is not then the l_lookup_record_num index of 1
603: ** will cause a 6502-PL*SQL numeric or value error exception.
604: */
605: WHILE (
606: l_lookup_record_num <= p_wf_lookups_tbl.count AND
607: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name =
608: p_wf_lookups_tbl(l_lookup_record_num).lookup_type_display_name
609: ) LOOP
610:

Line 608: p_wf_lookups_tbl(l_lookup_record_num).lookup_type_display_name

604: */
605: WHILE (
606: l_lookup_record_num <= p_wf_lookups_tbl.count AND
607: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name =
608: p_wf_lookups_tbl(l_lookup_record_num).lookup_type_display_name
609: ) LOOP
610:
611: /*
612: ** We have found a lookup for the lookup type. Copy the

Line 617: l_wf_lookups_tbl(l_cur_lookup_record_num) :=

613: ** contents of that list to a temp lookup list and then pass the
614: ** temp list to the lookup display function to display
615: ** the results.
616: */
617: l_wf_lookups_tbl(l_cur_lookup_record_num) :=
618: p_wf_lookups_tbl(l_lookup_record_num);
619:
620: l_lookup_record_num := l_lookup_record_num + 1;
621: l_cur_lookup_record_num := l_cur_lookup_record_num + 1;

Line 618: p_wf_lookups_tbl(l_lookup_record_num);

614: ** temp list to the lookup display function to display
615: ** the results.
616: */
617: l_wf_lookups_tbl(l_cur_lookup_record_num) :=
618: p_wf_lookups_tbl(l_lookup_record_num);
619:
620: l_lookup_record_num := l_lookup_record_num + 1;
621: l_cur_lookup_record_num := l_cur_lookup_record_num + 1;
622:

Line 644: l_wf_lookups_tbl,

640: ** List all the lookup details for this lookup typethat
641: ** we found above.
642: */
643: wf_lookup_types_pub.draw_lookup_details (
644: l_wf_lookups_tbl,
645: 1);
646:
647: /*
648: ** If you still have more lookup types to process then put in a

Line 701: (p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,

697: MODIFICATION LOG:
698: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
699: ============================================================================*/
700: PROCEDURE draw_lookup_details
701: (p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
702: p_indent_level IN NUMBER) IS
703:
704: l_record_num NUMBER;
705: ii NUMBER := 0;

Line 719: FOR l_record_num IN 1..p_wf_lookups_tbl.count LOOP

715:
716: /*
717: ** Print out all meesage attribute display names in the pl*sql table
718: */
719: FOR l_record_num IN 1..p_wf_lookups_tbl.count LOOP
720:
721: /*
722: ** Open a new table for each lookup so you can control the spacing
723: ** between each attribute

Line 735: p_wf_lookups_tbl(l_record_num).lookup_type||':'||

731: ** name for the object.
732: */
733: wf_item_definition_util_pub.create_details_hotlink_target (
734: 'LOOKUP',
735: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
736: p_wf_lookups_tbl(l_record_num).lookup_code,
737: p_wf_lookups_tbl(l_record_num).meaning,
738: wf_core.translate('WFITD_LOOKUP_CODE_NAME'),
739: 0);

Line 736: p_wf_lookups_tbl(l_record_num).lookup_code,

732: */
733: wf_item_definition_util_pub.create_details_hotlink_target (
734: 'LOOKUP',
735: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
736: p_wf_lookups_tbl(l_record_num).lookup_code,
737: p_wf_lookups_tbl(l_record_num).meaning,
738: wf_core.translate('WFITD_LOOKUP_CODE_NAME'),
739: 0);
740:

Line 737: p_wf_lookups_tbl(l_record_num).meaning,

733: wf_item_definition_util_pub.create_details_hotlink_target (
734: 'LOOKUP',
735: p_wf_lookups_tbl(l_record_num).lookup_type||':'||
736: p_wf_lookups_tbl(l_record_num).lookup_code,
737: p_wf_lookups_tbl(l_record_num).meaning,
738: wf_core.translate('WFITD_LOOKUP_CODE_NAME'),
739: 0);
740:
741: /*

Line 746: p_wf_lookups_tbl(l_record_num).lookup_code);

742: ** Create the internal name row in the table.
743: */
744: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
745: wf_core.translate('WFITD_INTERNAL_NAME'),
746: p_wf_lookups_tbl(l_record_num).lookup_code);
747:
748: /*
749: ** Create the lookup type display name row in the table.
750: */

Line 753: p_wf_lookups_tbl(l_record_num).lookup_type_display_name);

749: ** Create the lookup type display name row in the table.
750: */
751: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
752: wf_core.translate('WFITD_LOOKUP_TYPE_NAME'),
753: p_wf_lookups_tbl(l_record_num).lookup_type_display_name);
754:
755: /*
756: ** Create the description row in the table
757: */

Line 760: p_wf_lookups_tbl(l_record_num).description);

756: ** Create the description row in the table
757: */
758: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
759: wf_core.translate('DESCRIPTION'),
760: p_wf_lookups_tbl(l_record_num).description);
761:
762: /*
763: ** Table is created so close it out
764: */

Line 771: IF (l_record_num <> p_wf_lookups_tbl.count) THEN

767: /*
768: ** Draw a line between each lookup definition
769: ** if this is not the last item in the list
770: */
771: IF (l_record_num <> p_wf_lookups_tbl.count) THEN
772:
773: htp.p ('

');
774:
775: END IF;