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.PO_REQCHANGEREQUESTWF_PVT dependencies on WF_ITEMS

Line 4019: l_parent_item_type wf_items.item_type%type;

4015: x_progress varchar2(100);
4016:
4017: l_doc_string varchar2(200);
4018: l_preparer_user_name varchar2(100);
4019: l_parent_item_type wf_items.item_type%type;
4020: l_parent_item_key wf_items.item_key%type;
4021: l_forward_from_username varchar2(200);
4022: l_user_id number;
4023: l_application_id number;

Line 4020: l_parent_item_key wf_items.item_key%type;

4016:
4017: l_doc_string varchar2(200);
4018: l_preparer_user_name varchar2(100);
4019: l_parent_item_type wf_items.item_type%type;
4020: l_parent_item_key wf_items.item_key%type;
4021: l_forward_from_username varchar2(200);
4022: l_user_id number;
4023: l_application_id number;
4024: l_responsibility_id number;

Line 4092: item_key wf_items.item_key%type;

4088: ************************************************************************/
4089: procedure StartConvertProcess(p_change_request_group_id in number,
4090: p_old_item_key in varchar2) is
4091: l_count number;
4092: item_key wf_items.item_key%type;
4093: item_type wf_items.item_type%type:='POREQCHA';
4094: l_document_id number;
4095: l_document_number po_change_requests.document_num%type;
4096: l_org_id number;

Line 4093: item_type wf_items.item_type%type:='POREQCHA';

4089: procedure StartConvertProcess(p_change_request_group_id in number,
4090: p_old_item_key in varchar2) is
4091: l_count number;
4092: item_key wf_items.item_key%type;
4093: item_type wf_items.item_type%type:='POREQCHA';
4094: l_document_id number;
4095: l_document_number po_change_requests.document_num%type;
4096: l_org_id number;
4097: l_requester_id number;

Line 4274: l_parent_item_type wf_items.item_type%type;

4270: l_preparer_id number;
4271: l_preparer_username varchar2(100);
4272: l_preparer_display_name varchar2(300);
4273: l_parent_group_id number;
4274: l_parent_item_type wf_items.item_type%type;
4275: l_parent_item_key wf_items.item_key%type;
4276: l_forward_from_username varchar2(100);
4277:
4278: l_document_num varchar2(20);

Line 4275: l_parent_item_key wf_items.item_key%type;

4271: l_preparer_username varchar2(100);
4272: l_preparer_display_name varchar2(300);
4273: l_parent_group_id number;
4274: l_parent_item_type wf_items.item_type%type;
4275: l_parent_item_key wf_items.item_key%type;
4276: l_forward_from_username varchar2(100);
4277:
4278: l_document_num varchar2(20);
4279: l_requisition_num varchar2(20);

Line 7669: l_req_item_key wf_items.item_key%type;

7665: IS
7666:
7667: l_document_id NUMBER;
7668: l_orgid NUMBER;
7669: l_req_item_key wf_items.item_key%type;
7670: l_req_item_type wf_items.item_type%type;
7671: x_progress varchar2(100);
7672: l_functional_currency varchar2(200);
7673: l_total_amount_dsp varchar2(100);

Line 7670: l_req_item_type wf_items.item_type%type;

7666:
7667: l_document_id NUMBER;
7668: l_orgid NUMBER;
7669: l_req_item_key wf_items.item_key%type;
7670: l_req_item_type wf_items.item_type%type;
7671: x_progress varchar2(100);
7672: l_functional_currency varchar2(200);
7673: l_total_amount_dsp varchar2(100);
7674: t_varname Wf_Engine.NameTabTyp;

Line 7739: from wf_items

7735: -- here we check the availability of POREQCHA wf.
7736: BEGIN
7737: select 'Y'
7738: into l_rco_wf_available
7739: from wf_items
7740: where item_type = l_req_item_type
7741: and item_key = l_req_item_key;
7742:
7743: EXCEPTION

