1 PACKAGE itg_outbound_utils AUTHID CURRENT_USER AS
2 /* ARCS: $Header: itgoutus.pls 115.2 2002/12/19 02:08:09 ecoe noship $
3 * CVS: itgoutus.pls,v 1.9 2002/12/19 02:00:36 ecoe Exp
4 */
5
6 /* Create a parameter list (array).
7 * Args:
8 * p_bsr The BSR VERB_NOUN string, with no revision number.
9 * For example: 'SYNC_PO'.
10 * P_id The id of the DB table/view row for this document.
11 * p_org The org id of this document (unless NULL).
12 * p_param1-4 Additional optional parameters; transaction-specific.
13 */
14 FUNCTION get_parameter_list(
15 p_bsr IN VARCHAR2,
16 p_id IN NUMBER,
17 p_org IN NUMBER,
18 p_doctyp IN VARCHAR2,
19 p_clntyp IN VARCHAR2,
20 p_doc IN VARCHAR2 := NULL,
21 p_rel IN VARCHAR2 := NULL,
22 p_param1 IN VARCHAR2 := NULL,
23 p_param2 IN VARCHAR2 := NULL,
24 p_param3 IN VARCHAR2 := NULL,
25 p_param4 IN VARCHAR2 := NULL
26 ) RETURN wf_parameter_list_t;
27
28 /* Change args in list object if not NULL. Set list object item to NULL
29 * if VARCHAR2 args are ' ' (a single space) or NUMBER args are -1.
30 */
31 PROCEDURE change_parameter_list(
32 p_list IN OUT NOCOPY wf_parameter_list_t,
33 p_bsr IN VARCHAR2 := NULL,
34 p_id IN NUMBER := NULL,
35 p_org IN NUMBER := NULL,
36 p_doctyp IN VARCHAR2 := NULL,
37 p_clntyp IN VARCHAR2 := NULL,
38 p_doc IN VARCHAR2 := NULL,
39 p_rel IN VARCHAR2 := NULL,
40 p_param1 IN VARCHAR2 := NULL,
41 p_param2 IN VARCHAR2 := NULL,
42 p_param3 IN VARCHAR2 := NULL,
43 p_param4 IN VARCHAR2 := NULL
44 );
45
46 /* Raise a WF event with our event name and key and the given p_params */
47 PROCEDURE raise_wf_event_params(
48 p_params IN wf_parameter_list_t
49 );
50
51 /* Combine everything in a single convient function. */
52 PROCEDURE raise_wf_event(
53 p_bsr IN VARCHAR2,
54 p_id IN NUMBER,
55 p_org IN NUMBER,
56 p_doctyp IN VARCHAR2,
57 p_clntyp IN VARCHAR2,
58 p_doc IN VARCHAR2 := NULL,
59 p_rel IN VARCHAR2 := NULL,
60 p_param1 IN VARCHAR2 := NULL,
61 p_param2 IN VARCHAR2 := NULL,
62 p_param3 IN VARCHAR2 := NULL,
63 p_param4 IN VARCHAR2 := NULL
64 );
65
66 END itg_outbound_utils;