APPS.PO_WFDS_PUB dependencies on PO_VENDORS

Line 64: /* Get all the necessary data from po_vendors_all and po_vendors */

60: l_email := wf_engine.GetItemAttrText (itemtype => itemtype,
61: itemkey => itemkey,
62: aname => 'ECX_COMPANY_ADMIN_EMAIL');
63:
64: /* Get all the necessary data from po_vendors_all and po_vendors */
65:
66: select vendor_name
67: into l_vendor_name
68: from po_vendors

Line 68: from po_vendors

64: /* Get all the necessary data from po_vendors_all and po_vendors */
65:
66: select vendor_name
67: into l_vendor_name
68: from po_vendors
69: where vendor_id = l_vendor_id;
70:
71: select language, fax, vendor_site_code,
72: ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || CITY || ' ' || STATE || ' ' || ' ' || ZIP || ' ' || COUNTRY site_address

Line 77: /* First synch the PO_VENDORS */

73: into l_language, l_fax, l_site_code, l_site_address
74: from po_vendor_sites_all
75: where vendor_site_id = l_vendor_site_id;
76:
77: /* First synch the PO_VENDORS */
78: -- Add Parameters
79: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDORS:'||l_vendor_id, p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name, p_parameterlist=>l_parameter_list);
81: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);

Line 79: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDORS:'||l_vendor_id, p_parameterlist=>l_parameter_list);

75: where vendor_site_id = l_vendor_site_id;
76:
77: /* First synch the PO_VENDORS */
78: -- Add Parameters
79: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDORS:'||l_vendor_id, p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name, p_parameterlist=>l_parameter_list);
81: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
82: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDORS', p_parameterlist=>l_parameter_list);

Line 83: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDORS', p_parameterlist=>l_parameter_list);

79: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDORS:'||l_vendor_id, p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name, p_parameterlist=>l_parameter_list);
81: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
82: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDORS', p_parameterlist=>l_parameter_list);
84: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_id, p_parameterlist=>l_parameter_list);
85: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist=>l_parameter_list);
86:
87: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDORS', /* in varchar2 */

Line 87: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDORS', /* in varchar2 */

83: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDORS', p_parameterlist=>l_parameter_list);
84: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_id, p_parameterlist=>l_parameter_list);
85: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist=>l_parameter_list);
86:
87: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDORS', /* in varchar2 */
88: p_orig_system_id => l_vendor_id, /* in number */
89: p_attributes => l_parameter_list, /* in wf_parameter_list_t */
90: p_start_date => sysdate, /* in date */
91: p_expiration_date => null /* in date */);