1961: AI.vendor_site_id = PVS.vendor_site_id(+) and
1962: u.user_id = ai.created_by;
1963:
1964:
1965: wf_event.addparametertolist(p_name => 'INVOICE_ID',
1966: p_value => to_char(l_invoice_id),
1967: p_parameterlist => l_parameter_list);
1968:
1969: wf_event.addparametertolist(p_name => 'ORG_ID',
1965: wf_event.addparametertolist(p_name => 'INVOICE_ID',
1966: p_value => to_char(l_invoice_id),
1967: p_parameterlist => l_parameter_list);
1968:
1969: wf_event.addparametertolist(p_name => 'ORG_ID',
1970: p_value => to_char(p_org_id),
1971: p_parameterlist => l_parameter_list);
1972:
1973: wf_event.addparametertolist(p_name => 'ITERATION',
1969: wf_event.addparametertolist(p_name => 'ORG_ID',
1970: p_value => to_char(p_org_id),
1971: p_parameterlist => l_parameter_list);
1972:
1973: wf_event.addparametertolist(p_name => 'ITERATION',
1974: p_value => to_char(l_iteration),
1975: p_parameterlist => l_parameter_list);
1976:
1977: wf_event.addparametertolist(p_name => 'INVOICE_SUPPLIER_NAME',
1973: wf_event.addparametertolist(p_name => 'ITERATION',
1974: p_value => to_char(l_iteration),
1975: p_parameterlist => l_parameter_list);
1976:
1977: wf_event.addparametertolist(p_name => 'INVOICE_SUPPLIER_NAME',
1978: p_value => l_invoice_supplier_name,
1979: p_parameterlist => l_parameter_list);
1980:
1981: wf_event.addparametertolist(p_name => 'INVOICE_NUMBER',
1977: wf_event.addparametertolist(p_name => 'INVOICE_SUPPLIER_NAME',
1978: p_value => l_invoice_supplier_name,
1979: p_parameterlist => l_parameter_list);
1980:
1981: wf_event.addparametertolist(p_name => 'INVOICE_NUMBER',
1982: p_value => l_invoice_number,
1983: p_parameterlist => l_parameter_list);
1984:
1985: wf_event.addparametertolist(p_name => 'INVOICE_DESCRIPTION',
1981: wf_event.addparametertolist(p_name => 'INVOICE_NUMBER',
1982: p_value => l_invoice_number,
1983: p_parameterlist => l_parameter_list);
1984:
1985: wf_event.addparametertolist(p_name => 'INVOICE_DESCRIPTION',
1986: p_value => l_invoice_description,
1987: p_parameterlist => l_parameter_list);
1988:
1989: wf_event.addparametertolist(p_name => 'INVOICE_DATE',
1985: wf_event.addparametertolist(p_name => 'INVOICE_DESCRIPTION',
1986: p_value => l_invoice_description,
1987: p_parameterlist => l_parameter_list);
1988:
1989: wf_event.addparametertolist(p_name => 'INVOICE_DATE',
1990: p_value => to_char(l_invoice_date),
1991: p_parameterlist => l_parameter_list);
1992:
1993: wf_event.addparametertolist(p_name => 'SUPPLIER_ROLE',
1989: wf_event.addparametertolist(p_name => 'INVOICE_DATE',
1990: p_value => to_char(l_invoice_date),
1991: p_parameterlist => l_parameter_list);
1992:
1993: wf_event.addparametertolist(p_name => 'SUPPLIER_ROLE',
1994: p_value => l_supplier_role,
1995: p_parameterlist => l_parameter_list);
1996:
1997: l_debug_info := 'raise event';
2000: l_debug_info);
2001: END IF;
2002:
2003:
2004: wf_event.raise(p_event_name => p_eventname,
2005: p_event_key => p_invoice_id||to_char(sysdate, 'ddmonyyyyssmmhh'),
2006: p_parameters => l_parameter_list);
2007:
2008: l_parameter_list.delete;