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.POS_WCAPPROVE_PVT dependencies on WF_ROLES

Line 2251: 'Record Not Found in WF_ROLES for the orig_system_id :' ||

2247: END IF;
2248:
2249: IF l_current_approver.name IS NULL THEN
2250: raise_application_error(-20001,
2251: 'Record Not Found in WF_ROLES for the orig_system_id :' ||
2252: l_current_approver.orig_system_id || ' -- orig_system :' || l_current_approver.orig_system );
2253: END IF;
2254:
2255:

Line 2405: l_more_origsys wf_roles.orig_system%TYPE;

2401: l_original_recipient wf_notifications.original_recipient%TYPE;
2402: l_recipient_role wf_notifications.recipient_role%TYPE;
2403: l_more_info_role wf_notifications.more_info_role%TYPE;
2404: l_responder_id number;
2405: l_more_origsys wf_roles.orig_system%TYPE;
2406: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
2407: l_responder wf_notifications.responder%TYPE;
2408:
2409:

Line 2406: l_more_origsysid wf_roles.orig_system_id%TYPE := null;

2402: l_recipient_role wf_notifications.recipient_role%TYPE;
2403: l_more_info_role wf_notifications.more_info_role%TYPE;
2404: l_responder_id number;
2405: l_more_origsys wf_roles.orig_system%TYPE;
2406: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
2407: l_responder wf_notifications.responder%TYPE;
2408:
2409:
2410: begin

Line 2501: FROM wf_roles wfu

2497: CLOSE c_responderid;
2498:
2499: SELECT wfu.orig_system_id
2500: INTO l_original_recipient_id
2501: FROM wf_roles wfu
2502: WHERE wfu.name = l_original_recipient
2503: AND wfu.orig_system NOT IN ('POS', 'ENG_LIST', 'CUST_CONT');
2504:
2505: END IF; --}

Line 3102: l_new_recipient_id wf_roles.orig_system_id%TYPE;

3098: l_forwardTo varchar2(240);
3099: l_result varchar2(100);
3100: l_forward_to_username_response varchar2(240) :='';
3101: l_action po_action_history.action_code%TYPE;
3102: l_new_recipient_id wf_roles.orig_system_id%TYPE;
3103: l_origsys wf_roles.orig_system%TYPE;
3104: l_shipment_line_id number;
3105: l_shipment_header_id number;
3106: l_sequence_num number;

Line 3103: l_origsys wf_roles.orig_system%TYPE;

3099: l_result varchar2(100);
3100: l_forward_to_username_response varchar2(240) :='';
3101: l_action po_action_history.action_code%TYPE;
3102: l_new_recipient_id wf_roles.orig_system_id%TYPE;
3103: l_origsys wf_roles.orig_system%TYPE;
3104: l_shipment_line_id number;
3105: l_shipment_header_id number;
3106: l_sequence_num number;
3107: