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 4172: l_parent_item_type wf_items.item_type%type;

4168: x_progress varchar2(100);
4169:
4170: l_doc_string varchar2(200);
4171: l_preparer_user_name varchar2(100);
4172: l_parent_item_type wf_items.item_type%type;
4173: l_parent_item_key wf_items.item_key%type;
4174: l_forward_from_username varchar2(200);
4175: l_user_id number;
4176: l_application_id number;

Line 4173: l_parent_item_key wf_items.item_key%type;

4169:
4170: l_doc_string varchar2(200);
4171: l_preparer_user_name varchar2(100);
4172: l_parent_item_type wf_items.item_type%type;
4173: l_parent_item_key wf_items.item_key%type;
4174: l_forward_from_username varchar2(200);
4175: l_user_id number;
4176: l_application_id number;
4177: l_responsibility_id number;

Line 4245: item_key wf_items.item_key%type;

4241: ************************************************************************/
4242: procedure StartConvertProcess(p_change_request_group_id in number,
4243: p_old_item_key in varchar2) is
4244: l_count number;
4245: item_key wf_items.item_key%type;
4246: item_type wf_items.item_type%type:='POREQCHA';
4247: l_document_id number;
4248: l_document_number po_change_requests.document_num%type;
4249: l_org_id number;

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

4242: procedure StartConvertProcess(p_change_request_group_id in number,
4243: p_old_item_key in varchar2) is
4244: l_count number;
4245: item_key wf_items.item_key%type;
4246: item_type wf_items.item_type%type:='POREQCHA';
4247: l_document_id number;
4248: l_document_number po_change_requests.document_num%type;
4249: l_org_id number;
4250: l_requester_id number;

Line 4427: l_parent_item_type wf_items.item_type%type;

4423: l_preparer_id number;
4424: l_preparer_username varchar2(100);
4425: l_preparer_display_name varchar2(300);
4426: l_parent_group_id number;
4427: l_parent_item_type wf_items.item_type%type;
4428: l_parent_item_key wf_items.item_key%type;
4429: l_forward_from_username varchar2(100);
4430:
4431: l_document_num varchar2(20);

Line 4428: l_parent_item_key wf_items.item_key%type;

4424: l_preparer_username varchar2(100);
4425: l_preparer_display_name varchar2(300);
4426: l_parent_group_id number;
4427: l_parent_item_type wf_items.item_type%type;
4428: l_parent_item_key wf_items.item_key%type;
4429: l_forward_from_username varchar2(100);
4430:
4431: l_document_num varchar2(20);
4432: l_requisition_num varchar2(20);

Line 7906: l_req_item_key wf_items.item_key%type;

7902: IS
7903:
7904: l_document_id NUMBER;
7905: l_orgid NUMBER;
7906: l_req_item_key wf_items.item_key%type;
7907: l_req_item_type wf_items.item_type%type;
7908: x_progress varchar2(100);
7909: l_functional_currency varchar2(200);
7910: l_total_amount_dsp varchar2(100);

Line 7907: l_req_item_type wf_items.item_type%type;

7903:
7904: l_document_id NUMBER;
7905: l_orgid NUMBER;
7906: l_req_item_key wf_items.item_key%type;
7907: l_req_item_type wf_items.item_type%type;
7908: x_progress varchar2(100);
7909: l_functional_currency varchar2(200);
7910: l_total_amount_dsp varchar2(100);
7911: t_varname Wf_Engine.NameTabTyp;

Line 7983: from wf_items

7979: -- here we check the availability of POREQCHA wf.
7980: BEGIN
7981: select 'Y'
7982: into l_rco_wf_available
7983: from wf_items
7984: where item_type = l_req_item_type
7985: and item_key = l_req_item_key;
7986:
7987: EXCEPTION

Line 8452: l_po_chg_itemtype wf_items.item_type%type;

8448: x_progress varchar2(3) := '000';
8449: l_requester_id number;
8450: l_requester_name wf_roles.name%type;
8451: l_requester_display_name wf_roles.display_name%type;
8452: l_po_chg_itemtype wf_items.item_type%type;
8453: l_po_chg_itemkey wf_items.item_key%type;
8454: l_org_id number;
8455: l_buyer_id number;
8456: l_buyer_name varchar2(100);

Line 8453: l_po_chg_itemkey wf_items.item_key%type;

8449: l_requester_id number;
8450: l_requester_name wf_roles.name%type;
8451: l_requester_display_name wf_roles.display_name%type;
8452: l_po_chg_itemtype wf_items.item_type%type;
8453: l_po_chg_itemkey wf_items.item_key%type;
8454: l_org_id number;
8455: l_buyer_id number;
8456: l_buyer_name varchar2(100);
8457: l_buyer_display_name varchar2(300);

Line 9056: l_wf_item_type wf_items.item_type%TYPE;

9052: l_change_request_id number;
9053: l_action_type PO_CHANGE_REQUESTS.ACTION_TYPE%TYPE;
9054: l_change_request_group_id number;
9055:
9056: l_wf_item_type wf_items.item_type%TYPE;
9057: l_wf_item_key wf_items.item_key%type;
9058:
9059: l_result BOOLEAN:=FALSE;
9060: l_action VARCHAR2(30) := 'RETURN';

Line 9057: l_wf_item_key wf_items.item_key%type;

9053: l_action_type PO_CHANGE_REQUESTS.ACTION_TYPE%TYPE;
9054: l_change_request_group_id number;
9055:
9056: l_wf_item_type wf_items.item_type%TYPE;
9057: l_wf_item_key wf_items.item_key%type;
9058:
9059: l_result BOOLEAN:=FALSE;
9060: l_action VARCHAR2(30) := 'RETURN';
9061: l_document_id NUMBER;

