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

Line 3793: l_text_attr_name_tbl Wf_Engine.NameTabTyp;

3789: l_wf_process VARCHAR2(2000):= 'PA_MASS_PROCESS_APRVL_RESULT'; --Mass Assignment Approval process
3790: l_err_code NUMBER := 0;
3791: l_err_stage VARCHAR2(2000);
3792: l_err_stack VARCHAR2(2000);
3793: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3794: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3795: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3796: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3797: l_update_info_doc VARCHAR2(32767);

Line 3794: l_text_attr_value_tbl Wf_Engine.TextTabTyp;

3790: l_err_code NUMBER := 0;
3791: l_err_stage VARCHAR2(2000);
3792: l_err_stack VARCHAR2(2000);
3793: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3794: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3795: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3796: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3797: l_update_info_doc VARCHAR2(32767);
3798: l_note_to_approvers VARCHAR2(2000);

Line 3795: l_num_attr_name_tbl Wf_Engine.NameTabTyp;

3791: l_err_stage VARCHAR2(2000);
3792: l_err_stack VARCHAR2(2000);
3793: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3794: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3795: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3796: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3797: l_update_info_doc VARCHAR2(32767);
3798: l_note_to_approvers VARCHAR2(2000);
3799: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */

Line 3796: l_num_attr_value_tbl Wf_Engine.NumTabTyp;

3792: l_err_stack VARCHAR2(2000);
3793: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3794: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3795: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3796: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3797: l_update_info_doc VARCHAR2(32767);
3798: l_note_to_approvers VARCHAR2(2000);
3799: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */
3800:

Line 3855: l_save_threshold := wf_engine.threshold;

3851: , resp_id => l_responsibility_id
3852: , resp_appl_id => l_resp_appl_id );
3853:
3854: -- Setting thresold value to run the process in background
3855: l_save_threshold := wf_engine.threshold;
3856: wf_engine.threshold := -1;
3857:
3858: -- Create the WF process
3859: wf_engine.CreateProcess

Line 3856: wf_engine.threshold := -1;

3852: , resp_appl_id => l_resp_appl_id );
3853:
3854: -- Setting thresold value to run the process in background
3855: l_save_threshold := wf_engine.threshold;
3856: wf_engine.threshold := -1;
3857:
3858: -- Create the WF process
3859: wf_engine.CreateProcess
3860: ( ItemType => l_wf_item_type

Line 3859: wf_engine.CreateProcess

3855: l_save_threshold := wf_engine.threshold;
3856: wf_engine.threshold := -1;
3857:
3858: -- Create the WF process
3859: wf_engine.CreateProcess
3860: ( ItemType => l_wf_item_type
3861: , ItemKey => l_itemkey
3862: , process => l_wf_process );
3863:

Line 3898: wf_engine.SetItemAttrNumber

3894:
3895: -----------------------------------------------------------------
3896: --Set all the required workflow attributes and start the workflow
3897: -----------------------------------------------------------------
3898: wf_engine.SetItemAttrNumber
3899: ( itemtype => l_wf_item_type
3900: , itemkey => l_itemkey
3901: , aname => 'PROJECT_ID'
3902: , avalue => p_project_id );

Line 3904: wf_engine.SetItemAttrText

3900: , itemkey => l_itemkey
3901: , aname => 'PROJECT_ID'
3902: , avalue => p_project_id );
3903:
3904: wf_engine.SetItemAttrText
3905: ( itemtype => l_wf_item_type
3906: , itemkey => l_itemkey
3907: , aname => 'MODE'
3908: , avalue => p_mode );

Line 3911: wf_engine.AddItemAttrNumberArray

3907: , aname => 'MODE'
3908: , avalue => p_mode );
3909:
3910: --Setting Assignment Ids
3911: wf_engine.AddItemAttrNumberArray
3912: ( itemtype => l_wf_item_type
3913: , itemkey => l_itemkey
3914: , aname => l_num_attr_name_tbl
3915: , avalue => l_num_attr_value_tbl );

Line 3918: wf_engine.AddItemAttrTextArray

3914: , aname => l_num_attr_name_tbl
3915: , avalue => l_num_attr_value_tbl );
3916:
3917: --Setting Status table
3918: wf_engine.AddItemAttrTextArray
3919: ( itemtype => l_wf_item_type
3920: , itemkey => l_itemkey
3921: , aname => l_text_attr_name_tbl
3922: , avalue => l_text_attr_value_tbl );

Line 3924: wf_engine.SetItemAttrNumber

3920: , itemkey => l_itemkey
3921: , aname => l_text_attr_name_tbl
3922: , avalue => l_text_attr_value_tbl );
3923:
3924: wf_engine.SetItemAttrNumber
3925: ( itemtype => l_wf_item_type
3926: , itemkey => l_itemkey
3927: , aname => 'GROUP_ID'
3928: , avalue => p_group_id );

Line 3930: wf_engine.SetItemAttrNumber

3926: , itemkey => l_itemkey
3927: , aname => 'GROUP_ID'
3928: , avalue => p_group_id );
3929:
3930: wf_engine.SetItemAttrNumber
3931: ( itemtype => l_wf_item_type
3932: , itemkey => l_itemkey
3933: , aname => 'APPROVER_GROUP_ID'
3934: , avalue => p_approver_group_id );

Line 3936: wf_engine.SetItemAttrNumber

