DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PA_IMPLEMENTATIONS_ALL

Line 61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

57: g_p_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
58: g_p_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
59: g_p_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
60:
61: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
62: g_prvdr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
63: g_prvdr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
64: g_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
65: g_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

Line 74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

70: g_r_earliest_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
71: g_r_earliest_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
72: g_r_earliest_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
73:
74: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
75: g_recvr_gl_start_date pa_cost_distribution_lines_all.gl_date%TYPE;
76: g_recvr_gl_end_date pa_cost_distribution_lines_all.gl_date%TYPE;
77: g_recvr_gl_period_name pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE ;
78: g_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;

Line 369: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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'
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 370: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%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'
373: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
374: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

Line 403: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE) RETURN NUMBER;

399: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
400: )
401: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE;
402: ---------------------------------------------------------------
403: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE) RETURN NUMBER;
404: ---------------------------------------------------------------
405: /*
406: * This function returns the end_date of the PA period in which the input date falls.
407: */

Line 432: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%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
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

Line 433: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%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
436: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
437: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

Line 476: ,p_org_id IN pa_implementations_all.org_id%TYPE

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: -----------------------------------------------------------------------
480: --Start Bug 3069632