DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on WF_USERS

Line 183: l_name wf_users.name%TYPE; --bug 8620671

179: l_role VARCHAR2(50);
180: l_role_display VARCHAR2(150);
181: l_display_name VARCHAR2(150);
182: l_hist_id AP_INV_APRVL_HIST.APPROVAL_HISTORY_ID%TYPE;
183: l_name wf_users.name%TYPE; --bug 8620671
184: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
185: l_iteration NUMBER;
186: l_notf_iteration NUMBER;
187:

Line 4437: l_name wf_users.name%TYPE; --bug 8620671

4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4436: l_org_id ap_invoices_all.org_id%TYPE;
4437: l_name wf_users.name%TYPE; --bug 8620671
4438: l_display_name VARCHAR2(150);
4439: l_role VARCHAR2(50);
4440: l_role_display VARCHAR2(150);
4441: l_new_child_ItemKey VARCHAR2(30);

Line 4806: l_name wf_users.name%TYPE; --bug 8620671

4802: funcmode IN VARCHAR2,
4803: resultout OUT NOCOPY VARCHAR2 ) IS
4804: l_admin_approver AME_UTIL.approverRecord;
4805: l_ret_approver VARCHAR2(50);
4806: l_name wf_users.name%TYPE; --bug 8620671
4807: l_display_name VARCHAR2(150);
4808: l_debug_info VARCHAR2(50);
4809: l_role VARCHAR2(50);
4810: l_role_display VARCHAR2(150);

Line 5112: l_name wf_users.name%TYPE; --bug 8620671

5108: actid IN NUMBER,
5109: funcmode IN VARCHAR2,
5110: resultout OUT NOCOPY VARCHAR2 ) IS
5111: l_esc_approver AME_UTIL.approverRecord2;
5112: l_name wf_users.name%TYPE; --bug 8620671
5113: l_esc_approver_name VARCHAR2(150);
5114: l_esc_approver_id NUMBER(15);
5115: l_approver_id NUMBER(15);
5116: l_invoice_id NUMBER(15);

Line 5318: l_name wf_users.name%TYPE; --bug 8620671

5314: AND al.line_number = invap.line_number
5315: AND al.invoice_id = invap.invoice_id;
5316:
5317: l_esc_approver AME_UTIL.approverRecord2;
5318: l_name wf_users.name%TYPE; --bug 8620671
5319: l_esc_approver_name VARCHAR2(150);
5320: l_esc_approver_id NUMBER(15);
5321: l_approver_id NUMBER(15);
5322: l_invoice_id NUMBER(15);

Line 5633: l_name wf_users.name%TYPE; --bug 8620671

5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;
5632: l_org_id ap_invoices_all.org_id%TYPE;
5633: l_name wf_users.name%TYPE; --bug 8620671
5634: l_display_name VARCHAR2(150);
5635: l_role VARCHAR2(50);
5636: l_role_display VARCHAR2(150);
5637: l_new_child_ItemKey VARCHAR2(30);

Line 7897: l_name wf_users.name%TYPE; --bug 8620671

7893: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7894: l_role VARCHAR2(50);
7895: l_role_display VARCHAR2(150);
7896: l_org_id NUMBER(15);
7897: l_name wf_users.name%TYPE; --bug 8620671
7898: l_display_name VARCHAR2(150);
7899: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
7900: l_esc_approver AME_UTIL.approverRecord;
7901: l_rec_role VARCHAR2(50);

Line 8273: l_name wf_users.name%TYPE; --bug 8620671

8269: l_orig_sys_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8270: l_role VARCHAR2(50);
8271: l_role_display VARCHAR2(150);
8272: l_org_id NUMBER(15);
8273: l_name wf_users.name%TYPE; --bug 8620671
8274: l_display_name VARCHAR2(150);
8275: l_forward_to_user_id WF_ROLES.ORIG_SYSTEM_ID%TYPE;
8276: l_esc_approver AME_UTIL.approverRecord;
8277: l_rec_role VARCHAR2(50);

Line 8665: l_user_name wf_users.name%TYPE;

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';
8669: BEGIN