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 ;
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;
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;
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;
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;
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:
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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:
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,
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,
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);