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 82: g_prev_expenditure_id pa_expenditure_items_all.expenditure_id%TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 366: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

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

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

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

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

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

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

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

Line 429: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

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

Line 430: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

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

Line 442: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type

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

Line 451: ,p_org_id IN pa_expenditure_items_all.org_id%TYPE

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

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

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

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

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

Line 493: g_transaction_source pa_expenditure_items_all.transaction_source%TYPE;

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