DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on WF_ROLES

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

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

Line 2404: l_more_origsys wf_roles.orig_system%TYPE;

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

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

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

Line 2500: FROM wf_roles wfu

2496: CLOSE c_responderid;
2497:
2498: SELECT wfu.orig_system_id
2499: INTO l_original_recipient_id
2500: FROM wf_roles wfu
2501: WHERE wfu.name = l_original_recipient
2502: AND wfu.orig_system NOT IN ('POS', 'ENG_LIST', 'CUST_CONT');
2503:
2504: 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: