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_PUB

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 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 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 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 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 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 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 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 786: END wf_lookup_types_pub;

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