DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on PA_IMPLEMENTATIONS_ALL

Line 60: g_prvdr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

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

Line 73: g_recvr_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

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

Line 368: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

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

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

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

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

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

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

Line 475: ,p_org_id IN pa_implementations_all.org_id%TYPE

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