Line 8140: l_po_chg_itemtype wf_items.item_type%type;

8136: x_progress varchar2(3) := '000';
8137: l_requester_id number;
8138: l_requester_name wf_roles.name%type;
8139: l_requester_display_name wf_roles.display_name%type;
8140: l_po_chg_itemtype wf_items.item_type%type;
8141: l_po_chg_itemkey wf_items.item_key%type;
8142:
8143: cursor l_get_group_id_po_csr is
8144: select change_request_group_id, wf_item_type, wf_item_key

Line 8141: l_po_chg_itemkey wf_items.item_key%type;

8137: l_requester_id number;
8138: l_requester_name wf_roles.name%type;
8139: l_requester_display_name wf_roles.display_name%type;
8140: l_po_chg_itemtype wf_items.item_type%type;
8141: l_po_chg_itemkey wf_items.item_key%type;
8142:
8143: cursor l_get_group_id_po_csr is
8144: select change_request_group_id, wf_item_type, wf_item_key
8145: from po_change_requests

Line 8669: l_wf_item_type wf_items.item_type%TYPE;

8665: l_change_request_id number;
8666: l_action_type PO_CHANGE_REQUESTS.ACTION_TYPE%TYPE;
8667: l_change_request_group_id number;
8668:
8669: l_wf_item_type wf_items.item_type%TYPE;
8670: l_wf_item_key wf_items.item_key%type;
8671:
8672: l_result BOOLEAN:=FALSE;
8673: l_action VARCHAR2(30) := 'RETURN';

Line 8670: l_wf_item_key wf_items.item_key%type;

8666: l_action_type PO_CHANGE_REQUESTS.ACTION_TYPE%TYPE;
8667: l_change_request_group_id number;
8668:
8669: l_wf_item_type wf_items.item_type%TYPE;
8670: l_wf_item_key wf_items.item_key%type;
8671:
8672: l_result BOOLEAN:=FALSE;
8673: l_action VARCHAR2(30) := 'RETURN';
8674: l_document_id NUMBER;

Line 8846: p_item_key wf_items.item_key%type;

8842:
8843: p_document_type VARCHAR2(20) := 'REQUISITION';
8844: p_document_subtype VARCHAR2(20) := 'PURCHASE';
8845: p_interface_source_code VARCHAR2(20):= 'POR';
8846: p_item_key wf_items.item_key%type;
8847: p_item_type wf_items.item_type%type:='POREQCHA';
8848: p_submitter_action VARCHAR2(20) := 'APPROVE';
8849: p_workflow_process VARCHAR2(30):='MAIN_CHANGE_APPROVAL';
8850: l_change_request_group_id number;

Line 8847: p_item_type wf_items.item_type%type:='POREQCHA';

8843: p_document_type VARCHAR2(20) := 'REQUISITION';
8844: p_document_subtype VARCHAR2(20) := 'PURCHASE';
8845: p_interface_source_code VARCHAR2(20):= 'POR';
8846: p_item_key wf_items.item_key%type;
8847: p_item_type wf_items.item_type%type:='POREQCHA';
8848: p_submitter_action VARCHAR2(20) := 'APPROVE';
8849: p_workflow_process VARCHAR2(30):='MAIN_CHANGE_APPROVAL';
8850: l_change_request_group_id number;
8851: l_preparer_id number;

Line 8936: l_parent_item_type wf_items.item_type%type;

8932: x_progress varchar2(3):= '000';
8933: l_count number;
8934: item_key varchar2(240);
8935: item_type varchar2(8):='PORPOCHA';
8936: l_parent_item_type wf_items.item_type%type;
8937: l_parent_item_key wf_items.item_key%type;
8938: l_forward_from_username varchar2(200);
8939: l_user_id number;
8940: l_application_id number;

Line 8937: l_parent_item_key wf_items.item_key%type;

