PACKAGE: APPS.PA_XLA_SWEEP_TXN_PKG

Source

1 PACKAGE PA_XLA_SWEEP_TXN_PKG AUTHID CURRENT_USER AS
2 --  $Header: PACCGLES.pls 120.1 2005/10/26 03:04:11 rshaik noship $
3 
4 
5 g_bulk_Size		Number := 500;
6 g_cdl_bulk_size		Number := 500;
7 
8 g_currec                Number;
9 g_org_id                Number;
10 
11 g_tran_type             pa_lookups.lookup_code%type;
12 
13 g_new_period_name	Varchar2(100);
14 g_new_period_date	Date;
15 g_sob_id		pa_implementations_all.set_of_books_id%type;
16 g_app_id		Number := 101;
17 
18 g_request_id		FND_CONCURRENT_REQUESTS.REQUEST_ID%TYPE;
19 
20 g_event_tab		PA_PLSQL_DATATYPES.Num15TabTyp;
21 g_first_date		date;
22 g_last_date		date;
23 
24 g_user_id               XLA_EVENTS.LAST_UPDATED_BY%type ;
25 
26 g_expenditure_item_id			PA_PLSQL_DATATYPES.Num15TabTyp;
27 g_line_num				PA_PLSQL_DATATYPES.Num15TabTyp;
28 g_adjusted_expenditure_item_id		PA_PLSQL_DATATYPES.Num15TabTyp;
29 g_system_linkage_function		PA_PLSQL_DATATYPES.Char30TabTyp;
30 g_PERIOD_ACCRUAL_FLAG			PA_PLSQL_DATATYPES.Char1TabTyp;
31 g_cdl_rowid				PA_PLSQL_DATATYPES.Char30TabTyp;
32 g_gl_date_new_tab			PA_PLSQL_DATATYPES.DateTabTyp;
33 g_gl_period_new_tab			PA_PLSQL_DATATYPES.Char30TabTyp;
34 
35 g_recvr_gl_date_new_tab			PA_PLSQL_DATATYPES.DateTabTyp;
36 g_recvr_gl_period_new_tab		PA_PLSQL_DATATYPES.Char30TabTyp;
37 g_recvr_sob_id				PA_PLSQL_DATATYPES.Num15TabTyp;
38 g_recvr_org_id				PA_PLSQL_DATATYPES.Num15TabTyp;
39 -- R12 Funds management uptake : Added below PLSQL variables
40 g_cdl_line_type                         PA_PLSQL_DATATYPES.Char1TabTyp;
41 g_liquidate_encum_flag                  PA_PLSQL_DATATYPES.Char1TabTyp;
42 g_buren_Sum_Dest_Run_Id                 PA_PLSQL_DATATYPES.Num15TabTyp;
43 g_document_header_Id                    PA_PLSQL_DATATYPES.Num15TabTyp;
44 g_document_distribution_id              PA_PLSQL_DATATYPES.Num15TabTyp;
45 g_expenditure_type                      PA_PLSQL_DATATYPES.Char30TabTyp;
46 g_cdl_acct_event_id                     PA_PLSQL_DATATYPES.Num15TabTyp;
47 
48 Procedure SWEEP_TXNS  (P_ORG_ID    PA_IMPLEMENTATIONS_ALL.ORG_ID%TYPE,
49                        P_GL_PERIOD GL_PERIOD_STATUSES.PERIOD_NAME%TYPE,
50 		       P_TRAN_TYPE VARCHAR2);
51 
52 Procedure POPULATE_GL_DATE;
53 
54 
55 Procedure CHECK_MISC_TXNS;
56 
57 
58 END PA_XLA_SWEEP_TXN_PKG;