1 PACKAGE BODY XDP_XDP_PERF_BM_FP_U AS
2 Procedure XDP_PERF_BM_FP(
3 p_order_id IN NUMBER,
4 p_line_item_id IN NUMBER,
5 p_wi_instance_id IN NUMBER,
6 p_fa_instance_id IN NUMBER,
7 p_channel_name IN VARCHAR2,
8 p_fe_name IN VARCHAR2,
9 p_fa_item_type IN VARCHAR2,
10 p_fa_item_key IN VARCHAR2,
11 p_return_code OUT NUMBER,
12 p_error_description OUT VARCHAR2)
13 is
14 order_id NUMBER := p_order_id;
15 line_item_id NUMBER := p_line_item_id;
16 workitem_instance_id NUMBER := p_wi_instance_id;
17 fa_instance_id NUMBER := p_fa_instance_id;
18 db_channel_name VARCHAR2(40) := p_channel_name;
19 fe_name VARCHAR2(80) := p_fe_name;
20 fa_item_type VARCHAR2(8) := p_fa_item_type;
21 fa_item_key VARCHAR2(240) := p_fa_item_key;
22 LOG VARCHAR2(1) := 'N';
23 NOLOG VARCHAR2(1) := 'Y';
24 RETRY number := 1;
25 NORETRY number := 0;
26 fa_item_key VARCHAR2(240) := p_fa_item_key;
27 sdp_internal_response VARCHAR2(32767);
28 sdp_internal_err_code VARCHAR2(40) := p_return_code;
29 sdp_internal_err_str VARCHAR2(40) := p_error_description;
30 begin
31 /*****************************************************************************
32 p_order_id IN NUMBER,
33 p_line_item_id IN NUMBER,
34 p_wi_instance_id IN NUMBER,
35 p_fa_instance_id IN NUMBER,
36 p_channel_name IN VARCHAR2,
37 p_fe_name IN VARCHAR2,
38 p_fa_item_type IN VARCHAR2,
39 p_fa_item_key IN VARCHAR2,
40 p_return_code OUT NUMBER,
41 p_error_description OUT VARCHAR2
42 *****************************************************************************/
43 xdp_macros.initfp(p_order_id, p_line_item_id, p_wi_instance_id, p_fa_instance_id, p_channel_name, p_fe_name, 'XDP_PERF_BM_FP');
44 declare
45 /*****************************************************************************
46 This procedure is called by the FA to provision a FE for a particular service.
47 It has the following input parameters and no output parameters:
48 order_id IN NUMBER -- order ID
49 line_item_id IN NUMBER -- Line Item ID
50 workitem_instance_id IN NUMBER -- workitem instance ID
51 fa_instance_id IN NUMBER -- FA instance ID
52 db_channel_name IN VARCHAR2 -- Channel name used by this procedure
53 fe_name IN VARCHAR2 -- FE name to be provisioned by this procedure
54 fa_item_type IN VARCHAR2 -- FA workflow process item type
55 fa_item_key IN VARCHAR2 -- FA workflow process item key
56 *****************************************************************************/
57 -- Enter your procedure below:
58 BEGIN
59 -- your code...
60 null;
61 END;
62
63 xdp_macros.EndProc(p_return_code, p_error_description);
64 exception
65 when others then
66 xdp_macros.HandleProcErrors(p_return_code,p_error_description);
67 end XDP_PERF_BM_FP ;
68 END XDP_XDP_PERF_BM_FP_U;