3932: , itemkey => l_itemkey
3933: , aname => 'APPROVER_GROUP_ID'
3934: , avalue => p_approver_group_id );
3935:
3936: wf_engine.SetItemAttrNumber
3937: ( itemtype => l_wf_item_type
3938: , itemkey => l_itemkey
3939: , aname => 'ROUTING_ORDER'
3940: , avalue => p_routing_order );

Line 3942: wf_engine.SetItemAttrNumber

3938: , itemkey => l_itemkey
3939: , aname => 'ROUTING_ORDER'
3940: , avalue => p_routing_order );
3941:
3942: wf_engine.SetItemAttrNumber
3943: ( itemtype => l_wf_item_type
3944: , itemkey => l_itemkey
3945: , aname => 'NUMBER_OF_ASSIGNMENTS'
3946: , avalue => p_assignment_id_tbl.COUNT );

Line 3949: l_update_info_doc := wf_engine.getItemAttrDocument

3945: , aname => 'NUMBER_OF_ASSIGNMENTS'
3946: , avalue => p_assignment_id_tbl.COUNT );
3947:
3948: --Get and set the Update info document
3949: l_update_info_doc := wf_engine.getItemAttrDocument
3950: ( itemtype => 'PAWFAAP'
3951: , itemkey => p_item_key
3952: , aname => 'UPDATED_INFO_DOC' );
3953:

Line 3954: wf_engine.SetItemAttrDocument

3950: ( itemtype => 'PAWFAAP'
3951: , itemkey => p_item_key
3952: , aname => 'UPDATED_INFO_DOC' );
3953:
3954: wf_engine.SetItemAttrDocument
3955: ( itemtype => l_wf_item_type
3956: , itemkey => l_itemkey
3957: , aname => 'UPDATED_INFO_DOC'
3958: , documentid => l_update_info_doc );

Line 3960: wf_engine.SetItemAttrText

3956: , itemkey => l_itemkey
3957: , aname => 'UPDATED_INFO_DOC'
3958: , documentid => l_update_info_doc );
3959:
3960: wf_engine.SetItemAttrText
3961: ( itemtype => l_wf_item_type
3962: , itemkey => l_itemkey
3963: , aname => 'SUBMITTER_UNAME'
3964: , avalue => p_submitter_user_name );

Line 3966: wf_engine.SetItemAttrNumber

3962: , itemkey => l_itemkey
3963: , aname => 'SUBMITTER_UNAME'
3964: , avalue => p_submitter_user_name );
3965:
3966: wf_engine.SetItemAttrNumber
3967: ( itemtype => l_wf_item_type
3968: , itemkey => l_itemkey
3969: , aname => 'CONFLICT_GROUP_ID'
3970: , avalue => p_conflict_group_id );

Line 3973: l_forwarded_from := wf_engine.getItemAttrText

3969: , aname => 'CONFLICT_GROUP_ID'
3970: , avalue => p_conflict_group_id );
3971:
3972: --Set the previous approver (forwarded from and note to approvers)
3973: l_forwarded_from := wf_engine.getItemAttrText
3974: ( itemtype => 'PAWFAAP'
3975: , itemkey => p_item_key
3976: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
3977:

Line 3978: l_note_to_approvers := wf_engine.getItemAttrText

3974: ( itemtype => 'PAWFAAP'
3975: , itemkey => p_item_key
3976: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
3977:
3978: l_note_to_approvers := wf_engine.getItemAttrText
3979: ( itemtype => 'PAWFAAP'
3980: , itemkey => p_item_key
3981: , aname => 'NOTE_TO_APPROVER');
3982:

Line 3983: wf_engine.SetItemAttrText

3979: ( itemtype => 'PAWFAAP'
3980: , itemkey => p_item_key
3981: , aname => 'NOTE_TO_APPROVER');
3982:
3983: wf_engine.SetItemAttrText
3984: ( itemtype => l_wf_item_type
3985: , itemkey => l_itemkey
3986: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
3987: , avalue => l_forwarded_from );

Line 3989: wf_engine.SetItemAttrText

3985: , itemkey => l_itemkey
3986: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
3987: , avalue => l_forwarded_from );
3988:
3989: wf_engine.SetItemAttrText
3990: ( itemtype => l_wf_item_type
3991: , itemkey => l_itemkey
3992: , aname => 'NOTE_TO_APPROVER'
3993: , avalue => l_note_to_approvers );

Line 3998: wf_engine.StartProcess ( itemtype => l_wf_item_type

3994:
3995: -------------------------------
3996: --Start the workflow process
3997: -------------------------------
3998: wf_engine.StartProcess ( itemtype => l_wf_item_type
3999: ,itemkey => l_itemkey );
4000:
4001: PA_WORKFLOW_UTILS.Insert_WF_Processes
4002: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'

Line 4013: wf_engine.threshold := l_save_threshold;

4009: ,p_err_stage => l_err_stage
4010: ,p_err_stack => l_err_stack );
4011:
4012: --Setting the original value
4013: wf_engine.threshold := l_save_threshold;
4014:
4015: log_message('Exiting mass_process_approval_result');
4016:
4017: EXCEPTION

Line 4025: wf_engine.threshold := l_save_threshold;

4021: ROLLBACK TO MASS_APPRVL_RESULT;
4022: END IF;
4023:
4024: --Setting the original value
4025: wf_engine.threshold := l_save_threshold;
4026:
4027: -- Set the excetption Message and the stack
4028: FND_MSG_PUB.add_exc_msg
4029: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'