DBA Data[Home] [Help]

PACKAGE BODY: APPS.XDP_PLSQL_FE_LOC_U

Source


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;