DBA Data[Home] [Help]

APPS.PO_WFDS_PUB dependencies on WF_EVENT

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 80: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name, 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);

Line 81: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', 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);

Line 82: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, 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:

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 84: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>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 */
88: p_orig_system_id => l_vendor_id, /* in number */

Line 85: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', 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 */
89: p_attributes => l_parameter_list, /* in wf_parameter_list_t */

Line 97: wf_event.AddParameterToList(p_name=>'USER_NAME', p_value=>'PO_VENDOR_SITES:'||l_vendor_site_id, p_parameterlist=>l_parameter_list);

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);

Line 98: wf_event.AddParameterToList(p_name=>'DISPLAYNAME', p_value=>l_vendor_name||' '||l_site_address, 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);

Line 99: wf_event.AddParameterToList(p_name=>'PREFERREDLANGUAGE', p_value=>l_language, 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);

Line 100: --wf_event.AddParameterToList(p_name=>'ORCLNLSTERRITORY', p_value=>l_language, 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);

Line 101: wf_event.AddParameterToList(p_name=>'MAIL', p_value=>l_email, 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);

Line 102: wf_event.AddParameterToList(p_name=>'FACSIMILETELEPHONENUMBER', p_value=>l_fax, 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);

Line 103: wf_event.AddParameterToList(p_name=>'ORCLISENABLED', p_value=>'ACTIVE', 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);

Line 104: wf_event.AddParameterToList(p_name=>'EXPIRATIONDATE', p_value=>null, 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:

Line 105: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEM', p_value=>'PO_VENDOR_SITES', 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:
109: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PO_VENDOR_SITES',

Line 106: wf_event.AddParameterToList(p_name=>'ORCLWFORIGSYSTEMID', p_value=>l_vendor_site_id, 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',
110: p_orig_system_id => l_vendor_site_id,

Line 107: wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', 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,
111: p_attributes => l_parameter_list,