APPS.OE_ORDER_WF_UTIL dependencies on FND_USER

Line 589: FROM FND_USER

585: sales_order := substrb(fnd_message.get, 1, 240);
586:
587: SELECT user_name
588: INTO l_owner_role
589: FROM FND_USER
590: WHERE USER_ID = FND_GLOBAL.USER_ID;
591: -- Create Header Work item
592: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
593: l_hdr_process_name,

Line 626: from fnd_user

622: /* new logic to get FROM_ROLE */
623: BEGIN
624: select user_name
625: into l_user_name
626: from fnd_user
627: where user_id = FND_GLOBAL.USER_ID;
628:
629: EXCEPTION
630: WHEN OTHERS THEN

Line 816: FROM FND_USER

812: line := substrb(fnd_message.get, 1, 240);
813:
814: SELECT user_name
815: INTO l_owner_role
816: FROM FND_USER
817: WHERE USER_ID = FND_GLOBAL.USER_ID;
818:
819: -- Create Line Work item
820: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN,to_char(p_Line_rec.line_id),

Line 2219: FROM FND_USER

2215: WHERE HEADER_ID = v_header_id;
2216: END IF;
2217: SELECT USER_NAME
2218: INTO v_value
2219: FROM FND_USER
2220: WHERE USER_ID = v_id
2221: AND (EMPLOYEE_ID is null
2222: OR
2223: EMPLOYEE_ID in (SELECT PERSON_ID

Line 2250: FROM FND_USER

2246: END IF;
2247:
2248: SELECT USER_NAME
2249: INTO v_value
2250: FROM FND_USER
2251: WHERE USER_ID = v_id
2252: AND (EMPLOYEE_ID is null
2253: OR
2254: EMPLOYEE_ID in (SELECT PERSON_ID

Line 2701: FROM FND_USER

2697: user_key_string := substrb(fnd_message.get, 1, 240) || ' ' || to_char(p_transaction_number);
2698:
2699: SELECT user_name
2700: INTO l_owner_role
2701: FROM FND_USER
2702: WHERE USER_ID = p_user_id;
2703:
2704: -- Create process
2705: WF_ENGINE.CreateProcess(p_item_type,

Line 2867: FROM FND_USER

2863: user_key_string := l_sales_document_type || ' ' || to_char(p_transaction_number);
2864:
2865: SELECT user_name
2866: INTO l_owner_role
2867: FROM FND_USER
2868: WHERE USER_ID = FND_GLOBAL.USER_ID;
2869:
2870: -- Create Header Work item
2871: WF_ENGINE.CreateProcess(p_item_type,

Line 2909: from fnd_user

2905: /* get FROM_ROLE */
2906: BEGIN
2907: select user_name
2908: into l_user_name
2909: from fnd_user
2910: where user_id = FND_GLOBAL.USER_ID;
2911:
2912: EXCEPTION
2913: WHEN OTHERS THEN