Calling Procedure
Hi,
I have a requirement to schedule calling a procedure in BIP.
I have a few ques.. Can i call a procedure in BI Publisher ?
Below is my script to call the oracle seeded procedure.
"
DECLARE
l_parameter_list wf_parameter_list_t;
BEGIN
wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_TYPE',p_value=>'CUSTOM_PO_VENDORS',p_parameterlist=>l_parameter_list);
wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_SUBTYPE',p_value=> 'TAX_MASTER_OUT',p_parameterlist=>l_parameter_list);
wf_event.AddParameterToList(p_name=>'ECX_PARTY_ID',p_value=>'1260',p_parameterlist=>l_parameter_list);
wf_event.AddParameterToList(p_name=>'ECX_PARTY_SITE_ID',p_value=>'62108',p_parameterlist=>l_parameter_list);
I have a requirement to schedule calling a procedure in BIP.
I have a few ques.. Can i call a procedure in BI Publisher ?
Below is my script to call the oracle seeded procedure.
"
DECLARE
l_parameter_list wf_parameter_list_t;
BEGIN
wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_TYPE',p_value=>'CUSTOM_PO_VENDORS',p_parameterlist=>l_parameter_list);
wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_SUBTYPE',p_value=> 'TAX_MASTER_OUT',p_parameterlist=>l_parameter_list);
wf_event.AddParameterToList(p_name=>'ECX_PARTY_ID',p_value=>'1260',p_parameterlist=>l_parameter_list);
wf_event.AddParameterToList(p_name=>'ECX_PARTY_SITE_ID',p_value=>'62108',p_parameterlist=>l_parameter_list);
0