PACKAGE: APPS.JAI_OM_WDD_PROCESSING_PKG

Source

1 PACKAGE JAI_OM_WDD_PROCESSING_PKG AS
2   /* $Header: jai_om_wdd_prc.pls 120.0.12020000.3 2013/03/19 00:32:16 vkaranam noship $ */
3 
4   t_rec  WSH_DELIVERY_DETAILS%rowtype ;
5   TYPE exp_tbl_type       IS TABLE OF JAI_WSH_EXCEPTIONS_T%ROWTYPE;
6 
7   PROCEDURE DELIVER_DETAILS( pr_old t_rec%type ,
8                              pr_new t_rec%type ,
9 							               pv_action varchar2 ,
10 							               pv_return_code out nocopy varchar2 ,
11 							               pv_return_message out nocopy varchar2 );
12   FUNCTION BE_INTERFACED(p_subscription_guid IN raw,
13                          p_event             IN OUT nocopy WF_EVENT_T) RETURN VARCHAR2;
14   FUNCTION BE_RELEASED(p_subscription_guid IN raw,
15                        p_event             IN OUT nocopy WF_EVENT_T) RETURN VARCHAR2;
16   PROCEDURE PROCESS_VALIDATION (p_delivery_id  number,
17                                 p_rec_new t_rec%type ,
18                                 px_return_code out nocopy varchar2 ,
19                                 px_exp_msg     out nocopy exp_tbl_type );
20   -- added by zhiwei.xin for VAT Invoice Generation/Accounting Integration on 6-NOV-2012 begin
21   FUNCTION INV_INTERFACED(p_subscription_guid IN raw,
22                           p_event             IN OUT nocopy WF_EVENT_T) RETURN VARCHAR2;
23   -- added by zhiwei.xin for VAT Invoice Generation/Accounting Integration on 6-NOV-2012 end.
24 
25   -- added by zhiwei.xin for Trigger Replacement bug#15968958 on 20-Dec-2012 begin
26   PROCEDURE PROCESS_INTERFACED (pr_old t_rec%type ,
27                                 pr_new t_rec%type ,
28                                 pv_action varchar2 ,
29                                 pv_return_code out nocopy varchar2 ,
30                                 pv_return_message out nocopy varchar2 );
31 
32   PROCEDURE PROCESS_RELEASED ( pr_old t_rec%type ,
33                                pr_new t_rec%type ,
34                                pv_action varchar2 ,
35                                pv_return_code out nocopy varchar2 ,
36                                pv_return_message out nocopy varchar2 );
37 
38   PROCEDURE RG23D_REV_ACCOUNTING(pr_trig_row       IN wsh_delivery_details%ROWTYPE,
39                                  pv_return_code    out nocopy VARCHAR2,
40                                  pv_return_message out nocopy VARCHAR2);
41   -- added by zhiwei.xin for Trigger Replacement bug#15968958 on 20-Dec-2012 end.
42 
43   -- added for bug#16167577 wsh exception handling on 4-JAN-2013 begin
44   PROCEDURE PROCESS_INVENTORY(pv_return_code OUT NOCOPY VARCHAR2,
45                               pv_return_msg  OUT NOCOPY VARCHAR2,
46                               p_delivery_id  NUMBER);
47   PROCEDURE CLEAR_EXP_MSG (p_delivery_id number,
48                            p_exp_entity  varchar2);
49   PROCEDURE POPULATE_EXP_MSG (p_delivery_id  number,
50                               p_exp_msg   exp_tbl_type);
51   -- added for bug#16167577 wsh exception handling on 4-JAN-2013 end.
52 
53 END JAI_OM_WDD_PROCESSING_PKG;