eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_UTILS2 dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 83: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;

79:
80: /*
81: * EPP.
82: */
83: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;
84: g_prev_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
85: g_prev_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
86: g_prev_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
87: g_prev_recvr_gl_date pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

Line 98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

94: g_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
96:
97: /* Period End Accruals */
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

Line 99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

95: g_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
96:
97: /* Period End Accruals */
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:

Line 100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

96:
97: /* Period End Accruals */
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

Line 101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

97: /* Period End Accruals */
98: g_p_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
99: g_p_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

Line 104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

100: g_p_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

Line 105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

101: g_p_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:

Line 106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

102: g_p_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;

103:
104: g_r_org_accr_start_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
105: g_r_org_accr_end_date pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
106: g_r_rev_accr_nxt_st_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
107: g_r_rev_accr_nxt_end_dt pa_expenditure_items_all.prvdr_accrual_date%TYPE := NULL;
108: g_r_rev_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
109:
110: g_p_accr_gl_per_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
111: g_p_accr_gl_per_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 359: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

355:
356: ---------------------------------------------------------------
357: -- Procedure : get_period_information
358: ---------------------------------------------------------------
359: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL

Line 360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL

356: ---------------------------------------------------------------
357: -- Procedure : get_period_information
358: ---------------------------------------------------------------
359: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL

Line 361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL

357: -- Procedure : get_period_information
358: ---------------------------------------------------------------
359: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
360: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE := NULL
361: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE := NULL
362: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE := NULL
363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL

Line 367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

363: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
368: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
369: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
371: ,p_calling_module IN VARCHAR2 := NULL

Line 368: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL

364: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE := NULL
365: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
366: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE := NULL
367: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
368: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE := NULL
369: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE := NULL
371: ,p_calling_module IN VARCHAR2 := NULL
372: ,p_ou_context IN VARCHAR2 DEFAULT 'N'

Line 386: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

382: ,x_error_code OUT NOCOPY VARCHAR2
383: ,x_error_stage OUT NOCOPY NUMBER
384: );
385: ---------------------------------------------------------------
386: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
387: ,p_calling_module IN VARCHAR2 := NULL
388: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
389: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
390: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

Line 427: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

423: );
424: ------------------------------------------------------------------------------------------------------------------
425: -- Procedure : get_accrual_period_information
426: ------------------------------------------------------------------------------------------------------------------
427: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
428: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
430: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 430: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

426: ------------------------------------------------------------------------------------------------------------------
427: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
428: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
430: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
434: ,p_calling_module IN VARCHAR2

Line 431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

427: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
428: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
429: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
430: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
431: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
434: ,p_calling_module IN VARCHAR2
435: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 443: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type

439: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
440: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
441: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
442: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
443: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
444: ,p_acct_flag IN VARCHAR2
445: ,x_return_status OUT NOCOPY VARCHAR2
446: ,x_error_code OUT NOCOPY VARCHAR2
447: ,x_error_stage OUT NOCOPY VARCHAR2

Line 452: ,p_org_id IN pa_expenditure_items_all.org_id%TYPE

448: );
449: ---------------------------------------------------------------------+
450: PROCEDURE get_accrual_pa_dt_period( p_gl_period IN VARCHAR2
451: ,p_ei_date IN DATE
452: ,p_org_id IN pa_expenditure_items_all.org_id%TYPE
453: ,p_prvdr_recvr_flg IN VARCHAR2
454: ,p_epp_flag IN VARCHAR2
455: ,p_org_rev_flg IN VARCHAR2
456: ,x_pa_date OUT NOCOPY DATE

Line 475: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

471: x_error_stage OUT NOCOPY VARCHAR2
472: )
473: RETURN DATE;
474: -----------------------------------------------------------------------
475: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
476: ,p_org_id IN pa_implementations_all.org_id%TYPE
477: )
478: RETURN pa_periods.period_name%TYPE;
479: -----------------------------------------------------------------------

Line 481: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)

477: )
478: RETURN pa_periods.period_name%TYPE;
479: -----------------------------------------------------------------------
480: --Start Bug 3069632
481: FUNCTION get_ts_allow_burden_flag( p_transaction_source IN pa_expenditure_items_all.transaction_source%TYPE)
482: RETURN pa_transaction_sources.allow_burden_flag%TYPE;
483: -----------------------------------------------------------------------
484: FUNCTION get_capital_cost_type_code( p_project_id IN pa_projects_all.project_id%TYPE)
485: RETURN pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE;

Line 494: g_transaction_source pa_expenditure_items_all.transaction_source%TYPE;

490: g_project_type pa_projects_all.project_type%type;
491: g_proj_org_id pa_projects_all.org_id%type;
492: g_capital_cost_type_code pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE;
493: g_ts_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE;
494: g_transaction_source pa_expenditure_items_all.transaction_source%TYPE;
495: --End Bug 3069632
496:
497: Function Get_Burden_Amt_Display_Method(P_Project_Id in Number) Return Varchar2;
498: