DBA Data[Home] [Help]

PACKAGE BODY: APPS.XDP_XDP_PERF_BM_FP_U

Source


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;