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 3858: l_text_attr_name_tbl Wf_Engine.NameTabTyp;

3854: l_wf_process VARCHAR2(2000):= 'PA_MASS_PROCESS_APRVL_RESULT'; --Mass Assignment Approval process
3855: l_err_code NUMBER := 0;
3856: l_err_stage VARCHAR2(2000);
3857: l_err_stack VARCHAR2(2000);
3858: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3859: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3860: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3861: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3862: l_update_info_doc VARCHAR2(32767);

Line 3859: l_text_attr_value_tbl Wf_Engine.TextTabTyp;

3855: l_err_code NUMBER := 0;
3856: l_err_stage VARCHAR2(2000);
3857: l_err_stack VARCHAR2(2000);
3858: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3859: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3860: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3861: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3862: l_update_info_doc VARCHAR2(32767);
3863: l_note_to_approvers VARCHAR2(2000);

Line 3860: l_num_attr_name_tbl Wf_Engine.NameTabTyp;

3856: l_err_stage VARCHAR2(2000);
3857: l_err_stack VARCHAR2(2000);
3858: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3859: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3860: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3861: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3862: l_update_info_doc VARCHAR2(32767);
3863: l_note_to_approvers VARCHAR2(2000);
3864: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */

Line 3861: l_num_attr_value_tbl Wf_Engine.NumTabTyp;

3857: l_err_stack VARCHAR2(2000);
3858: l_text_attr_name_tbl Wf_Engine.NameTabTyp;
3859: l_text_attr_value_tbl Wf_Engine.TextTabTyp;
3860: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3861: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3862: l_update_info_doc VARCHAR2(32767);
3863: l_note_to_approvers VARCHAR2(2000);
3864: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */
3865:

Line 3920: l_save_threshold := wf_engine.threshold;

3916: , resp_id => l_responsibility_id
3917: , resp_appl_id => l_resp_appl_id );
3918:
3919: -- Setting thresold value to run the process in background
3920: l_save_threshold := wf_engine.threshold;
3921: wf_engine.threshold := -1;
3922:
3923: -- Create the WF process
3924: wf_engine.CreateProcess

Line 3921: wf_engine.threshold := -1;

3917: , resp_appl_id => l_resp_appl_id );
3918:
3919: -- Setting thresold value to run the process in background
3920: l_save_threshold := wf_engine.threshold;
3921: wf_engine.threshold := -1;
3922:
3923: -- Create the WF process
3924: wf_engine.CreateProcess
3925: ( ItemType => l_wf_item_type

Line 3924: wf_engine.CreateProcess

3920: l_save_threshold := wf_engine.threshold;
3921: wf_engine.threshold := -1;
3922:
3923: -- Create the WF process
3924: wf_engine.CreateProcess
3925: ( ItemType => l_wf_item_type
3926: , ItemKey => l_itemkey
3927: , process => l_wf_process );
3928:

Line 3963: wf_engine.SetItemAttrNumber

3959:
3960: -----------------------------------------------------------------
3961: --Set all the required workflow attributes and start the workflow
3962: -----------------------------------------------------------------
3963: wf_engine.SetItemAttrNumber
3964: ( itemtype => l_wf_item_type
3965: , itemkey => l_itemkey
3966: , aname => 'PROJECT_ID'
3967: , avalue => p_project_id );

Line 3969: wf_engine.SetItemAttrText

3965: , itemkey => l_itemkey
3966: , aname => 'PROJECT_ID'
3967: , avalue => p_project_id );
3968:
3969: wf_engine.SetItemAttrText
3970: ( itemtype => l_wf_item_type
3971: , itemkey => l_itemkey
3972: , aname => 'MODE'
3973: , avalue => p_mode );

Line 3976: wf_engine.AddItemAttrNumberArray

3972: , aname => 'MODE'
3973: , avalue => p_mode );
3974:
3975: --Setting Assignment Ids
3976: wf_engine.AddItemAttrNumberArray
3977: ( itemtype => l_wf_item_type
3978: , itemkey => l_itemkey
3979: , aname => l_num_attr_name_tbl
3980: , avalue => l_num_attr_value_tbl );

Line 3983: wf_engine.AddItemAttrTextArray

3979: , aname => l_num_attr_name_tbl
3980: , avalue => l_num_attr_value_tbl );
3981:
3982: --Setting Status table
3983: wf_engine.AddItemAttrTextArray
3984: ( itemtype => l_wf_item_type
3985: , itemkey => l_itemkey
3986: , aname => l_text_attr_name_tbl
3987: , avalue => l_text_attr_value_tbl );

Line 3989: wf_engine.SetItemAttrNumber

3985: , itemkey => l_itemkey
3986: , aname => l_text_attr_name_tbl
3987: , avalue => l_text_attr_value_tbl );
3988:
3989: wf_engine.SetItemAttrNumber
3990: ( itemtype => l_wf_item_type
3991: , itemkey => l_itemkey
3992: , aname => 'GROUP_ID'
3993: , avalue => p_group_id );

Line 3995: wf_engine.SetItemAttrNumber

3991: , itemkey => l_itemkey
3992: , aname => 'GROUP_ID'
3993: , avalue => p_group_id );
3994:
3995: wf_engine.SetItemAttrNumber
3996: ( itemtype => l_wf_item_type
3997: , itemkey => l_itemkey
3998: , aname => 'APPROVER_GROUP_ID'
3999: , avalue => p_approver_group_id );

Line 4001: wf_engine.SetItemAttrNumber

