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.ENG_WORKFLOW_UTIL dependencies on WF_ENGINE

Line 316: l_debug_flag := WF_ENGINE.GetItemAttrText

312:
313: BEGIN
314:
315: -- Get Debug Flag
316: l_debug_flag := WF_ENGINE.GetItemAttrText
317: ( p_item_type
318: , p_item_key
319: , '.DEBUG_FLAG'
320: );

Line 328: x_output_dir := WF_ENGINE.GetItemAttrText

324: END IF ;
325:
326:
327: -- Get Debug Output Directory
328: x_output_dir := WF_ENGINE.GetItemAttrText
329: ( p_item_type
330: , p_item_key
331: , '.DEBUG_OUTPUT_DIR'
332: );

Line 336: x_debug_filename := WF_ENGINE.GetItemAttrText

332: );
333:
334:
335: -- Get Debug File Name
336: x_debug_filename := WF_ENGINE.GetItemAttrText
337: ( p_item_type
338: , p_item_key
339: , '.DEBUG_FILE_NAME'
340: );

Line 2471: x_change_id := WF_ENGINE.GetItemAttrNumber

2467:
2468: BEGIN
2469:
2470: -- Get Change Object Id
2471: x_change_id := WF_ENGINE.GetItemAttrNumber
2472: ( p_item_type
2473: , p_item_key
2474: , 'CHANGE_ID'
2475: );

Line 2495: x_change_line_id := WF_ENGINE.GetItemAttrNumber

2491: -- For upgrade, suppress the exception
2492: begin
2493:
2494: -- Get Change Line Object Id
2495: x_change_line_id := WF_ENGINE.GetItemAttrNumber
2496: ( p_item_type
2497: , p_item_key
2498: , 'CHANGE_LINE_ID'
2499: );

Line 2524: x_change_id := WF_ENGINE.GetItemAttrNumber

2520: BEGIN
2521:
2522:
2523: -- Get Change Object Id
2524: x_change_id := WF_ENGINE.GetItemAttrNumber
2525: ( p_item_type
2526: , p_item_key
2527: , 'CHANGE_ID'
2528: );

Line 2532: x_organization_id := WF_ENGINE.GetItemAttrNumber

2528: );
2529:
2530:
2531: -- Get Change Org Id
2532: x_organization_id := WF_ENGINE.GetItemAttrNumber
2533: ( p_item_type
2534: , p_item_key
2535: , 'ORGANIZATION_ID'
2536: );

Line 2539: x_change_notice := WF_ENGINE.GetItemAttrText

2535: , 'ORGANIZATION_ID'
2536: );
2537:
2538: -- Get Change Notice
2539: x_change_notice := WF_ENGINE.GetItemAttrText
2540: ( p_item_type
2541: , p_item_key
2542: , 'CHANGE_NOTICE'
2543: );

Line 2559: x_host_url := WF_ENGINE.GetItemAttrText

2555:
2556: BEGIN
2557:
2558: -- Get Host URL
2559: x_host_url := WF_ENGINE.GetItemAttrText
2560: ( p_item_type
2561: , p_item_key
2562: , 'HOST_URL'
2563: );

Line 2599: WF_ENGINE.SetItemAttrNumber

2595:
2596: BEGIN
2597:
2598: -- Set Workflow User Id
2599: WF_ENGINE.SetItemAttrNumber
2600: ( p_item_type
2601: , p_item_key
2602: , 'WF_USER_ID'
2603: , p_wf_user_id

Line 2619: WF_ENGINE.SetItemAttrText

2615:
2616: BEGIN
2617:
2618: -- Set WF Owner's User Role
2619: WF_ENGINE.SetItemAttrText
2620: ( p_item_type
2621: , p_item_key
2622: , 'WF_USER_ROLE'
2623: , p_wf_user_role

Line 2639: WF_ENGINE.SetItemAttrText

2635:
2636: BEGIN
2637:
2638: -- Set Ntf From Role
2639: WF_ENGINE.SetItemAttrText
2640: ( p_item_type
2641: , p_item_key
2642: , 'FROM_ROLE'
2643: , p_ntf_from_role

Line 2658: x_wf_user_id := WF_ENGINE.GetItemAttrNumber

2654:
2655: BEGIN
2656:
2657: -- Get Workflow User Id
2658: x_wf_user_id := WF_ENGINE.GetItemAttrNumber
2659: ( p_item_type
2660: , p_item_key
2661: , 'WF_USER_ID'
2662: );

Line 2698: x_route_id := WF_ENGINE.GetItemAttrNumber

2694:
2695: BEGIN
2696:
2697: -- Get Route Id
2698: x_route_id := WF_ENGINE.GetItemAttrNumber
2699: ( p_item_type
2700: , p_item_key
2701: , 'ROUTE_ID'
2702: );

Line 2716: x_route_object := WF_ENGINE.GetItemAttrText

2712:
2713: BEGIN
2714:
2715: -- Get Route Object
2716: x_route_object := WF_ENGINE.GetItemAttrText
2717: ( p_item_type
2718: , p_item_key
2719: , 'OBJECT_NAME'
2720: , TRUE -- ignore_notfound

Line 2817: x_route_step_id := WF_ENGINE.GetItemAttrNumber

2813:
2814: BEGIN
2815:
2816: -- Get Change Route Step Id
2817: x_route_step_id := WF_ENGINE.GetItemAttrNumber
2818: ( p_item_type
2819: , p_item_key
2820: , 'STEP_ID'
2821: );

Line 2838: WF_ENGINE.SetItemAttrNumber

2834:
2835: BEGIN
2836:
2837: -- Set Change Route Step Id
2838: WF_ENGINE.SetItemAttrNumber
2839: ( p_item_type
2840: , p_item_key
2841: , 'STEP_ID'
2842: , p_route_step_id

Line 2858: x_style_sheet := WF_ENGINE.GetItemAttrText

2854:
2855: BEGIN
2856:
2857: -- Get Style Sheet
2858: x_style_sheet := WF_ENGINE.GetItemAttrText
2859: ( p_item_type
2860: , p_item_key
2861: , 'DEFAULT_STYLE_SHEET'
2862: );

Line 2876: WF_ENGINE.SetItemAttrNumber

2872:
2873: BEGIN
2874:
2875: -- Set Action Id
2876: WF_ENGINE.SetItemAttrNumber
2877: ( p_item_type
2878: , p_item_key
2879: , 'ACTION_ID'
2880: , p_action_id

Line 2896: x_action_id := WF_ENGINE.GetItemAttrNumber

2892:
2893: BEGIN
2894:
2895: -- Get Action Id
2896: x_action_id := WF_ENGINE.GetItemAttrNumber
2897: ( p_item_type
2898: , p_item_key
2899: , 'ACTION_ID'
2900: );

Line 2916: x_timeout_min := WF_ENGINE.GetItemAttrNumber

2912: BEGIN
2913:
2914:
2915: -- Get Response Timeout Min
2916: x_timeout_min := WF_ENGINE.GetItemAttrNumber
2917: ( p_item_type
2918: , p_item_key
2919: , 'RESPONSE_TIMEOUT'
2920: );

Line 2955: WF_ENGINE.SetItemAttrNumber( p_item_type

2951:
2952: END IF ;
2953:
2954: -- Set the timeout min to Item Attribute for ntf time out
2955: WF_ENGINE.SetItemAttrNumber( p_item_type
2956: , p_item_key
2957: , 'RESPONSE_TIMEOUT'
2958: , l_timeout_min
2959: );

Line 2992: WF_ENGINE.SetItemAttrNumber( p_item_type

2988:
2989: END IF ;
2990:
2991: -- Set the timeout min to Item Attribute for ntf time out
2992: WF_ENGINE.SetItemAttrNumber( p_item_type
2993: , p_item_key
2994: , 'RESPONSE_TIMEOUT'
2995: , l_timeout_min
2996: );

Line 3098: WF_ENGINE.SetItemAttrText( p_item_type

3094:
3095: END IF ;
3096:
3097: -- Set Step Activity Condition to Item Attr
3098: WF_ENGINE.SetItemAttrText( p_item_type
3099: , p_item_key
3100: , 'STEP_CONDITION'
3101: , p_condition_type_code );
3102:

Line 3106: WF_ENGINE.SetItemAttrText( p_item_type

3102:
3103:
3104: -- Set Step Activity Voting Option
3105: -- for Notification
3106: WF_ENGINE.SetItemAttrText( p_item_type
3107: , p_item_key
3108: , 'STEP_VOTING_OPTION'
3109: , l_step_voting_option);
3110:

Line 3114: WF_ENGINE.SetItemAttrNumber( p_item_type

3110:
3111:
3112: -- Set Yes response percentage of votes
3113: -- for Notification
3114: WF_ENGINE.SetItemAttrNumber( p_item_type
3115: , p_item_key
3116: , 'YES_RESPONSE_PERCENT'
3117: , l_yes_percentage );
3118:

Line 3121: WF_ENGINE.SetItemAttrNumber( p_item_type

3117: , l_yes_percentage );
3118:
3119: -- Set No response percentage of votes
3120: -- for Notification
3121: WF_ENGINE.SetItemAttrNumber( p_item_type
3122: , p_item_key
3123: , 'NO_RESPONSE_PERCENT'
3124: , l_no_percentage );
3125:

Line 3738: x_change_name := WF_ENGINE.GetItemAttrText

3734:
3735: BEGIN
3736:
3737: -- Change Object Name
3738: x_change_name := WF_ENGINE.GetItemAttrText
3739: ( p_item_type
3740: , p_item_key
3741: , 'CHANGE_NAME'
3742: );

Line 3745: x_change_managemtent_type := WF_ENGINE.GetItemAttrText

3741: , 'CHANGE_NAME'
3742: );
3743:
3744: -- Change Management Type
3745: x_change_managemtent_type := WF_ENGINE.GetItemAttrText
3746: ( p_item_type
3747: , p_item_key
3748: , 'CHANGE_MANAGEMENT_TYPE'
3749: );

Line 3753: x_description := WF_ENGINE.GetItemAttrText

3749: );
3750:
3751:
3752: -- Description
3753: x_description := WF_ENGINE.GetItemAttrText
3754: ( p_item_type
3755: , p_item_key
3756: , 'DESCRIPTION'
3757: );

Line 3760: x_change_status := WF_ENGINE.GetItemAttrText

3756: , 'DESCRIPTION'
3757: );
3758:
3759: -- Status
3760: x_change_status := WF_ENGINE.GetItemAttrText
3761: ( p_item_type
3762: , p_item_key
3763: , 'STATUS'
3764: );

Line 3769: x_approval_status := WF_ENGINE.GetItemAttrText

3765:
3766:
3767:
3768: -- Approval Status
3769: x_approval_status := WF_ENGINE.GetItemAttrText
3770: ( p_item_type
3771: , p_item_key
3772: , 'APPROVAL_STATUS'
3773: );

Line 3777: x_assignee := WF_ENGINE.GetItemAttrText

3773: );
3774:
3775:
3776: -- Assignee Name
3777: x_assignee := WF_ENGINE.GetItemAttrText
3778: ( p_item_type
3779: , p_item_key
3780: , 'ASSIGNEE_NAME'
3781: );

Line 3785: x_assignee_company := WF_ENGINE.GetItemAttrText

3781: );
3782:
3783:
3784: -- Assignee Company
3785: x_assignee_company := WF_ENGINE.GetItemAttrText
3786: ( p_item_type
3787: , p_item_key
3788: , 'ASSIGNEE_COMPANY'
3789: );

Line 3792: x_priority := WF_ENGINE.GetItemAttrText

3788: , 'ASSIGNEE_COMPANY'
3789: );
3790:
3791: -- Priority
3792: x_priority := WF_ENGINE.GetItemAttrText
3793: ( p_item_type
3794: , p_item_key
3795: , 'PRIORITY'
3796: );

Line 3800: x_reason := WF_ENGINE.GetItemAttrText

3796: );
3797:
3798:
3799: -- Reason
3800: x_reason := WF_ENGINE.GetItemAttrText
3801: ( p_item_type
3802: , p_item_key
3803: , 'REASON'
3804: );

Line 3826: x_line_sequence_number := WF_ENGINE.GetItemAttrNumber

3822:
3823: BEGIN
3824:
3825: -- Line Sequence Number
3826: x_line_sequence_number := WF_ENGINE.GetItemAttrNumber
3827: ( p_item_type
3828: , p_item_key
3829: , 'LINE_SEQUENCE_NUMBER'
3830: );

Line 3833: x_line_name := WF_ENGINE.GetItemAttrText

3829: , 'LINE_SEQUENCE_NUMBER'
3830: );
3831:
3832: -- Line Object Name
3833: x_line_name := WF_ENGINE.GetItemAttrText
3834: ( p_item_type
3835: , p_item_key
3836: , 'LINE_NAME'
3837: );

Line 3840: x_line_description := WF_ENGINE.GetItemAttrText

3836: , 'LINE_NAME'
3837: );
3838:
3839: -- Line Description
3840: x_line_description := WF_ENGINE.GetItemAttrText
3841: ( p_item_type
3842: , p_item_key
3843: , 'LINE_DESCRIPTION'
3844: );

Line 3847: x_line_status := WF_ENGINE.GetItemAttrText

3843: , 'LINE_DESCRIPTION'
3844: );
3845:
3846: -- Line Status
3847: x_line_status := WF_ENGINE.GetItemAttrText
3848: ( p_item_type
3849: , p_item_key
3850: , 'LINE_STATUS'
3851: );

Line 3854: x_line_assignee := WF_ENGINE.GetItemAttrText

3850: , 'LINE_STATUS'
3851: );
3852:
3853: -- Line Assignee Name
3854: x_line_assignee := WF_ENGINE.GetItemAttrText
3855: ( p_item_type
3856: , p_item_key
3857: , 'LINE_ASSIGNEE_NAME'
3858: );

Line 3861: x_line_assignee_company := WF_ENGINE.GetItemAttrText

3857: , 'LINE_ASSIGNEE_NAME'
3858: );
3859:
3860: -- Line Assignee Company
3861: x_line_assignee_company := WF_ENGINE.GetItemAttrText
3862: ( p_item_type
3863: , p_item_key
3864: , 'LINE_ASSIGNEE_COMPANY'
3865: );

Line 4137: WF_ENGINE.SetItemAttrText( p_item_type

4133: --
4134: IF p_item_type IS NOT NULL AND p_item_key IS NOT NULL
4135: THEN
4136:
4137: WF_ENGINE.SetItemAttrText( p_item_type
4138: , p_item_key
4139: , 'APPROVAL_STATUS'
4140: , l_approval_status );
4141:

Line 4218: WF_ENGINE.SetItemAttrText( p_item_type

4214: --
4215: IF p_item_type IS NOT NULL AND p_item_key IS NOT NULL
4216: THEN
4217:
4218: WF_ENGINE.SetItemAttrText( p_item_type
4219: , p_item_key
4220: , 'LINE_APPROVAL_STATUS'
4221: , l_approval_status );
4222:

Line 4778: -- WF_ENGINE.NameTabTyp Wf_Item_Attribute_Values.NAME%TYPE

4774: l_api_name CONSTANT VARCHAR2(30) := 'SetAttributes';
4775:
4776: -- PL/SQL Table Type Column Datatype Definition
4777: -- PL/SQL Table Type Column DataType Definition
4778: -- WF_ENGINE.NameTabTyp Wf_Item_Attribute_Values.NAME%TYPE
4779: -- WF_ENGINE.TextTabTyp Wf_Item_Attribute_Values.TEXT_VALUE%TYPE
4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE
4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE
4782:

Line 4779: -- WF_ENGINE.TextTabTyp Wf_Item_Attribute_Values.TEXT_VALUE%TYPE

4775:
4776: -- PL/SQL Table Type Column Datatype Definition
4777: -- PL/SQL Table Type Column DataType Definition
4778: -- WF_ENGINE.NameTabTyp Wf_Item_Attribute_Values.NAME%TYPE
4779: -- WF_ENGINE.TextTabTyp Wf_Item_Attribute_Values.TEXT_VALUE%TYPE
4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE
4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE
4782:
4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;

Line 4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE

4776: -- PL/SQL Table Type Column Datatype Definition
4777: -- PL/SQL Table Type Column DataType Definition
4778: -- WF_ENGINE.NameTabTyp Wf_Item_Attribute_Values.NAME%TYPE
4779: -- WF_ENGINE.TextTabTyp Wf_Item_Attribute_Values.TEXT_VALUE%TYPE
4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE
4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE
4782:
4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;

Line 4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE

4777: -- PL/SQL Table Type Column DataType Definition
4778: -- WF_ENGINE.NameTabTyp Wf_Item_Attribute_Values.NAME%TYPE
4779: -- WF_ENGINE.TextTabTyp Wf_Item_Attribute_Values.TEXT_VALUE%TYPE
4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE
4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE
4782:
4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
4785:

Line 4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;

4779: -- WF_ENGINE.TextTabTyp Wf_Item_Attribute_Values.TEXT_VALUE%TYPE
4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE
4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE
4782:
4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
4785:
4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;

Line 4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;

4780: -- WF_ENGINE.NumTabTyp Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE
4781: -- WF_ENGINE.DateTabTyp Wf_Item_Attribute_Values.DATE_VALUE%TYPE
4782:
4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
4785:
4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
4788:

Line 4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;

4782:
4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
4785:
4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
4788:
4789: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
4790: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;

Line 4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;

4783: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
4784: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
4785:
4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
4788:
4789: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
4790: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;
4791:

Line 4789: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;

4785:
4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
4788:
4789: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
4790: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;
4791:
4792: I PLS_INTEGER ;
4793:

Line 4790: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;

4786: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
4787: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
4788:
4789: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
4790: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;
4791:
4792: I PLS_INTEGER ;
4793:
4794: l_change_id NUMBER ;

Line 5507: Write_Debug('Call WF_ENGINE.SetItemAttrTextArray . . .');

5503:
5504:
5505:
5506: IF g_debug_flag THEN
5507: Write_Debug('Call WF_ENGINE.SetItemAttrTextArray . . .');
5508: END IF ;
5509:
5510:
5511: -- Set Text Attributes

Line 5512: WF_ENGINE.SetItemAttrTextArray

5508: END IF ;
5509:
5510:
5511: -- Set Text Attributes
5512: WF_ENGINE.SetItemAttrTextArray
5513: ( itemtype => p_item_type
5514: , itemkey => p_item_key
5515: , aname => l_text_attr_name_tbl
5516: , avalue => l_text_attr_value_tbl

Line 5677: Write_Debug('Call WF_ENGINE.SetItemAttrNumberArray . . .');

5673:
5674:
5675:
5676: IF g_debug_flag THEN
5677: Write_Debug('Call WF_ENGINE.SetItemAttrNumberArray . . .');
5678: END IF ;
5679:
5680: -- Set Number Attributes
5681: WF_ENGINE.SetItemAttrNumberArray

Line 5681: WF_ENGINE.SetItemAttrNumberArray

5677: Write_Debug('Call WF_ENGINE.SetItemAttrNumberArray . . .');
5678: END IF ;
5679:
5680: -- Set Number Attributes
5681: WF_ENGINE.SetItemAttrNumberArray
5682: ( itemtype => p_item_type
5683: , itemkey => p_item_key
5684: , aname => l_num_attr_name_tbl
5685: , avalue => l_num_attr_value_tbl

Line 5701: Write_Debug('Call WF_ENGINE.SetItemAttrDateArray . . .');

5697:
5698: IF l_date_attr_name_tbl.EXISTS(1) THEN
5699:
5700: IF g_debug_flag THEN
5701: Write_Debug('Call WF_ENGINE.SetItemAttrDateArray . . .');
5702: END IF ;
5703:
5704: -- Set Date Attributes
5705: WF_ENGINE.SetItemAttrDateArray

Line 5705: WF_ENGINE.SetItemAttrDateArray

5701: Write_Debug('Call WF_ENGINE.SetItemAttrDateArray . . .');
5702: END IF ;
5703:
5704: -- Set Date Attributes
5705: WF_ENGINE.SetItemAttrDateArray
5706: ( itemtype => p_item_type
5707: , itemkey => p_item_key
5708: , aname => l_date_attr_name_tbl
5709: , avalue => l_date_attr_value_tbl

Line 6302: WF_ENGINE.ItemStatus

6298: -- p_wf_user_id should not be null
6299:
6300:
6301: -- Check Process Status
6302: WF_ENGINE.ItemStatus
6303: ( itemtype => p_item_type
6304: , itemkey => p_item_key
6305: , status => l_status
6306: , result => l_result

Line 6418: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

6414:
6415: -- Create adhoc role and add users to role
6416: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
6417:
6418: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
6419: , p_item_key
6420: , 'ADHOC_PARTY_ROLE');
6421:
6422: l_role_display_name := l_role_name ;

Line 6532: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

6528: -- Create adhoc role and add users to role
6529: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
6530:
6531:
6532: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
6533: , p_item_key
6534: , 'ASSIGNEE_ROLE');
6535:
6536: l_role_display_name := l_role_name ;

Line 6701: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

6697:
6698: -- Create adhoc role and add users to role
6699: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
6700:
6701: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
6702: , p_item_key
6703: , 'REVIEWERS_ROLE');
6704:
6705:

Line 6963: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

6959:
6960: -- Create adhoc role and add users to role
6961: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
6962:
6963: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
6964: , p_item_key
6965: , 'LINE_ASSIGNEE_ROLE');
6966:
6967: l_role_display_name := l_role_name ;

Line 7145: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

7141: -- Create adhoc role and add users to role
7142: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
7143:
7144:
7145: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
7146: , p_item_key
7147: , 'LINE_REVIEWERS_ROLE');
7148:
7149: l_role_display_name := l_role_name ;

Line 7271: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

7267: -- Create adhoc role and add users to role
7268: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
7269:
7270:
7271: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
7272: , p_item_key
7273: , 'ROUTE_PEOPLE_ROLE');
7274:
7275: l_role_display_name := l_role_name ;

Line 7384: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type

7380: -- Create adhoc role and add users to role
7381: IF ( l_role_users IS NOT NULL AND l_role_users.COUNT > 0 ) THEN
7382:
7383:
7384: l_role_name := WF_ENGINE.GetItemAttrText( p_item_type
7385: , p_item_key
7386: , 'STEP_PEOPLE_ROLE');
7387:
7388: l_role_display_name := l_role_name ;

Line 8193: WF_ENGINE.SetItemParent

8189:
8190: FOR i IN 1..l_line_route_wf_tbl.COUNT LOOP
8191:
8192: -- Set Parent Worklfow Process
8193: WF_ENGINE.SetItemParent
8194: ( itemtype => l_line_route_wf_tbl(i).item_type
8195: , itemkey => l_line_route_wf_tbl(i).item_key
8196: , parent_itemtype => l_hdr_route_item_type
8197: , parent_itemkey => l_hdr_route_item_key

Line 8622: l_auto_revoke_resp := WF_ENGINE.GetActivityAttrText

8618: END IF ;
8619:
8620: -- R12B
8621: -- Need to revoke auto grant if the response is DECLIEND.
8622: l_auto_revoke_resp := WF_ENGINE.GetActivityAttrText
8623: ( p_item_type
8624: , p_item_key
8625: , p_actid
8626: , G_ATTR_AUTO_REVOKE_RESPONSE -- aname

Line 9644: if (funcmode <> wf_engine.eng_run)

9640: Write_Debug('Start VoteForResultType ...' );
9641: END IF ;
9642:
9643: -- Do nothing unless in RUN or TIMEOUT modes
9644: if (funcmode <> wf_engine.eng_run)
9645: and (funcmode <> wf_engine.eng_timeout) then
9646: resultout := wf_engine.eng_null;
9647: return;
9648: end if;

Line 9645: and (funcmode <> wf_engine.eng_timeout) then

9641: END IF ;
9642:
9643: -- Do nothing unless in RUN or TIMEOUT modes
9644: if (funcmode <> wf_engine.eng_run)
9645: and (funcmode <> wf_engine.eng_timeout) then
9646: resultout := wf_engine.eng_null;
9647: return;
9648: end if;
9649:

Line 9646: resultout := wf_engine.eng_null;

9642:
9643: -- Do nothing unless in RUN or TIMEOUT modes
9644: if (funcmode <> wf_engine.eng_run)
9645: and (funcmode <> wf_engine.eng_timeout) then
9646: resultout := wf_engine.eng_null;
9647: return;
9648: end if;
9649:
9650: -- SYNCHMODE: Not allowed

Line 9651: if (itemkey = wf_engine.eng_synch) then

9647: return;
9648: end if;
9649:
9650: -- SYNCHMODE: Not allowed
9651: if (itemkey = wf_engine.eng_synch) then
9652: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');
9653: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
9654: end if;
9655:

Line 9665: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

9661:
9662: -- Get Notifications group_id for activity
9663: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
9664: l_group_id,l_user);
9665: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
9666: actid,'VOTING_OPTION');
9667:
9668: IF g_debug_flag THEN
9669: Write_Debug('Got Ntf Group Id: ' || to_char(l_group_id) );

Line 9700: if (funcmode = wf_engine.eng_timeout) then

9696:
9697:
9698: -- If this is timeout mode, then use the percent of votes cast so far.
9699: -- If this is run mode, then use the percent of total votes possible.
9700: if (funcmode = wf_engine.eng_timeout) then
9701: l_per_code := l_per_of_vote;
9702: else
9703: l_per_code := l_per_of_total;
9704: end if;

Line 9712: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,

9708: END IF ;
9709:
9710:
9711: -- Get percent vote needed for this result to succeed
9712: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,
9713: actid,result_rec.result_code);
9714:
9715:
9716: IF g_debug_flag THEN

Line 9734: default_result := wf_engine.eng_tie;

9730: max_default := l_code_count;
9731: default_result := result_rec.result_code;
9732: elsif (l_code_count = max_default) then
9733: -- Tie for default result.
9734: default_result := wf_engine.eng_tie;
9735: end if;
9736: else
9737:
9738: IF g_debug_flag THEN

Line 9760: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;

9756: END IF ;
9757:
9758: else
9759: -- This is the second result to be satisfied. Return a tie.
9760: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;
9761:
9762: IF g_debug_flag THEN
9763: Write_Debug('This is the second result to be satisfied ' );
9764: END IF ;

Line 9784: resultout := wf_engine.eng_completed||':'||result;

9780: Write_Debug('Satisfied result IS NOT NULL ' );
9781: END IF ;
9782:
9783: -- Return the satisfied result code.
9784: resultout := wf_engine.eng_completed||':'||result;
9785: else
9786:
9787: IF g_debug_flag THEN
9788: Write_Debug('Satisfied result IS NULL ' );

Line 9793: if (funcmode = wf_engine.eng_run and

9789: END IF ;
9790:
9791:
9792: -- If we get here no non-default results were satisfied.
9793: if (funcmode = wf_engine.eng_run and
9794: wf_notification.OpenNotificationsExist(l_group_id)) then
9795: -- Not timed out and still open notifications.
9796: -- Return waiting to continue voting.
9797:

Line 9802: resultout := wf_engine.eng_waiting;

9798: IF g_debug_flag THEN
9799: Write_Debug('Not timed out and still open notifications. Return waiting to continue voting ' );
9800: END IF ;
9801:
9802: resultout := wf_engine.eng_waiting;
9803: elsif (default_result is not null) then
9804: -- Either timeout or all notifications closed
9805: -- Return default result if one found.
9806: resultout := wf_engine.eng_completed||':'||default_result;

Line 9806: resultout := wf_engine.eng_completed||':'||default_result;

9802: resultout := wf_engine.eng_waiting;
9803: elsif (default_result is not null) then
9804: -- Either timeout or all notifications closed
9805: -- Return default result if one found.
9806: resultout := wf_engine.eng_completed||':'||default_result;
9807:
9808: IF g_debug_flag THEN
9809: Write_Debug('Either timeout or all notifications closed. Return default result if one found ' );
9810: END IF ;

Line 9820: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;

9816: IF g_debug_flag THEN
9817: Write_Debug('Timeout or all notifications closed, and no default. Return nomatch ' );
9818: END IF ;
9819:
9820: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;
9821: end if;
9822: end if;
9823: return;
9824:

Line 10112: if (funcmode <> wf_engine.eng_run)

10108: Write_Debug('Start PeopleLevelVoteForResultType...' );
10109: END IF ;
10110:
10111: -- Do nothing unless in RUN or TIMEOUT modes
10112: if (funcmode <> wf_engine.eng_run)
10113: and (funcmode <> wf_engine.eng_timeout) then
10114: resultout := wf_engine.eng_null;
10115: return;
10116: end if;

Line 10113: and (funcmode <> wf_engine.eng_timeout) then

10109: END IF ;
10110:
10111: -- Do nothing unless in RUN or TIMEOUT modes
10112: if (funcmode <> wf_engine.eng_run)
10113: and (funcmode <> wf_engine.eng_timeout) then
10114: resultout := wf_engine.eng_null;
10115: return;
10116: end if;
10117:

Line 10114: resultout := wf_engine.eng_null;

10110:
10111: -- Do nothing unless in RUN or TIMEOUT modes
10112: if (funcmode <> wf_engine.eng_run)
10113: and (funcmode <> wf_engine.eng_timeout) then
10114: resultout := wf_engine.eng_null;
10115: return;
10116: end if;
10117:
10118: -- SYNCHMODE: Not allowed

Line 10119: if (itemkey = wf_engine.eng_synch) then

10115: return;
10116: end if;
10117:
10118: -- SYNCHMODE: Not allowed
10119: if (itemkey = wf_engine.eng_synch) then
10120: Wf_Core.Token('OPERATION', 'Eng_Workflow_Util.PeopleLevelVoteForResultType');
10121: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
10122: end if;
10123:

Line 10136: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

10132: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
10133: l_group_id,l_user);
10134:
10135: -- Get Voting Option
10136: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10137: actid,'VOTING_OPTION');
10138:
10139: l_mandatory_result := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10140: actid,'MANDATORY', true);