8933: l_count number;
8934: item_key varchar2(240);
8935: item_type varchar2(8):='PORPOCHA';
8936: l_parent_item_type wf_items.item_type%type;
8937: l_parent_item_key wf_items.item_key%type;
8938: l_forward_from_username varchar2(200);
8939: l_user_id number;
8940: l_application_id number;
8941: l_responsibility_id number;

Line 8988: l_item_type wf_items.item_type%type;

8984: p_acceptance_flag in varchar2,
8985: p_responded_by in number,
8986: p_response_reason in varchar2) is
8987:
8988: l_item_type wf_items.item_type%type;
8989: l_item_key wf_items.item_key%type;
8990: l_api_name CONSTANT VARCHAR2(30) := 'Record_Buyer_Response';
8991: l_api_version CONSTANT NUMBER := 1.0;
8992:

Line 8989: l_item_key wf_items.item_key%type;

8985: p_responded_by in number,
8986: p_response_reason in varchar2) is
8987:
8988: l_item_type wf_items.item_type%type;
8989: l_item_key wf_items.item_key%type;
8990: l_api_name CONSTANT VARCHAR2(30) := 'Record_Buyer_Response';
8991: l_api_version CONSTANT NUMBER := 1.0;
8992:
8993: l_notif_status wf_notifications.status%type;

Line 9076: l_parent_item_type wf_items.item_type%type;

9072: x_progress varchar2(3):= '000';
9073: l_count number;
9074: item_key varchar2(240);
9075: item_type varchar2(8):='PORPOCHA';
9076: l_parent_item_type wf_items.item_type%type;
9077: l_parent_item_key wf_items.item_key%type;
9078: l_forward_from_username varchar2(200);
9079: l_user_id number;
9080: l_application_id number;

Line 9077: l_parent_item_key wf_items.item_key%type;

9073: l_count number;
9074: item_key varchar2(240);
9075: item_type varchar2(8):='PORPOCHA';
9076: l_parent_item_type wf_items.item_type%type;
9077: l_parent_item_key wf_items.item_key%type;
9078: l_forward_from_username varchar2(200);
9079: l_user_id number;
9080: l_application_id number;
9081: l_responsibility_id number;

Line 9138: from wf_items

9134: -- we get the attributes through fnd_global instead
9135: BEGIN
9136: select 'Y'
9137: into l_parent_wf_available
9138: from wf_items
9139: where item_type = l_parent_item_type
9140: and item_key = l_parent_item_key;
9141:
9142: EXCEPTION

Line 11405: p_item_key wf_items.item_key%TYPE;

11401:
11402: p_document_type VARCHAR2(20) := 'REQUISITION';
11403: p_document_subtype VARCHAR2(20) := '';
11404: p_interface_source_code VARCHAR2(20) := 'POR';
11405: p_item_key wf_items.item_key%TYPE;
11406: p_item_type wf_items.item_type%TYPE := 'POREQCHA';
11407: p_submitter_action VARCHAR2(20) := 'APPROVE';
11408: p_workflow_process VARCHAR2(30) := 'MAIN_CHANGE_APPROVAL';
11409: l_change_request_group_id NUMBER;

Line 11406: p_item_type wf_items.item_type%TYPE := 'POREQCHA';

11402: p_document_type VARCHAR2(20) := 'REQUISITION';
11403: p_document_subtype VARCHAR2(20) := '';
11404: p_interface_source_code VARCHAR2(20) := 'POR';
11405: p_item_key wf_items.item_key%TYPE;
11406: p_item_type wf_items.item_type%TYPE := 'POREQCHA';
11407: p_submitter_action VARCHAR2(20) := 'APPROVE';
11408: p_workflow_process VARCHAR2(30) := 'MAIN_CHANGE_APPROVAL';
11409: l_change_request_group_id NUMBER;
11410: l_preparer_id NUMBER;