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);
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);
84: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_id, p_parameterlist=>l_parameter_list);
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);
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);
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);
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:
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 */
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 */
88: p_orig_system_id => l_vendor_id, /* in number */
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 */
88: p_orig_system_id => l_vendor_id, /* in number */
89: p_attributes => l_parameter_list, /* in wf_parameter_list_t */
93: l_parameter_list.DELETE;
94:
95: /* Next synch the PO_VENDOR_SITES */
96: -- Add Parameters
97: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDOR_SITES:'||l_vendor_site_id, p_parameterlist=>l_parameter_list);
98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
94:
95: /* Next synch the PO_VENDOR_SITES */
96: -- Add Parameters
97: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDOR_SITES:'||l_vendor_site_id, p_parameterlist=>l_parameter_list);
98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
95: /* Next synch the PO_VENDOR_SITES */
96: -- Add Parameters
97: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDOR_SITES:'||l_vendor_site_id, p_parameterlist=>l_parameter_list);
98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
96: -- Add Parameters
97: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDOR_SITES:'||l_vendor_site_id, p_parameterlist=>l_parameter_list);
98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
97: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDOR_SITES:'||l_vendor_site_id, p_parameterlist=>l_parameter_list);
98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, p_parameterlist=>l_parameter_list);
99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, p_parameterlist=>l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, p_parameterlist=>l_parameter_list);
107: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist => l_parameter_list);
100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, p_parameterlist=>l_parameter_list);
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, p_parameterlist=>l_parameter_list);
107: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist => l_parameter_list);
108:
101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, p_parameterlist=>l_parameter_list);
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, p_parameterlist=>l_parameter_list);
107: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist => l_parameter_list);
108:
109: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDOR_SITES',
102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, p_parameterlist=>l_parameter_list);
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, p_parameterlist=>l_parameter_list);
107: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist => l_parameter_list);
108:
109: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDOR_SITES',
110: p_orig_system_id => l_vendor_site_id,
103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', p_parameterlist=>l_parameter_list);
104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, p_parameterlist=>l_parameter_list);
105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', p_parameterlist=>l_parameter_list);
106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, p_parameterlist=>l_parameter_list);
107: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist => l_parameter_list);
108:
109: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDOR_SITES',
110: p_orig_system_id => l_vendor_site_id,
111: p_attributes => l_parameter_list,