APPS.AP_WORKFLOW_PKG dependencies on FND_USER

Line 5191: FROM fnd_user

5187: */
5188: -- bug#6837841 Changes Starts
5189: /*SELECT user_id
5190: INTO l_esc_approver_id
5191: FROM fnd_user
5192: WHERE employee_id =
5193: (SELECT supervisor_id
5194: FROM per_employees_current_x
5195: WHERE employee_id = l_approver_id);

Line 5407: FROM fnd_user

5403: */
5404: /* -- commented for 8682244
5405: SELECT user_id
5406: INTO l_esc_approver_id
5407: FROM fnd_user
5408: WHERE employee_id =
5409: (SELECT supervisor_id
5410: FROM per_employees_current_x
5411: WHERE employee_id = l_approver_id);

Line 7919: FROM FND_USER

7915: l_invoice_total NUMBER;
7916:
7917: CURSOR c_get_user ( p_rec_role IN VARCHAR2 ) IS
7918: SELECT user_id,employee_id
7919: FROM FND_USER
7920: WHERE USER_NAME=p_rec_role;
7921:
7922: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7923: Select response

Line 8294: FROM FND_USER

8290:
8291:
8292: CURSOR c_get_user ( p_rec_role IN VARCHAR2 ) IS
8293: SELECT user_id,employee_id
8294: FROM FND_USER
8295: WHERE USER_NAME=p_rec_role;
8296:
8297: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
8298: Select response

Line 8664: l_user_id FND_USER.user_id%TYPE;

8660: itemkey IN VARCHAR2,
8661: actid IN NUMBER,
8662: funcmode IN VARCHAR2,
8663: resultout OUT NOCOPY VARCHAR2 ) IS
8664: l_user_id FND_USER.user_id%TYPE;
8665: l_user_name wf_users.name%TYPE;
8666: l_user_role_count NUMBER DEFAULT 0;
8667: l_debug_info VARCHAR2(2000);
8668: l_api_name CONSTANT VARCHAR2(200) := 'Post_Notif_Handler';

Line 8726: -- check if the role is a valid FND user

8722: END IF;
8723:
8724: IF l_user_name <> fnd_global.user_name
8725: THEN
8726: -- check if the role is a valid FND user
8727: SELECT user_id
8728: INTO l_user_id
8729: FROM fnd_user
8730: WHERE user_name = l_user_name;

Line 8729: FROM fnd_user

8725: THEN
8726: -- check if the role is a valid FND user
8727: SELECT user_id
8728: INTO l_user_id
8729: FROM fnd_user
8730: WHERE user_name = l_user_name;
8731:
8732: l_debug_info := 'l_user_id = ' || l_user_id ;
8733: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )

Line 8858: FROM FND_USER

8854: AND al.invoice_id = invap.invoice_id;
8855:
8856: CURSOR c_get_user ( p_rec_role IN VARCHAR2 ) IS
8857: SELECT user_id,employee_id
8858: FROM FND_USER
8859: WHERE USER_NAME=p_rec_role;
8860:
8861: BEGIN
8862: --Getting data from WF Engine