DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_DIRECTORY

Line 1287: WF_DIRECTORY.GetUserName( 'PER', x_agent_id, x_buyer_username, x_buyer_display_name);

1283: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_DISPLAY_NAME', avalue => l_doc_display_name);
1284: IF x_agent_id IS NOT NULL THEN
1285: x_progress := '003';
1286: -- Get the buyer user name
1287: WF_DIRECTORY.GetUserName( 'PER', x_agent_id, x_buyer_username, x_buyer_display_name);
1288: x_progress := '004';
1289: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'BUYER_USER_NAME', avalue => x_buyer_username);
1290: END IF;
1291: -- CLM KO signature ER

Line 1329: WF_DIRECTORY.GetUserName( 'PER', l_clm_contract_officer, x_ko_username, x_ko_display_name);

1325: END IF;
1326:
1327: IF l_clm_contract_officer IS NOT NULL THEN
1328: -- Get the KO user name
1329: WF_DIRECTORY.GetUserName( 'PER', l_clm_contract_officer, x_ko_username, x_ko_display_name);
1330: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'KO_USER_NAME', avalue => x_ko_username);
1331: END IF;
1332: --DKC 10/10/99
1333: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'FAX_DOCUMENT', avalue => FaxFlag);

Line 3818: WF_DIRECTORY.CreateAdHocRole(x_role_with_resp, l_role_display_name , NULL, NULL, NULL, 'MAILHTML', l_namelist, NULL, NULL, 'ACTIVE', l_expiration_date);

3814: x_role_with_resp := get_wf_role_for_users(l_users_with_resp, l_user_count_with_resp ) ;
3815: IF(x_role_with_resp IS NULL ) THEN
3816: x_role_with_resp :=SUBSTR('ADHOCR' || TO_CHAR(sysdate, 'JSSSSS')|| p_document_id || p_document_type, 1, 30);
3817: l_step := '17'|| x_role_with_resp ;
3818: WF_DIRECTORY.CreateAdHocRole(x_role_with_resp, l_role_display_name , NULL, NULL, NULL, 'MAILHTML', l_namelist, NULL, NULL, 'ACTIVE', l_expiration_date);
3819: END IF;
3820: ELSE
3821: x_role_with_resp := NULL;
3822: END IF;

Line 3846: WF_DIRECTORY.CreateAdHocRole(l_role_name, l_role_display_name , NULL, NULL, NULL, 'MAILHTML', l_namelist, NULL, NULL, 'ACTIVE', l_expiration_date);

3842: /* Bug 2966804 START */
3843: /* We need to give a role name before creating an ADHOC role. */
3844: l_role_name := SUBSTR('ADHOC' || TO_CHAR(sysdate, 'JSSSSS')|| p_document_id || p_document_type, 1, 30);
3845: /* Bug 2966804 END */
3846: WF_DIRECTORY.CreateAdHocRole(l_role_name, l_role_display_name , NULL, NULL, NULL, 'MAILHTML', l_namelist, NULL, NULL, 'ACTIVE', l_expiration_date);
3847: x_resultout:=l_role_name;
3848: ELSE
3849: l_step := '11'|| l_role_name;
3850: x_resultout:= l_role_name;

Line 4043: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer, l_display_name, l_adhocuser_lang, l_adhocuser_territory, NULL, l_notification_preference, l_po_email_add, NULL, 'ACTIVE', NULL);

4039: x_progress := '003';
4040: IF (l_performer_exists = 0) THEN
4041: --EMAILPO FPH--
4042: -- Pass in the correct adhocuser language and territory for CreateAdHocUser and SetAdhocUserAttr instead of null
4043: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer, l_display_name, l_adhocuser_lang, l_adhocuser_territory, NULL, l_notification_preference, l_po_email_add, NULL, 'ACTIVE', NULL);
4044: ELSE
4045: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer, l_display_name, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, l_po_email_add, NULL);
4046: END IF;
4047: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'PO_WF_EMAIL_PERFORMER', avalue => l_po_email_performer);

Line 4045: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer, l_display_name, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, l_po_email_add, NULL);

4041: --EMAILPO FPH--
4042: -- Pass in the correct adhocuser language and territory for CreateAdHocUser and SetAdhocUserAttr instead of null
4043: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer, l_display_name, l_adhocuser_lang, l_adhocuser_territory, NULL, l_notification_preference, l_po_email_add, NULL, 'ACTIVE', NULL);
4044: ELSE
4045: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer, l_display_name, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, l_po_email_add, NULL);
4046: END IF;
4047: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'PO_WF_EMAIL_PERFORMER', avalue => l_po_email_performer);
4048: /* set the performer from thr profilr to send the second email */
4049: /* Bug 2989951. Secondary AdHocUser Name should be concatenation of the Secondary E-mail Address and the language

Line 4069: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer_prof, l_display_name_prof, l_adhocuser_lang, l_adhocuser_territory, NULL, l_notification_preference, l_po_email_add_prof, NULL, 'ACTIVE', NULL);

4065: --EMAILPO FPH START--
4066: -- For second email also the language and territory settings should be same as for the first one above
4067: x_progress := '004';
4068: IF (l_performer_exists = 0) THEN
4069: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer_prof, l_display_name_prof, l_adhocuser_lang, l_adhocuser_territory, NULL, l_notification_preference, l_po_email_add_prof, NULL, 'ACTIVE', NULL);
4070: ELSE
4071: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer_prof, l_display_name_prof, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, l_po_email_add_prof, NULL);
4072: END IF;
4073: --EMAILPO FPH END--

Line 4071: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer_prof, l_display_name_prof, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, l_po_email_add_prof, NULL);

4067: x_progress := '004';
4068: IF (l_performer_exists = 0) THEN
4069: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer_prof, l_display_name_prof, l_adhocuser_lang, l_adhocuser_territory, NULL, l_notification_preference, l_po_email_add_prof, NULL, 'ACTIVE', NULL);
4070: ELSE
4071: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer_prof, l_display_name_prof, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, l_po_email_add_prof, NULL);
4072: END IF;
4073: --EMAILPO FPH END--
4074: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'PO_WF_EMAIL_PERFORMER2', avalue => l_po_email_performer_prof);
4075: x_progress := '005';

Line 5328: WF_DIRECTORY.GetUserName(p_orig_system, p_employee_id, x_username, x_user_display_name);

5324: IS
5325: p_orig_system VARCHAR2(20);
5326: BEGIN
5327: p_orig_system:= 'PER';
5328: WF_DIRECTORY.GetUserName(p_orig_system, p_employee_id, x_username, x_user_display_name);
5329: EXCEPTION
5330: WHEN OTHERS THEN
5331: wf_core.context('PO_REQAPPROVAL_INIT1','get_user_name',TO_CHAR(p_employee_id));
5332: raise;

Line 7742: wf_directory.createadhocrole( l_role_name , l_role_display_name , NULL, NULL, NULL, 'MAILHTML', NULL, NULL, NULL, 'ACTIVE', sysdate+1);

7738: x_progress := '004';
7739: Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'N');
7740: ELSE
7741: x_progress := '005';
7742: wf_directory.createadhocrole( l_role_name , l_role_display_name , NULL, NULL, NULL, 'MAILHTML', NULL, NULL, NULL, 'ACTIVE', sysdate+1);
7743: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'BUYER_USER_NAME', avalue => l_role_name);
7744: END IF;
7745: EXCEPTION
7746: WHEN OTHERS THEN

Line 8375: wf_directory.GetUserName ( p_orig_system => 'PER', p_orig_system_id => l_emp_id, p_name => l_name, p_display_name => l_display_name );

8371: WHEN OTHERS THEN
8372: NULL;
8373: END;
8374: IF l_emp_id IS NOT NULL THEN
8375: wf_directory.GetUserName ( p_orig_system => 'PER', p_orig_system_id => l_emp_id, p_name => l_name, p_display_name => l_display_name );
8376: IF l_name IS NOT NULL THEN
8377: WF_DIRECTORY.GETROLEINFO ( ROLE => l_name, Display_Name => l_display_name, Email_Address => l_email_address, Notification_Preference => l_notification_preference, LANGUAGE => l_language, Territory => l_territory );
8378: IF l_language IS NOT NULL THEN
8379: BEGIN

Line 8377: WF_DIRECTORY.GETROLEINFO ( ROLE => l_name, Display_Name => l_display_name, Email_Address => l_email_address, Notification_Preference => l_notification_preference, LANGUAGE => l_language, Territory => l_territory );

8373: END;
8374: IF l_emp_id IS NOT NULL THEN
8375: wf_directory.GetUserName ( p_orig_system => 'PER', p_orig_system_id => l_emp_id, p_name => l_name, p_display_name => l_display_name );
8376: IF l_name IS NOT NULL THEN
8377: WF_DIRECTORY.GETROLEINFO ( ROLE => l_name, Display_Name => l_display_name, Email_Address => l_email_address, Notification_Preference => l_notification_preference, LANGUAGE => l_language, Territory => l_territory );
8378: IF l_language IS NOT NULL THEN
8379: BEGIN
8380: -- SQL What : Get the message in the approvers language.
8381: -- Sql Why : To maintain the NO ACTION message in approver language.