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_ACTIVITIES_VL_PUB dependencies on WF_ACTIVITIES_VL_PUB

Line 1: PACKAGE BODY wf_activities_vl_pub AS

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

Line 5: PACKAGE NAME: wf_activities_vl_pub

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

Line 54: p_wf_activities_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activities_vl_tbl_type,

50: (p_item_type IN VARCHAR2,
51: p_activity_type IN VARCHAR2,
52: p_effective_date IN DATE,
53: p_name IN VARCHAR2,
54: p_wf_activities_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activities_vl_tbl_type,
55: p_wf_activity_attr_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activity_attr_vl_tbl_type) IS
56:
57: /*===========================================================================
58:

Line 55: p_wf_activity_attr_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activity_attr_vl_tbl_type) IS

51: p_activity_type IN VARCHAR2,
52: p_effective_date IN DATE,
53: p_name IN VARCHAR2,
54: p_wf_activities_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activities_vl_tbl_type,
55: p_wf_activity_attr_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activity_attr_vl_tbl_type) IS
56:
57: /*===========================================================================
58:
59: CURSOR NAME: fetch_typed_activities

Line 524: Wf_Core.Context('wf_activities_vl_pub',

520: END IF;
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: Wf_Core.Context('wf_activities_vl_pub',
525: 'fetch_activities',
526: p_item_type,
527: p_activity_type,
528: TO_CHAR(p_effective_date),

Line 552: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;

548: p_effective_date IN VARCHAR2,
549: p_name IN VARCHAR2) IS
550:
551: l_username varchar2(320); -- Username to query
552: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;
553: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
554: l_effective_date DATE;
555: l_date_date DATE;
556: l_valid_date BOOLEAN;

Line 553: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;

549: p_name IN VARCHAR2) IS
550:
551: l_username varchar2(320); -- Username to query
552: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;
553: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
554: l_effective_date DATE;
555: l_date_date DATE;
556: l_valid_date BOOLEAN;
557: l_print_date VARCHAR2(80);

Line 601: wf_activities_vl_pub.fetch_activities

597:
598: /*
599: ** Get the activity definition
600: */
601: wf_activities_vl_pub.fetch_activities
602: (p_item_type,
603: p_activity_type,
604: l_effective_date,
605: p_name,

Line 612: wf_activities_vl_pub.draw_activity_details

608:
609: /*
610: ** Draw the activity definition details
611: */
612: wf_activities_vl_pub.draw_activity_details
613: (l_wf_activities_vl_tbl,
614: l_wf_activity_attr_vl_tbl,
615: l_effective_date,
616: 0,

Line 622: Wf_Core.Context('wf_activities_vl_pub',

618: FALSE);
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: Wf_Core.Context('wf_activities_vl_pub',
623: 'fetch_draw_activity_details',
624: p_item_type,
625: p_activity_type,
626: p_effective_date,

Line 652: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,

648: using the draw_activity_attr_list.
649:
650: ============================================================================*/
651: PROCEDURE draw_activity_list
652: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
653: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
654: p_effective_date IN DATE,
655: p_indent_level IN NUMBER) IS
656:

Line 653: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

649:
650: ============================================================================*/
651: PROCEDURE draw_activity_list
652: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
653: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
654: p_effective_date IN DATE,
655: p_indent_level IN NUMBER) IS
656:
657: l_activity_record_num NUMBER := 1;

Line 664: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;

660: l_highest_activity NUMBER := 1;
661: ii NUMBER := 0;
662: l_activity_type VARCHAR2(8);
663: l_summary_section_title VARCHAR2(240);
664: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
665:
666: BEGIN
667:
668: l_activity_type := 'UNSET';

Line 863: wf_activities_vl_pub.draw_activity_attr_list (

859: ** List all the activity attribute details for this message that
860: ** we found above. Add two to the current indent level so it
861: ** is pushed in past the start of the message list.
862: */
863: wf_activities_vl_pub.draw_activity_attr_list (
864: l_wf_activity_attr_vl_tbl,
865: p_effective_date,
866: p_indent_level + 2);
867:

Line 886: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_list');

882: p_indent_level);
883:
884: EXCEPTION
885: WHEN OTHERS THEN
886: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_list');
887: wf_item_definition.Error;
888:
889: END draw_activity_list;
890:

Line 903: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

899: output.
900:
901: ============================================================================*/
902: PROCEDURE draw_activity_attr_list
903: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
904: p_effective_date IN DATE,
905: p_indent_level IN NUMBER) IS
906:
907: l_record_num NUMBER;

Line 966: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_list');

962: END LOOP;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_list');
967: wf_item_definition.Error;
968:
969: END draw_activity_attr_list;
970:

Line 991: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,

987: MODIFICATION LOG:
988: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
989: ============================================================================*/
990: PROCEDURE draw_activity_details
991: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
992: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
993: p_effective_date IN DATE,
994: p_indent_level IN NUMBER,
995: p_create_child_links IN BOOLEAN,

Line 992: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

988: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
989: ============================================================================*/
990: PROCEDURE draw_activity_details
991: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
992: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
993: p_effective_date IN DATE,
994: p_indent_level IN NUMBER,
995: p_create_child_links IN BOOLEAN,
996: p_print_skipped_titles IN BOOLEAN) IS

Line 1015: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;

1011: l_activity_type VARCHAR2(8);
1012: l_end_date VARCHAR2(80);
1013: l_activity_name_prompt VARCHAR2(80);
1014: l_activity_section_title VARCHAR2(240);
1015: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
1016:
1017: BEGIN
1018:
1019: -- Check session and current user

Line 1516: wf_activities_vl_pub.draw_activity_attr_details (

1512: /*
1513: ** List all the activity attribute details for this activity that
1514: ** we found above.
1515: */
1516: wf_activities_vl_pub.draw_activity_attr_details (
1517: l_wf_activity_attr_vl_tbl,
1518: 1);
1519:
1520: /*

Line 1579: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_details');

1575: END IF;
1576:
1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_details');
1580: wf_item_definition.Error;
1581:
1582: END draw_activity_details;
1583:

Line 1595: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

1591: MODIFICATION LOG:
1592: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
1593: ============================================================================*/
1594: PROCEDURE draw_activity_attr_details
1595: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
1596: p_indent_level IN NUMBER) IS
1597:
1598: l_record_num NUMBER;
1599: ii NUMBER := 0;

Line 1819: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_details');

1815: END LOOP;
1816:
1817: EXCEPTION
1818: WHEN OTHERS THEN
1819: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_details');
1820: wf_item_definition.Error;
1821:
1822: END draw_activity_attr_details;
1823:

Line 1824: END wf_activities_vl_pub;

1820: wf_item_definition.Error;
1821:
1822: END draw_activity_attr_details;
1823:
1824: END wf_activities_vl_pub;