3997: , itemkey => l_itemkey
3998: , aname => 'APPROVER_GROUP_ID'
3999: , avalue => p_approver_group_id );
4000:
4001: wf_engine.SetItemAttrNumber
4002: ( itemtype => l_wf_item_type
4003: , itemkey => l_itemkey
4004: , aname => 'ROUTING_ORDER'
4005: , avalue => p_routing_order );

Line 4007: wf_engine.SetItemAttrNumber

4003: , itemkey => l_itemkey
4004: , aname => 'ROUTING_ORDER'
4005: , avalue => p_routing_order );
4006:
4007: wf_engine.SetItemAttrNumber
4008: ( itemtype => l_wf_item_type
4009: , itemkey => l_itemkey
4010: , aname => 'NUMBER_OF_ASSIGNMENTS'
4011: , avalue => p_assignment_id_tbl.COUNT );

Line 4014: l_update_info_doc := wf_engine.getItemAttrDocument

4010: , aname => 'NUMBER_OF_ASSIGNMENTS'
4011: , avalue => p_assignment_id_tbl.COUNT );
4012:
4013: --Get and set the Update info document
4014: l_update_info_doc := wf_engine.getItemAttrDocument
4015: ( itemtype => 'PAWFAAP'
4016: , itemkey => p_item_key
4017: , aname => 'UPDATED_INFO_DOC' );
4018:

Line 4019: wf_engine.SetItemAttrDocument

4015: ( itemtype => 'PAWFAAP'
4016: , itemkey => p_item_key
4017: , aname => 'UPDATED_INFO_DOC' );
4018:
4019: wf_engine.SetItemAttrDocument
4020: ( itemtype => l_wf_item_type
4021: , itemkey => l_itemkey
4022: , aname => 'UPDATED_INFO_DOC'
4023: , documentid => l_update_info_doc );

Line 4025: wf_engine.SetItemAttrText

4021: , itemkey => l_itemkey
4022: , aname => 'UPDATED_INFO_DOC'
4023: , documentid => l_update_info_doc );
4024:
4025: wf_engine.SetItemAttrText
4026: ( itemtype => l_wf_item_type
4027: , itemkey => l_itemkey
4028: , aname => 'SUBMITTER_UNAME'
4029: , avalue => p_submitter_user_name );

Line 4031: wf_engine.SetItemAttrNumber

4027: , itemkey => l_itemkey
4028: , aname => 'SUBMITTER_UNAME'
4029: , avalue => p_submitter_user_name );
4030:
4031: wf_engine.SetItemAttrNumber
4032: ( itemtype => l_wf_item_type
4033: , itemkey => l_itemkey
4034: , aname => 'CONFLICT_GROUP_ID'
4035: , avalue => p_conflict_group_id );

Line 4038: l_forwarded_from := wf_engine.getItemAttrText

4034: , aname => 'CONFLICT_GROUP_ID'
4035: , avalue => p_conflict_group_id );
4036:
4037: --Set the previous approver (forwarded from and note to approvers)
4038: l_forwarded_from := wf_engine.getItemAttrText
4039: ( itemtype => 'PAWFAAP'
4040: , itemkey => p_item_key
4041: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
4042:

Line 4043: l_note_to_approvers := wf_engine.getItemAttrText

4039: ( itemtype => 'PAWFAAP'
4040: , itemkey => p_item_key
4041: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
4042:
4043: l_note_to_approvers := wf_engine.getItemAttrText
4044: ( itemtype => 'PAWFAAP'
4045: , itemkey => p_item_key
4046: , aname => 'NOTE_TO_APPROVER');
4047:

Line 4048: wf_engine.SetItemAttrText

4044: ( itemtype => 'PAWFAAP'
4045: , itemkey => p_item_key
4046: , aname => 'NOTE_TO_APPROVER');
4047:
4048: wf_engine.SetItemAttrText
4049: ( itemtype => l_wf_item_type
4050: , itemkey => l_itemkey
4051: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
4052: , avalue => l_forwarded_from );

Line 4054: wf_engine.SetItemAttrText

4050: , itemkey => l_itemkey
4051: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
4052: , avalue => l_forwarded_from );
4053:
4054: wf_engine.SetItemAttrText
4055: ( itemtype => l_wf_item_type
4056: , itemkey => l_itemkey
4057: , aname => 'NOTE_TO_APPROVER'
4058: , avalue => l_note_to_approvers );

Line 4063: wf_engine.StartProcess ( itemtype => l_wf_item_type

4059:
4060: -------------------------------
4061: --Start the workflow process
4062: -------------------------------
4063: wf_engine.StartProcess ( itemtype => l_wf_item_type
4064: ,itemkey => l_itemkey );
4065:
4066: PA_WORKFLOW_UTILS.Insert_WF_Processes
4067: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'

Line 4078: wf_engine.threshold := l_save_threshold;

4074: ,p_err_stage => l_err_stage
4075: ,p_err_stack => l_err_stack );
4076:
4077: --Setting the original value
4078: wf_engine.threshold := l_save_threshold;
4079:
4080: log_message('Exiting mass_process_approval_result');
4081:
4082: EXCEPTION

Line 4090: wf_engine.threshold := l_save_threshold;

4086: ROLLBACK TO MASS_APPRVL_RESULT;
4087: END IF;
4088:
4089: --Setting the original value
4090: wf_engine.threshold := l_save_threshold;
4091:
4092: -- Set the excetption Message and the stack
4093: FND_MSG_PUB.add_exc_msg
4094: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'