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 8691: l_auto_revoke_resp := WF_ENGINE.GetActivityAttrText

8687: END IF ;
8688:
8689: -- R12B
8690: -- Need to revoke auto grant if the response is DECLIEND.
8691: l_auto_revoke_resp := WF_ENGINE.GetActivityAttrText
8692: ( p_item_type
8693: , p_item_key
8694: , p_actid
8695: , G_ATTR_AUTO_REVOKE_RESPONSE -- aname

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

9716: Write_Debug('Start VoteForResultType ...' );
9717: END IF ;
9718:
9719: -- Do nothing unless in RUN or TIMEOUT modes
9720: if (funcmode <> wf_engine.eng_run)
9721: and (funcmode <> wf_engine.eng_timeout) then
9722: resultout := wf_engine.eng_null;
9723: return;
9724: end if;

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

9717: END IF ;
9718:
9719: -- Do nothing unless in RUN or TIMEOUT modes
9720: if (funcmode <> wf_engine.eng_run)
9721: and (funcmode <> wf_engine.eng_timeout) then
9722: resultout := wf_engine.eng_null;
9723: return;
9724: end if;
9725:

Line 9722: resultout := wf_engine.eng_null;

9718:
9719: -- Do nothing unless in RUN or TIMEOUT modes
9720: if (funcmode <> wf_engine.eng_run)
9721: and (funcmode <> wf_engine.eng_timeout) then
9722: resultout := wf_engine.eng_null;
9723: return;
9724: end if;
9725:
9726: -- SYNCHMODE: Not allowed

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

9723: return;
9724: end if;
9725:
9726: -- SYNCHMODE: Not allowed
9727: if (itemkey = wf_engine.eng_synch) then
9728: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');
9729: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
9730: end if;
9731:

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

9737:
9738: -- Get Notifications group_id for activity
9739: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
9740: l_group_id,l_user);
9741: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
9742: actid,'VOTING_OPTION');
9743:
9744: IF g_debug_flag THEN
9745: Write_Debug('Got Ntf Group Id: ' || to_char(l_group_id) );

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

9772:
9773:
9774: -- If this is timeout mode, then use the percent of votes cast so far.
9775: -- If this is run mode, then use the percent of total votes possible.
9776: if (funcmode = wf_engine.eng_timeout) then
9777: l_per_code := l_per_of_vote;
9778: else
9779: l_per_code := l_per_of_total;
9780: end if;

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

9784: END IF ;
9785:
9786:
9787: -- Get percent vote needed for this result to succeed
9788: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,
9789: actid,result_rec.result_code);
9790:
9791:
9792: IF g_debug_flag THEN

Line 9810: default_result := wf_engine.eng_tie;

9806: max_default := l_code_count;
9807: default_result := result_rec.result_code;
9808: elsif (l_code_count = max_default) then
9809: -- Tie for default result.
9810: default_result := wf_engine.eng_tie;
9811: end if;
9812: else
9813:
9814: IF g_debug_flag THEN

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

9832: END IF ;
9833:
9834: else
9835: -- This is the second result to be satisfied. Return a tie.
9836: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;
9837:
9838: IF g_debug_flag THEN
9839: Write_Debug('This is the second result to be satisfied ' );
9840: END IF ;

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

9856: Write_Debug('Satisfied result IS NOT NULL ' );
9857: END IF ;
9858:
9859: -- Return the satisfied result code.
9860: resultout := wf_engine.eng_completed||':'||result;
9861: else
9862:
9863: IF g_debug_flag THEN
9864: Write_Debug('Satisfied result IS NULL ' );

Line 9869: if (funcmode = wf_engine.eng_run and

9865: END IF ;
9866:
9867:
9868: -- If we get here no non-default results were satisfied.
9869: if (funcmode = wf_engine.eng_run and
9870: wf_notification.OpenNotificationsExist(l_group_id)) then
9871: -- Not timed out and still open notifications.
9872: -- Return waiting to continue voting.
9873:

Line 9878: resultout := wf_engine.eng_waiting;

9874: IF g_debug_flag THEN
9875: Write_Debug('Not timed out and still open notifications. Return waiting to continue voting ' );
9876: END IF ;
9877:
9878: resultout := wf_engine.eng_waiting;
9879: elsif (default_result is not null) then
9880: -- Either timeout or all notifications closed
9881: -- Return default result if one found.
9882: resultout := wf_engine.eng_completed||':'||default_result;

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

9878: resultout := wf_engine.eng_waiting;
9879: elsif (default_result is not null) then
9880: -- Either timeout or all notifications closed
9881: -- Return default result if one found.
9882: resultout := wf_engine.eng_completed||':'||default_result;
9883:
9884: IF g_debug_flag THEN
9885: Write_Debug('Either timeout or all notifications closed. Return default result if one found ' );
9886: END IF ;

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

9892: IF g_debug_flag THEN
9893: Write_Debug('Timeout or all notifications closed, and no default. Return nomatch ' );
9894: END IF ;
9895:
9896: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;
9897: end if;
9898: end if;
9899: return;
9900:

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

10184: Write_Debug('Start PeopleLevelVoteForResultType...' );
10185: END IF ;
10186:
10187: -- Do nothing unless in RUN or TIMEOUT modes
10188: if (funcmode <> wf_engine.eng_run)
10189: and (funcmode <> wf_engine.eng_timeout) then
10190: resultout := wf_engine.eng_null;
10191: return;
10192: end if;

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

10185: END IF ;
10186:
10187: -- Do nothing unless in RUN or TIMEOUT modes
10188: if (funcmode <> wf_engine.eng_run)
10189: and (funcmode <> wf_engine.eng_timeout) then
10190: resultout := wf_engine.eng_null;
10191: return;
10192: end if;
10193:

Line 10190: resultout := wf_engine.eng_null;

10186:
10187: -- Do nothing unless in RUN or TIMEOUT modes
10188: if (funcmode <> wf_engine.eng_run)
10189: and (funcmode <> wf_engine.eng_timeout) then
10190: resultout := wf_engine.eng_null;
10191: return;
10192: end if;
10193:
10194: -- SYNCHMODE: Not allowed

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

10191: return;
10192: end if;
10193:
10194: -- SYNCHMODE: Not allowed
10195: if (itemkey = wf_engine.eng_synch) then
10196: Wf_Core.Token('OPERATION', 'Eng_Workflow_Util.PeopleLevelVoteForResultType');
10197: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
10198: end if;
10199:

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

10208: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
10209: l_group_id,l_user);
10210:
10211: -- Get Voting Option
10212: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10213: actid,'VOTING_OPTION');
10214:
10215: l_mandatory_result := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10216: actid,'MANDATORY', true);

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

10211: -- Get Voting Option
10212: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10213: actid,'VOTING_OPTION');
10214:
10215: l_mandatory_result := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10216: actid,'MANDATORY', true);
10217:
10218:
10219: IF g_debug_flag THEN

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

10290:
10291:
10292: -- If this is timeout mode, then use the percent of votes cast so far.
10293: -- If this is run mode, then use the percent of total votes possible.
10294: if (funcmode = wf_engine.eng_timeout) then
10295: l_per_code := l_per_of_vote;
10296: else
10297: l_per_code := l_per_of_total;
10298: end if;

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

10302: END IF ;
10303:
10304:
10305: -- Get percent vote needed for this result to succeed
10306: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,
10307: actid,result_rec.result_code);
10308:
10309:
10310: IF g_debug_flag THEN

Line 10328: default_result := wf_engine.eng_tie;

10324: max_default := l_code_count;
10325: default_result := result_rec.result_code;
10326: elsif (l_code_count = max_default) then
10327: -- Tie for default result.
10328: default_result := wf_engine.eng_tie;
10329: end if;
10330: else
10331:
10332: IF g_debug_flag THEN

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

10350: END IF ;
10351:
10352: else
10353: -- This is the second result to be satisfied. Return a tie.
10354: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;
10355:
10356: IF g_debug_flag THEN
10357: Write_Debug('This is the second result to be satisfied ' );
10358: END IF ;

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

10374: Write_Debug('Satisfied result IS NOT NULL ' );
10375: END IF ;
10376:
10377: -- Return the satisfied result code.
10378: resultout := wf_engine.eng_completed||':'||result;
10379: else
10380:
10381: IF g_debug_flag THEN
10382: Write_Debug('Satisfied result IS NULL ' );

Line 10387: if (funcmode = wf_engine.eng_run and

10383: END IF ;
10384:
10385:
10386: -- If we get here no non-default results were satisfied.
10387: if (funcmode = wf_engine.eng_run and
10388: wf_notification.OpenNotificationsExist(l_group_id)) then
10389: -- Not timed out and still open notifications.
10390: -- Return waiting to continue voting.
10391:

Line 10396: resultout := wf_engine.eng_waiting;

10392: IF g_debug_flag THEN
10393: Write_Debug('Not timed out and still open notifications. Return waiting to continue voting ' );
10394: END IF ;
10395:
10396: resultout := wf_engine.eng_waiting;
10397: elsif (default_result is not null) then
10398: -- Either timeout or all notifications closed
10399: -- Return default result if one found.
10400: resultout := wf_engine.eng_completed||':'||default_result;

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

10396: resultout := wf_engine.eng_waiting;
10397: elsif (default_result is not null) then
10398: -- Either timeout or all notifications closed
10399: -- Return default result if one found.
10400: resultout := wf_engine.eng_completed||':'||default_result;
10401:
10402: IF g_debug_flag THEN
10403: Write_Debug('Either timeout or all notifications closed. Return default result if one found ' );
10404: END IF ;

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

10410: IF g_debug_flag THEN
10411: Write_Debug('Timeout or all notifications closed, and no default. Return nomatch ' );
10412: END IF ;
10413:
10414: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;
10415: end if;
10416: end if;
10417: return;
10418:

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

10454: Write_Debug('-----------------------------------------------------');
10455: END IF ;
10456:
10457: -- Get Voting Option
10458: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
10459: actid,'VOTING_OPTION');
10460:
10461:
10462:

Line 10640: wf_engine.CompleteActivity

10636: IF g_debug_flag THEN
10637: Write_Debug('calling CompleteActivity . . . ');
10638: END IF ;
10639:
10640: wf_engine.CompleteActivity
10641: ( l_parent_itemtype
10642: , l_parent_itemkey
10643: , p_waiting_activity
10644: , wf_engine.eng_null );

Line 10644: , wf_engine.eng_null );

10640: wf_engine.CompleteActivity
10641: ( l_parent_itemtype
10642: , l_parent_itemkey
10643: , p_waiting_activity
10644: , wf_engine.eng_null );
10645:
10646: exception
10647: when others then
10648: --

Line 10654: x_resultout := wf_engine.eng_null;

10650: -- and wait for master flow
10651: --
10652: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
10653: wf_core.clear;
10654: x_resultout := wf_engine.eng_null;
10655: IF g_debug_flag THEN
10656: Write_Debug('call to CompleteActivity cannot find activity. . . ');
10657: END IF ;
10658: else

Line 10667: x_resultout := wf_engine.eng_null;

10663: END IF ;
10664:
10665: END IF ; -- parent item type and key are not null
10666:
10667: x_resultout := wf_engine.eng_null;
10668: return ;
10669:
10670: else
10671: -- p_waiting_flow is not APPROVAL

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

10723:
10724:
10725: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10726: THEN
10727: x_resultout := wf_engine.eng_notified ||':'||
10728: wf_engine.eng_null ||':'||
10729: wf_engine.eng_null;
10730: ELSE
10731: x_resultout := wf_engine.eng_null;

Line 10728: wf_engine.eng_null ||':'||

10724:
10725: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10726: THEN
10727: x_resultout := wf_engine.eng_notified ||':'||
10728: wf_engine.eng_null ||':'||
10729: wf_engine.eng_null;
10730: ELSE
10731: x_resultout := wf_engine.eng_null;
10732: END IF ;

Line 10729: wf_engine.eng_null;

10725: IF l_line_approval_status <> Eng_Workflow_Util.G_APPROVED
10726: THEN
10727: x_resultout := wf_engine.eng_notified ||':'||
10728: wf_engine.eng_null ||':'||
10729: wf_engine.eng_null;
10730: ELSE
10731: x_resultout := wf_engine.eng_null;
10732: END IF ;
10733:

Line 10731: x_resultout := wf_engine.eng_null;

10727: x_resultout := wf_engine.eng_notified ||':'||
10728: wf_engine.eng_null ||':'||
10729: wf_engine.eng_null;
10730: ELSE
10731: x_resultout := wf_engine.eng_null;
10732: END IF ;
10733:
10734: return ;
10735:

Line 10795: l_orig_user_id := wf_engine.GetItemAttrNumber

10791: END LOOP ;
10792:
10793:
10794: -- Get Original user_id and party_id who launched workflow
10795: l_orig_user_id := wf_engine.GetItemAttrNumber
10796: ( p_itemtype
10797: , p_itemkey
10798: , 'WF_USER_ID'
10799: );

Line 11980: WF_ENGINE.CreateProcess

11976: Write_Debug('2-2. Get Spcial API Caller: ' || l_api_caller );
11977: END IF ;
11978:
11979: -- Set Workflow Process Owner
11980: WF_ENGINE.CreateProcess
11981: ( itemtype => p_item_type
11982: , itemkey => x_item_key
11983: , process => p_process_name
11984: , user_key => l_wf_user_key

Line 12048: WF_ENGINE.SetItemParent

12044: AND p_item_type <> Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
12045: THEN
12046:
12047: -- Set Parent Worklfow Process
12048: WF_ENGINE.SetItemParent
12049: ( itemtype => p_item_type
12050: , itemkey => x_item_key
12051: , parent_itemtype => p_parent_item_type
12052: , parent_itemkey => p_parent_item_key

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

12415: AND x_item_key IS NOT NULL
12416: THEN
12417:
12418: IF g_debug_flag THEN
12419: Write_Debug('Calling WF_ENGINE.StartProcess . . .') ;
12420: END IF ;
12421:
12422:
12423: -- Start process

Line 12424: WF_ENGINE.StartProcess

12420: END IF ;
12421:
12422:
12423: -- Start process
12424: WF_ENGINE.StartProcess
12425: ( itemtype => p_item_type
12426: , itemkey => x_item_key);
12427:
12428: END IF ;

Line 13112: WF_ENGINE.CompleteActivity( p_item_type

13108: Write_Debug('6-2. Complete Abort Block Activity. . .' );
13109: END IF ;
13110:
13111:
13112: WF_ENGINE.CompleteActivity( p_item_type
13113: , p_item_key
13114: , Eng_Workflow_Util.G_BLOCK_ABORT_ACTIVITY
13115: , Eng_Workflow_Util.G_WF_COMPLETE
13116: );

Line 13126: WF_ENGINE.AbortProcess( p_item_type

13122: END IF ;
13123:
13124:
13125:
13126: WF_ENGINE.AbortProcess( p_item_type
13127: , p_Item_key
13128: , p_process_name
13129: );
13130:

Line 13405: l_comment := WF_ENGINE.context_user_comment;

13401: ) ;
13402:
13403:
13404: l_notification_id :=p_notification_id;
13405: l_comment := WF_ENGINE.context_user_comment;
13406:
13407:
13408: IF g_debug_flag THEN
13409: Write_Debug('Route Step id ' || to_char(l_step_id));

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

13408: IF g_debug_flag THEN
13409: Write_Debug('Route Step id ' || to_char(l_step_id));
13410: Write_Debug('Route p_item_type ' || p_item_type);
13411: Write_Debug('Route p_item_key ' || p_item_key);
13412: Write_Debug('Route new role ' || WF_ENGINE.context_new_role);
13413: Write_Debug('Change Id ' || to_char(l_change_id));
13414: END IF ;
13415:
13416: -- 14060173, wrap it in exception handler, and show msg,

Line 13421: WHERE user_name = WF_ENGINE.context_new_role;

13417: -- Cannot transfer notification to invalid role '&ROLE'
13418: begin
13419: SELECT person_id into l_new_party_id
13420: FROM ENG_SECURITY_PEOPLE_V
13421: WHERE user_name = WF_ENGINE.context_new_role;
13422: exception
13423: when no_data_found then
13424: IF g_debug_flag THEN
13425: Write_Debug('Transfer only supports users, new rols is invalid ');

Line 13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);

13427:
13428: x_return_status := FND_API.G_RET_STS_ERROR ;
13429: Wf_Core.context('Eng_Workflow_Util', 'reassignRoutePeople',
13430: p_item_type, p_item_key, p_notification_id, p_reassign_mode);
13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);
13432: Wf_Core.Raise('WFNTF_TRANSFER_FAIL');
13433: end;
13434: -- end 14060173
13435: