1 PACKAGE BODY XDP_PLSQL_FE_LOC_U AS
2 Procedure PLSQL_FE_LOC(
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_fe_name OUT VARCHAR2,
8 p_return_code OUT NUMBER,
9 p_error_description OUT VARCHAR2)
10 is
11 begin
12 /*****************************************************************************
13 p_order_id IN NUMBER,
14 p_line_item_id IN NUMBER,
15 p_wi_instance_id IN NUMBER,
16 p_fa_instance_id IN NUMBER,
17 p_fe_name OUT VARCHAR2,
18 p_return_code OUT NUMBER,
19 p_error_description OUT VARCHAR2
20 *****************************************************************************/
21 xdp_macros.initdefault(p_order_id, p_line_item_id, p_wi_instance_id, p_fa_instance_id);
22 declare
23 /*****************************************************************************
24 This procedure returns the Fulfillment Element (FE) name of the FE
25 that is to be provisioned by this Fulfillment Action (FA).
26 It has the following input and output parameters:
27 p_order_id IN NUMBER -- order ID
28 p_wi_instance_id IN NUMBER -- workitem instance ID
29 p_fa_instance_id IN NUMBER -- FA instance ID
30 p_fe_name OUT VARCHAR2 -- FE to be provisioned
31 p_return_code OUT NUMBER -- Return Code
32 p_error_description OUT VARCHAR2 -- Error description
33 *****************************************************************************/
34 BEGIN
35 p_fe_name := 'PLSQL_FE';
36 p_return_code := 0;
37 END;
38
39 xdp_macros.EndProc(p_return_code, p_error_description);
40 exception
41 when others then
42 xdp_macros.HandleProcErrors(p_return_code,p_error_description);
43 end PLSQL_FE_LOC ;
44 END XDP_PLSQL_FE_LOC_U;