Line 10139: l_mandatory_result := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

10135: -- Get Voting Option
10136: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10137: actid,'VOTING_OPTION');
10138:
10139: l_mandatory_result := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10140: actid,'MANDATORY', true);
10141:
10142:
10143: IF g_debug_flag THEN

Line 10218: if (funcmode = wf_engine.eng_timeout) then

10214:
10215:
10216: -- If this is timeout mode, then use the percent of votes cast so far.
10217: -- If this is run mode, then use the percent of total votes possible.
10218: if (funcmode = wf_engine.eng_timeout) then
10219: l_per_code := l_per_of_vote;
10220: else
10221: l_per_code := l_per_of_total;
10222: end if;

Line 10230: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,

10226: END IF ;
10227:
10228:
10229: -- Get percent vote needed for this result to succeed
10230: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,
10231: actid,result_rec.result_code);
10232:
10233:
10234: IF g_debug_flag THEN

Line 10252: default_result := wf_engine.eng_tie;

10248: max_default := l_code_count;
10249: default_result := result_rec.result_code;
10250: elsif (l_code_count = max_default) then
10251: -- Tie for default result.
10252: default_result := wf_engine.eng_tie;
10253: end if;
10254: else
10255:
10256: IF g_debug_flag THEN

Line 10278: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;

10274: END IF ;
10275:
10276: else
10277: -- This is the second result to be satisfied. Return a tie.
10278: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;
10279:
10280: IF g_debug_flag THEN
10281: Write_Debug('This is the second result to be satisfied ' );
10282: END IF ;

Line 10302: resultout := wf_engine.eng_completed||':'||result;

10298: Write_Debug('Satisfied result IS NOT NULL ' );
10299: END IF ;
10300:
10301: -- Return the satisfied result code.
10302: resultout := wf_engine.eng_completed||':'||result;
10303: else
10304:
10305: IF g_debug_flag THEN
10306: Write_Debug('Satisfied result IS NULL ' );

Line 10311: if (funcmode = wf_engine.eng_run and

10307: END IF ;
10308:
10309:
10310: -- If we get here no non-default results were satisfied.
10311: if (funcmode = wf_engine.eng_run and
10312: wf_notification.OpenNotificationsExist(l_group_id)) then
10313: -- Not timed out and still open notifications.
10314: -- Return waiting to continue voting.
10315:

Line 10320: resultout := wf_engine.eng_waiting;

10316: IF g_debug_flag THEN
10317: Write_Debug('Not timed out and still open notifications. Return waiting to continue voting ' );
10318: END IF ;
10319:
10320: resultout := wf_engine.eng_waiting;
10321: elsif (default_result is not null) then
10322: -- Either timeout or all notifications closed
10323: -- Return default result if one found.
10324: resultout := wf_engine.eng_completed||':'||default_result;

Line 10324: resultout := wf_engine.eng_completed||':'||default_result;

10320: resultout := wf_engine.eng_waiting;
10321: elsif (default_result is not null) then
10322: -- Either timeout or all notifications closed
10323: -- Return default result if one found.
10324: resultout := wf_engine.eng_completed||':'||default_result;
10325:
10326: IF g_debug_flag THEN
10327: Write_Debug('Either timeout or all notifications closed. Return default result if one found ' );
10328: END IF ;

Line 10338: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;

10334: IF g_debug_flag THEN
10335: Write_Debug('Timeout or all notifications closed, and no default. Return nomatch ' );
10336: END IF ;
10337:
10338: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;
10339: end if;
10340: end if;
10341: return;
10342:

Line 10382: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

10378: Write_Debug('-----------------------------------------------------');
10379: END IF ;
10380:
10381: -- Get Voting Option
10382: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10383: actid,'VOTING_OPTION');
10384:
10385:
10386:

Line 10564: wf_engine.CompleteActivity

10560: IF g_debug_flag THEN
10561: Write_Debug('calling CompleteActivity . . . ');
10562: END IF ;
10563:
10564: wf_engine.CompleteActivity
10565: ( l_parent_itemtype
10566: , l_parent_itemkey
10567: , p_waiting_activity
10568: , wf_engine.eng_null );

Line 10568: , wf_engine.eng_null );

10564: wf_engine.CompleteActivity
10565: ( l_parent_itemtype
10566: , l_parent_itemkey
10567: , p_waiting_activity
10568: , wf_engine.eng_null );
10569:
10570: exception
10571: when others then
10572: --

Line 10578: x_resultout := wf_engine.eng_null;

10574: -- and wait for master flow
10575: --
10576: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
10577: wf_core.clear;
10578: x_resultout := wf_engine.eng_null;
10579: IF g_debug_flag THEN
10580: Write_Debug('call to CompleteActivity cannot find activity. . . ');
10581: END IF ;
10582: else

Line 10591: x_resultout := wf_engine.eng_null;

10587: END IF ;
10588:
10589: END IF ; -- parent item type and key are not null
10590:
10591: x_resultout := wf_engine.eng_null;
10592: return ;
10593:
10594: else
10595: -- p_waiting_flow is not APPROVAL

Line 10651: x_resultout := wf_engine.eng_notified ||':'||

10647:
10648:
10649: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10650: THEN
10651: x_resultout := wf_engine.eng_notified ||':'||
10652: wf_engine.eng_null ||':'||
10653: wf_engine.eng_null;
10654: ELSE
10655: x_resultout := wf_engine.eng_null;

Line 10652: wf_engine.eng_null ||':'||

10648:
10649: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10650: THEN
10651: x_resultout := wf_engine.eng_notified ||':'||
10652: wf_engine.eng_null ||':'||
10653: wf_engine.eng_null;
10654: ELSE
10655: x_resultout := wf_engine.eng_null;
10656: END IF ;

Line 10653: wf_engine.eng_null;

10649: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10650: THEN
10651: x_resultout := wf_engine.eng_notified ||':'||
10652: wf_engine.eng_null ||':'||
10653: wf_engine.eng_null;
10654: ELSE
10655: x_resultout := wf_engine.eng_null;
10656: END IF ;
10657:

Line 10655: x_resultout := wf_engine.eng_null;

10651: x_resultout := wf_engine.eng_notified ||':'||
10652: wf_engine.eng_null ||':'||
10653: wf_engine.eng_null;
10654: ELSE
10655: x_resultout := wf_engine.eng_null;
10656: END IF ;
10657:
10658: return ;
10659:

Line 10719: l_orig_user_id := wf_engine.GetItemAttrNumber

10715: END LOOP ;
10716:
10717:
10718: -- Get Original user_id and party_id who launched workflow
10719: l_orig_user_id := wf_engine.GetItemAttrNumber
10720: ( p_itemtype
10721: , p_itemkey
10722: , 'WF_USER_ID'
10723: );

Line 11904: WF_ENGINE.CreateProcess

11900: Write_Debug('2-2. Get Spcial API Caller: ' || l_api_caller );
11901: END IF ;
11902:
11903: -- Set Workflow Process Owner
11904: WF_ENGINE.CreateProcess
11905: ( itemtype => p_item_type
11906: , itemkey => x_item_key
11907: , process => p_process_name
11908: , user_key => l_wf_user_key

Line 11972: WF_ENGINE.SetItemParent

11968: AND p_item_type <> Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
11969: THEN
11970:
11971: -- Set Parent Worklfow Process
11972: WF_ENGINE.SetItemParent
11973: ( itemtype => p_item_type
11974: , itemkey => x_item_key
11975: , parent_itemtype => p_parent_item_type
11976: , parent_itemkey => p_parent_item_key

Line 12343: Write_Debug('Calling WF_ENGINE.StartProcess . . .') ;

12339: AND x_item_key IS NOT NULL
12340: THEN
12341:
12342: IF g_debug_flag THEN
12343: Write_Debug('Calling WF_ENGINE.StartProcess . . .') ;
12344: END IF ;
12345:
12346:
12347: -- Start process

Line 12348: WF_ENGINE.StartProcess

12344: END IF ;
12345:
12346:
12347: -- Start process
12348: WF_ENGINE.StartProcess
12349: ( itemtype => p_item_type
12350: , itemkey => x_item_key);
12351:
12352: END IF ;

Line 13036: WF_ENGINE.CompleteActivity( p_item_type

13032: Write_Debug('6-2. Complete Abort Block Activity. . .' );
13033: END IF ;
13034:
13035:
13036: WF_ENGINE.CompleteActivity( p_item_type
13037: , p_item_key
13038: , Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13039: , Eng_Workflow_Util.G_WF_COMPLETE
13040: );

Line 13050: WF_ENGINE.AbortProcess( p_item_type

13046: END IF ;
13047:
13048:
13049:
13050: WF_ENGINE.AbortProcess( p_item_type
13051: , p_Item_key
13052: , p_process_name
13053: );
13054:

Line 13296: l_comment := WF_ENGINE.context_user_comment;

13292: ) ;
13293:
13294:
13295: l_notification_id :=p_notification_id;
13296: l_comment := WF_ENGINE.context_user_comment;
13297:
13298:
13299: IF g_debug_flag THEN
13300: Write_Debug('Route Step id ' || to_char(l_step_id));

Line 13303: Write_Debug('Route new role ' || WF_ENGINE.context_new_role);

13299: IF g_debug_flag THEN
13300: Write_Debug('Route Step id ' || to_char(l_step_id));
13301: Write_Debug('Route p_item_type ' || p_item_type);
13302: Write_Debug('Route p_item_key ' || p_item_key);
13303: Write_Debug('Route new role ' || WF_ENGINE.context_new_role);
13304: Write_Debug('Change Id ' || to_char(l_change_id));
13305: END IF ;
13306:
13307:

Line 13310: WHERE user_name = WF_ENGINE.context_new_role;

13306:
13307:
13308: SELECT person_id into l_new_party_id
13309: FROM ENG_SECURITY_PEOPLE_V
13310: WHERE user_name = WF_ENGINE.context_new_role;
13311:
13312: IF g_debug_flag THEN
13313: Write_Debug('Route NEW Party id to whom NTF is being transfered or reassigned: ' || to_char(l_new_party_id));
13314: END IF ;