DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on FND_USER

Line 682: FROM fnd_user

678: sales_order := SUBSTRB (fnd_message.get, 1, 240);
679:
680: SELECT user_name
681: INTO l_owner_role
682: FROM fnd_user
683: WHERE user_id = fnd_global.user_id;
684:
685: -- Create Header Work item
686: wf_engine.createprocess (oe_globals.g_wfi_hdr,

Line 725: FROM fnd_user

721: /* new logic to get FROM_ROLE */
722: BEGIN
723: SELECT user_name
724: INTO l_user_name
725: FROM fnd_user
726: WHERE user_id = fnd_global.user_id;
727: EXCEPTION
728: WHEN OTHERS
729: THEN

Line 933: FROM fnd_user

929: line := SUBSTRB (fnd_message.get, 1, 240);
930:
931: SELECT user_name
932: INTO l_owner_role
933: FROM fnd_user
934: WHERE user_id = fnd_global.user_id;
935:
936: -- Create Line Work item
937: wf_engine.createprocess (oe_globals.g_wfi_lin,

Line 2808: FROM fnd_user

2804: END IF;
2805:
2806: SELECT user_name
2807: INTO v_value
2808: FROM fnd_user
2809: WHERE user_id = v_id
2810: AND (employee_id IS NULL OR employee_id IN (SELECT person_id
2811: FROM per_people_f)
2812: );

Line 2841: FROM fnd_user

2837: END IF;
2838:
2839: SELECT user_name
2840: INTO v_value
2841: FROM fnd_user
2842: WHERE user_id = v_id
2843: AND (employee_id IS NULL OR employee_id IN (SELECT person_id
2844: FROM per_people_f)
2845: );

Line 3461: FROM fnd_user

3457: || TO_CHAR (p_transaction_number);
3458:
3459: SELECT user_name
3460: INTO l_owner_role
3461: FROM fnd_user
3462: WHERE user_id = p_user_id;
3463:
3464: -- Create process
3465: wf_engine.createprocess (p_item_type,

Line 3639: FROM fnd_user

3635: l_sales_document_type || ' ' || TO_CHAR (p_transaction_number);
3636:
3637: SELECT user_name
3638: INTO l_owner_role
3639: FROM fnd_user
3640: WHERE user_id = fnd_global.user_id;
3641:
3642: -- Create Header Work item
3643: wf_engine.createprocess (p_item_type,

Line 3683: FROM fnd_user

3679: /* get FROM_ROLE */
3680: BEGIN
3681: SELECT user_name
3682: INTO l_user_name
3683: FROM fnd_user
3684: WHERE user_id = fnd_global.user_id;
3685: EXCEPTION
3686: WHEN OTHERS
3687: THEN