DBA Data[Home] [Help]

APPS.PA_XLA_SWEEP_TXN_PKG dependencies on PA_PLSQL_DATATYPES

Line 20: g_event_tab PA_PLSQL_DATATYPES.Num15TabTyp;

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 ;

Line 26: g_expenditure_item_id PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 27: g_line_num PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 28: g_adjusted_expenditure_item_id PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 29: g_system_linkage_function PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 30: g_PERIOD_ACCRUAL_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;

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:

Line 31: g_cdl_rowid PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 32: g_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;

Line 33: g_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;

Line 35: g_recvr_gl_date_new_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 36: g_recvr_gl_period_new_tab 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;

Line 37: g_recvr_sob_id PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 38: g_recvr_org_id PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 40: g_cdl_line_type PA_PLSQL_DATATYPES.Char1TabTyp;

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;

Line 41: g_liquidate_encum_flag PA_PLSQL_DATATYPES.Char1TabTyp;

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;

Line 42: g_buren_Sum_Dest_Run_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;

Line 43: g_document_header_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:

Line 44: g_document_distribution_id PA_PLSQL_DATATYPES.Num15TabTyp;

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,

Line 45: g_expenditure_type PA_PLSQL_DATATYPES.Char30TabTyp;

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,

Line 46: g_cdl_acct_event_id PA_PLSQL_DATATYPES.Num15TabTyp;

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