DBA Data[Home] [Help]

PACKAGE: APPS.PO_DRAFT_EVENTS_PKG

Source


1 PACKAGE PO_DRAFT_EVENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_DRAFT_EVENTS_PKG.pls 120.1.12020000.1 2013/02/11 10:29:48 vegajula noship $*/
3 
4   -------------------------------------------------------------------------------
5   --Start of Comments
6   --Name: delete_draft_events
7   --Pre-reqs:
8   --  None.
9   --Modifies:
10   --  None.
11   --Locks:
12   --  None.
13   --Function:
14   -- This procedure will be used to delete invalid/draft events
15   -- for all PO,PA and Requistion encumbrance events
16   --Parameters:
17   --IN:
18   --  p_init_msg_list
19   --  p_ledger_id
20   --  p_start_date
21   --  p_end_date
22   --  p_calling_sequence
23   --  p_currency_code_func: currency code of the functional currency.
24   --IN OUT:
25   --  None.
26   --OUT:
27   --  x_return_status
28   --  x_msg_count
29   --  x_msg_data
30   --Notes:
31   --  This procedure will be called from PSA BC optimizer to delete
32   -- invalid/draft encumbrance events. This is required to avoid showing
33   -- in subledger exception report.
34   --Testing:
35   --
36   --End of Comments
37   -------------------------------------------------------------------------------
38 PROCEDURE delete_draft_events (
39 			    p_init_msg_list    IN VARCHAR2,
40 			    p_ledger_id        IN NUMBER,
41 			    p_start_date       IN DATE,
42 			    p_end_date         IN DATE,
43 			    p_calling_sequence IN VARCHAR2,
44 			    x_return_status    OUT NOCOPY VARCHAR2,
45 			    x_msg_count        OUT NOCOPY NUMBER,
46 			    x_msg_data         OUT NOCOPY VARCHAR2
47 			  ) ;
48 
49 
50 
51 END PO_DRAFT_EVENTS_PKG;