Line 9233: p_item_key wf_items.item_key%type;

9229:
9230: p_document_type VARCHAR2(20) := 'REQUISITION';
9231: p_document_subtype VARCHAR2(20) := 'PURCHASE';
9232: p_interface_source_code VARCHAR2(20):= 'POR';
9233: p_item_key wf_items.item_key%type;
9234: p_item_type wf_items.item_type%type:='POREQCHA';
9235: p_submitter_action VARCHAR2(20) := 'APPROVE';
9236: p_workflow_process VARCHAR2(30):='MAIN_CHANGE_APPROVAL';
9237: l_change_request_group_id number;

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

9230: p_document_type VARCHAR2(20) := 'REQUISITION';
9231: p_document_subtype VARCHAR2(20) := 'PURCHASE';
9232: p_interface_source_code VARCHAR2(20):= 'POR';
9233: p_item_key wf_items.item_key%type;
9234: p_item_type wf_items.item_type%type:='POREQCHA';
9235: p_submitter_action VARCHAR2(20) := 'APPROVE';
9236: p_workflow_process VARCHAR2(30):='MAIN_CHANGE_APPROVAL';
9237: l_change_request_group_id number;
9238: l_preparer_id number;

Line 9323: l_parent_item_type wf_items.item_type%type;

9319: x_progress varchar2(3):= '000';
9320: l_count number;
9321: item_key varchar2(240);
9322: item_type varchar2(8):='PORPOCHA';
9323: l_parent_item_type wf_items.item_type%type;
9324: l_parent_item_key wf_items.item_key%type;
9325: l_forward_from_username varchar2(200);
9326: l_user_id number;
9327: l_application_id number;

Line 9324: l_parent_item_key wf_items.item_key%type;

9320: l_count number;
9321: item_key varchar2(240);
9322: item_type varchar2(8):='PORPOCHA';
9323: l_parent_item_type wf_items.item_type%type;
9324: l_parent_item_key wf_items.item_key%type;
9325: l_forward_from_username varchar2(200);
9326: l_user_id number;
9327: l_application_id number;
9328: l_responsibility_id number;

Line 9375: l_item_type wf_items.item_type%type;

9371: p_acceptance_flag in varchar2,
9372: p_responded_by in number,
9373: p_response_reason in varchar2) is
9374:
9375: l_item_type wf_items.item_type%type;
9376: l_item_key wf_items.item_key%type;
9377: l_api_name CONSTANT VARCHAR2(30) := 'Record_Buyer_Response';
9378: l_api_version CONSTANT NUMBER := 1.0;
9379:

Line 9376: l_item_key wf_items.item_key%type;

9372: p_responded_by in number,
9373: p_response_reason in varchar2) is
9374:
9375: l_item_type wf_items.item_type%type;
9376: l_item_key wf_items.item_key%type;
9377: l_api_name CONSTANT VARCHAR2(30) := 'Record_Buyer_Response';
9378: l_api_version CONSTANT NUMBER := 1.0;
9379:
9380: l_notif_status wf_notifications.status%type;

Line 9463: l_parent_item_type wf_items.item_type%type;

9459: x_progress varchar2(3):= '000';
9460: l_count number;
9461: item_key varchar2(240);
9462: item_type varchar2(8):='PORPOCHA';
9463: l_parent_item_type wf_items.item_type%type;
9464: l_parent_item_key wf_items.item_key%type;
9465: l_forward_from_username varchar2(200);
9466: l_user_id number;
9467: l_application_id number;

Line 9464: l_parent_item_key wf_items.item_key%type;

9460: l_count number;
9461: item_key varchar2(240);
9462: item_type varchar2(8):='PORPOCHA';
9463: l_parent_item_type wf_items.item_type%type;
9464: l_parent_item_key wf_items.item_key%type;
9465: l_forward_from_username varchar2(200);
9466: l_user_id number;
9467: l_application_id number;
9468: l_responsibility_id number;

Line 9525: from wf_items

9521: -- we get the attributes through fnd_global instead
9522: BEGIN
9523: select 'Y'
9524: into l_parent_wf_available
9525: from wf_items
9526: where item_type = l_parent_item_type
9527: and item_key = l_parent_item_key;
9528:
9529: EXCEPTION

Line 11809: p_item_key wf_items.item_key%TYPE;

11805:
11806: p_document_type VARCHAR2(20) := 'REQUISITION';
11807: p_document_subtype VARCHAR2(20) := '';
11808: p_interface_source_code VARCHAR2(20) := 'POR';
11809: p_item_key wf_items.item_key%TYPE;
11810: p_item_type wf_items.item_type%TYPE := 'POREQCHA';
11811: p_submitter_action VARCHAR2(20) := 'APPROVE';
11812: p_workflow_process VARCHAR2(30) := 'MAIN_CHANGE_APPROVAL';
11813: l_change_request_group_id NUMBER;

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

11806: p_document_type VARCHAR2(20) := 'REQUISITION';
11807: p_document_subtype VARCHAR2(20) := '';
11808: p_interface_source_code VARCHAR2(20) := 'POR';
11809: p_item_key wf_items.item_key%TYPE;
11810: p_item_type wf_items.item_type%TYPE := 'POREQCHA';
11811: p_submitter_action VARCHAR2(20) := 'APPROVE';
11812: p_workflow_process VARCHAR2(30) := 'MAIN_CHANGE_APPROVAL';
11813: l_change_request_group_id NUMBER;
11814: l_preparer_id NUMBER;