DBA Data[Home] [Help]

APPS.PA_INTEGRATION dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 6: g_prvdr_org_id pa_expenditure_items_all.org_id%TYPE;

2: --$Header: PAXPINTS.pls 120.1 2005/08/08 10:51:04 sbharath noship $
3:
4:
5: /**global variables related to get_raw_cdl_pa_date() and get_raw_cdl_recvr_pa_date() caching **/
6: g_prvdr_org_id pa_expenditure_items_all.org_id%TYPE;
7: g_p_earliest_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;
8: g_p_earliest_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
9: g_p_earliest_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
10: g_prvdr_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE;

Line 15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;

11: g_prvdr_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE;
12: g_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
13: g_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
14:
15: g_recvr_org_id pa_expenditure_items_all.recvr_org_id%TYPE;
16: g_r_earliest_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
17: g_r_earliest_pa_end_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
18: g_r_earliest_pa_period_name pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
19: g_recvr_pa_start_date pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

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

195: FUNCTION get_burden_cdl_pa_date ( p_raw_cdl_date IN DATE )
196: RETURN DATE;
197: pragma RESTRICT_REFERENCES(get_burden_cdl_pa_date,WNDS,WNPS);
198: /*----------------------------------------------------------------------------*/
199: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
200: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
201: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

198: /*----------------------------------------------------------------------------*/
199: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
200: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
201: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

199: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
200: ,p_prvdr_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
201: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
202: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
203: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
204: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
205: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
206: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
207: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE