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_LOOKUP_TYPES

Line 1: PACKAGE BODY wf_lookup_types_pub AS

1: PACKAGE BODY wf_lookup_types_pub AS
2: /* $Header: wfdefb.pls 120.1 2005/07/02 03:43:48 appldev ship $ */
3:
4: /*===========================================================================
5: PACKAGE NAME: wf_lookup_types_pub

Line 5: PACKAGE NAME: wf_lookup_types_pub

1: PACKAGE BODY wf_lookup_types_pub AS
2: /* $Header: wfdefb.pls 120.1 2005/07/02 03:43:48 appldev ship $ */
3:
4: /*===========================================================================
5: PACKAGE NAME: wf_lookup_types_pub
6:
7: DESCRIPTION:
8:
9: OWNER: GKELLNER

Line 21: into a p_wf_lookup_types_vl_tbl table based on the

17: /*===========================================================================
18: PROCEDURE NAME: fetch_lookup_type
19:
20: DESCRIPTION: Fetches all the lookup types for a given item type
21: into a p_wf_lookup_types_vl_tbl table based on the
22: item type internal eight character name. This function
23: can also retrieve a single lookup type definition if
24: the internal name along with the item type name is
25: provided. This is especially useful if you wish to

Line 33: p_wf_lookup_types_tbl OUT NOCOPY wf_lookup_types_pub.wf_lookup_types_tbl_type,

29: ============================================================================*/
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,

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 44: FROM wf_lookup_types

40: protect_level,
41: custom_level,
42: display_name,
43: description
44: FROM wf_lookup_types
45: WHERE item_type = c_item_type
46: ORDER BY display_name;
47:
48: /*===========================================================================

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 149: INTO p_wf_lookup_types_tbl(1)

145: protect_level,
146: custom_level,
147: display_name,
148: description
149: INTO p_wf_lookup_types_tbl(1)
150: FROM wf_lookup_types
151: WHERE item_type = p_item_type
152: AND lookup_type = p_lookup_type;
153:

Line 150: FROM wf_lookup_types

146: custom_level,
147: display_name,
148: description
149: INTO p_wf_lookup_types_tbl(1)
150: FROM wf_lookup_types
151: WHERE item_type = p_item_type
152: AND lookup_type = p_lookup_type;
153:
154: l_record_num := 0;

Line 186: FETCH fetch_lookup_types INTO p_wf_lookup_types_tbl(l_record_num);

182: LOOP
183:
184: l_record_num := l_record_num + 1;
185:
186: FETCH fetch_lookup_types INTO p_wf_lookup_types_tbl(l_record_num);
187:
188: EXIT WHEN fetch_lookup_types%NOTFOUND;
189:
190: END LOOP;

Line 218: Wf_Core.Context('wf_lookup_types_pub',

214: END IF;
215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: Wf_Core.Context('wf_lookup_types_pub',
219: 'fetch_lookup_types',
220: p_item_type,
221: p_lookup_type);
222:

Line 256: FROM wf_lookup_types

252: ** Use a max() so you don't need a exception for no data found
253: */
254: SELECT MAX(display_name)
255: INTO l_type_display_name
256: FROM wf_lookup_types
257: WHERE lookup_type = p_type_internal_name;
258:
259: /*
260: ** If no value is found then set the display name to the

Line 328: Wf_Core.Context('wf_lookup_types_pub',

324: p_code_display_name := l_code_display_name;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: Wf_Core.Context('wf_lookup_types_pub',
329: 'fetch_lookup_display',
330: p_type_internal_name,
331: p_code_internal_name);
332:

Line 345: (p_wf_lookup_types_tbl IN wf_lookup_types_pub.wf_lookup_types_tbl_type,

341: generate its html output.
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:

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 369: FOR l_lookup_type_record_num IN 1..p_wf_lookup_types_tbl.count LOOP

365:
366: /*
367: ** Print out all lookup type display names in the pl*sql table
368: */
369: FOR l_lookup_type_record_num IN 1..p_wf_lookup_types_tbl.count LOOP
370:
371: /*
372: ** The creation of the anchor from the summary frame to the detail
373: ** frame was very complex so I've extracted the function into its

Line 377: p_wf_lookup_types_tbl(l_lookup_type_record_num).item_type,

373: ** frame was very complex so I've extracted the function into its
374: ** own routine.
375: */
376: wf_item_definition_util_pub.create_hotlink_to_details (
377: p_wf_lookup_types_tbl(l_lookup_type_record_num).item_type,
378: p_effective_date,
379: 'LOOKUP_TYPE',
380: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,
381: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,

Line 380: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,

376: wf_item_definition_util_pub.create_hotlink_to_details (
377: p_wf_lookup_types_tbl(l_lookup_type_record_num).item_type,
378: p_effective_date,
379: 'LOOKUP_TYPE',
380: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,
381: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,
382: NULL,
383: p_indent_level+1);
384:

Line 381: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,

377: p_wf_lookup_types_tbl(l_lookup_type_record_num).item_type,
378: p_effective_date,
379: 'LOOKUP_TYPE',
380: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,
381: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,
382: NULL,
383: p_indent_level+1);
384:
385: /*

Line 404: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name =

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:
408: /*

Line 435: wf_lookup_types_pub.draw_lookup_list (

431: ** List all the lookup type details for this lookup type that
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:

Line 446: Wf_Core.Context('wf_lookup_types_pub', 'draw_lookup_type_list');

442: END LOOP;
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: Wf_Core.Context('wf_lookup_types_pub', 'draw_lookup_type_list');
447: wf_item_definition.Error;
448:
449: END draw_lookup_type_list;
450:

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 502: Wf_Core.Context('wf_lookup_types_vl_pub', 'draw_lookup_list');

498: END LOOP;
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: Wf_Core.Context('wf_lookup_types_vl_pub', 'draw_lookup_list');
503: wf_item_definition.Error;
504:
505: END draw_lookup_list;
506:

Line 518: (p_wf_lookup_types_tbl IN wf_lookup_types_pub.wf_lookup_types_tbl_type,

514: MODIFICATION LOG:
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;

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 540: FOR l_lookup_type_record_num IN 1..p_wf_lookup_types_tbl.count LOOP

536:
537: /*
538: ** Print out all item attribute display names in the pl*sql table
539: */
540: FOR l_lookup_type_record_num IN 1..p_wf_lookup_types_tbl.count LOOP
541:
542: /*
543: ** Open a new table for each attribute so you can control the spacing
544: ** between each attribute

Line 556: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,

552: ** name for the object.
553: */
554: wf_item_definition_util_pub.create_details_hotlink_target (
555: 'LOOKUP_TYPE',
556: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,
557: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,
558: wf_core.translate('WFITD_LOOKUP_TYPE_NAME'),
559: 0);
560:

Line 557: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,

553: */
554: wf_item_definition_util_pub.create_details_hotlink_target (
555: 'LOOKUP_TYPE',
556: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type,
557: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name,
558: wf_core.translate('WFITD_LOOKUP_TYPE_NAME'),
559: 0);
560:
561: /*

Line 567: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type);

563: ** destination for the anchor based on the row id.
564: */
565: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
566: wf_core.translate('WFITD_INTERNAL_NAME'),
567: p_wf_lookup_types_tbl(l_lookup_type_record_num).lookup_type);
568:
569: /*
570: ** Create the description row in the table
571: */

Line 574: p_wf_lookup_types_tbl(l_lookup_type_record_num).description);

570: ** Create the description row in the table
571: */
572: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
573: wf_core.translate('DESCRIPTION'),
574: p_wf_lookup_types_tbl(l_lookup_type_record_num).description);
575:
576: /*
577: ** Call function to print the customization/protection levels
578: */

Line 580: p_wf_lookup_types_tbl(l_lookup_type_record_num).custom_level,

576: /*
577: ** Call function to print the customization/protection levels
578: */
579: wf_item_definition_util_pub.draw_custom_protect_details(
580: p_wf_lookup_types_tbl(l_lookup_type_record_num).custom_level,
581: p_wf_lookup_types_tbl(l_lookup_type_record_num).protect_level);
582:
583: /*
584: ** Table is created so close it out

Line 581: p_wf_lookup_types_tbl(l_lookup_type_record_num).protect_level);

577: ** Call function to print the customization/protection levels
578: */
579: wf_item_definition_util_pub.draw_custom_protect_details(
580: p_wf_lookup_types_tbl(l_lookup_type_record_num).custom_level,
581: p_wf_lookup_types_tbl(l_lookup_type_record_num).protect_level);
582:
583: /*
584: ** Table is created so close it out
585: */

Line 607: p_wf_lookup_types_tbl(l_lookup_type_record_num).display_name =

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:
611: /*

Line 643: wf_lookup_types_pub.draw_lookup_details (

639: /*
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: /*

Line 651: IF (l_lookup_type_record_num < p_wf_lookup_types_tbl.count) THEN

647: /*
648: ** If you still have more lookup types to process then put in a
649: ** few blank lines and put in another Lookup Type Details Header
650: */
651: IF (l_lookup_type_record_num < p_wf_lookup_types_tbl.count) THEN
652:
653: /*
654: ** Put in a couple of blank lines between the current message
655: ** attributes and the next message

Line 675: IF (l_lookup_type_record_num < p_wf_lookup_types_tbl.count AND

671: ** Draw a line between each message definition
672: ** if this is not the last item in the list and if there
673: ** are no attributes in the attribute list for this message.
674: */
675: IF (l_lookup_type_record_num < p_wf_lookup_types_tbl.count AND
676: l_cur_lookup_record_num = 1) THEN
677:
678: htp.p ('

');
679:

Line 686: Wf_Core.Context('wf_lookup_types_pub', 'draw_lookup_type_details');

682: END LOOP;
683:
684: EXCEPTION
685: WHEN OTHERS THEN
686: Wf_Core.Context('wf_lookup_types_pub', 'draw_lookup_type_details');
687: wf_item_definition.Error;
688:
689: END draw_lookup_type_details;
690:

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 781: Wf_Core.Context('wf_lookup_types_vl_pub', 'draw_lookup_details');

777: END LOOP;
778:
779: EXCEPTION
780: WHEN OTHERS THEN
781: Wf_Core.Context('wf_lookup_types_vl_pub', 'draw_lookup_details');
782: wf_item_definition.Error;
783:
784: END draw_lookup_details;
785:

Line 786: END wf_lookup_types_pub;

782: wf_item_definition.Error;
783:
784: END draw_lookup_details;
785:
786: END wf_lookup_types_pub;