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_COST_DISTRIBUTION_LINES_ALL

Line 5: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is

1: PACKAGE BODY PA_UTILS2 AS
2: /* $Header: PAXGUT2B.pls 120.26.12020000.4 2013/03/06 09:49:17 admarath ship $ */
3:
4: -- FUNCTION get_period_name /*2835063*/
5: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is
6: BEGIN
7: /* Please note that this function should be used only after ensuring that
8: get_pa_date() is called for the returned variable's value to be set to
9: a non-NULL value */

Line 1164: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;

1160: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
1161: l_gl_date DATE;
1162: l_pji_summarized_flag VARCHAR2(1);
1163: l_prvdr_accr_date DATE;
1164: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;
1165: l_line_type VARCHAR2(1);
1166: l_line_num NUMBER ;
1167: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
1168: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;

Line 1280: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,

1276: l_projfunc_cost_rate_date,
1277: l_projfunc_cost_rate_type,
1278: l_projfunc_cost_exchange_rate,
1279: l_work_type_id
1280: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,
1281: PA_EXPENDITURE_ITEMS_ALL EI
1282: WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
1283: AND CDL.ROWID = chartorowid( p_cdl_rowid(1));
1284:

Line 2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE

2448:
2449: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2450: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

Line 2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE

2449: PROCEDURE get_period_information ( p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2450: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE

2450: ,p_expenditure_id IN pa_expenditure_items_all.expenditure_id%TYPE
2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE

Line 2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

2451: ,p_system_linkage_function IN pa_expenditure_items_all.system_linkage_function%TYPE
2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

2452: ,p_line_type IN pa_cost_distribution_lines_all.line_type%TYPE
2453: ,p_prvdr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2454: ,p_recvr_raw_pa_date IN pa_cost_distribution_lines_all.pa_date%TYPE
2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

Line 2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

Line 2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

Line 2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

Line 2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER

Line 2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER
2472: ,x_error_code OUT NOCOPY VARCHAR2

Line 2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

2465: ,x_prvdr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER
2472: ,x_error_code OUT NOCOPY VARCHAR2
2473: ,x_error_stage OUT NOCOPY NUMBER

Line 2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

2466: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
2467: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
2468: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
2469: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
2470: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
2471: ,x_return_status OUT NOCOPY NUMBER
2472: ,x_error_code OUT NOCOPY VARCHAR2
2473: ,x_error_stage OUT NOCOPY NUMBER
2474: )

Line 2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2472: ,x_error_code OUT NOCOPY VARCHAR2
2473: ,x_error_stage OUT NOCOPY NUMBER
2474: )
2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:

Line 2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

2473: ,x_error_stage OUT NOCOPY NUMBER
2474: )
2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2474: )
2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

2475: IS
2476: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2477: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:

Line 2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

2478: l_prvdr_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */

Line 2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

2479: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

2480:
2481: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2482: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2483: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:

Line 2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2484: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:
2492: /*End-Changes for 7535550 */

Line 2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2485:
2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:
2492: /*End-Changes for 7535550 */
2493: l_pa_gl_app_id NUMBER := 8721 ;

Line 2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

2486: /*Starts-Changes for 7535550 */
2487: p_prvdr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2488: p_recvr_raw_pa_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2489: p_prvdr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2490: p_recvr_raw_gl_date_l pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
2491:
2492: /*End-Changes for 7535550 */
2493: l_pa_gl_app_id NUMBER := 8721 ;
2494: l_gl_app_id NUMBER := 101;

Line 3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

3022: END get_period_information ;
3023: -----------------------------------------------------------------------
3024: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER

Line 3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

3023: -----------------------------------------------------------------------
3024: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER
3031: ,x_error_code OUT NOCOPY VARCHAR2

Line 3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

3024: PROCEDURE get_OU_period_information ( p_reference_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER
3031: ,x_error_code OUT NOCOPY VARCHAR2
3032: ,x_error_stage OUT NOCOPY NUMBER

Line 3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

3025: ,p_calling_module IN VARCHAR2
3026: ,x_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
3027: ,x_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
3028: ,x_gl_date OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
3029: ,x_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
3030: ,x_return_status OUT NOCOPY NUMBER
3031: ,x_error_code OUT NOCOPY VARCHAR2
3032: ,x_error_stage OUT NOCOPY NUMBER
3033: )

Line 3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3034: IS
3035: l_org_id pa_implementations_all.org_id%TYPE;
3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:

Line 3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

3035: l_org_id pa_implementations_all.org_id%TYPE;
3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:
3043: l_return_status NUMBER ;

Line 3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:
3043: l_return_status NUMBER ;
3044: l_stage NUMBER ;

Line 3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3041: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
3042:
3043: l_return_status NUMBER ;
3044: l_stage NUMBER ;
3045: l_error_code VARCHAR2(30);

Line 3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE

3129: RAISE;
3130: END get_OU_period_information;
3131:
3132: -----------------------------------------------------------------------
3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS

Line 3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE

3130: END get_OU_period_information;
3131:
3132: -----------------------------------------------------------------------
3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

Line 3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE

3132: -----------------------------------------------------------------------
3133: FUNCTION get_gl_period_name ( p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

Line 3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;

3134: ,p_org_id IN pa_cost_distribution_lines_all.org_id%TYPE
3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3141:
3142: BEGIN

Line 3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;

3135: )
3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3141:
3142: BEGIN
3143: /*

Line 3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;

3136: RETURN pa_cost_distribution_lines_all.gl_period_name%TYPE
3137: IS
3138: l_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE ;
3139: l_gl_period_start_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3140: l_gl_period_end_date pa_cost_distribution_lines_all.gl_date%TYPE ;
3141:
3142: BEGIN
3143: /*
3144: * Try to reuse the global cache.

Line 3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3247: ,x_return_status OUT NOCOPY VARCHAR2
3248: ,x_error_code OUT NOCOPY VARCHAR2
3249: )
3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3248: ,x_error_code OUT NOCOPY VARCHAR2
3249: )
3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

Line 3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3249: )
3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

Line 3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

3250: IS
3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';

Line 3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

3251: l_org_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3259: l_debug_mode VARCHAR2(1);

Line 3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;

3252: l_org_pa_start_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3259: l_debug_mode VARCHAR2(1);
3260: BEGIN

Line 3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;

3253: l_org_pa_end_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3254: l_org_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3255: l_rev_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3256: l_rev_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE;
3257: l_org_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE;
3258: l_pa_overlaps_gl VARCHAR2(1) := 'N';
3259: l_debug_mode VARCHAR2(1);
3260: BEGIN
3261:

Line 3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3570: x_error_stage OUT NOCOPY VARCHAR2
3571: )
3572: return date
3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:

Line 3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3571: )
3572: return date
3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3572: return date
3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;

Line 3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3573: IS
3574: l_org_accr_start_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;

Line 3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3575: l_org_accr_end_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3582: l_debug_mode VARCHAR2(1);
3583:

Line 3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

3769: x_error_code OUT NOCOPY VARCHAR2,
3770: x_error_stage OUT NOCOPY VARCHAR2
3771: )
3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;

Line 3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3770: x_error_stage OUT NOCOPY VARCHAR2
3771: )
3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);

Line 3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3771: )
3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);
3779: BEGIN

Line 3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

3772: IS
3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);
3779: BEGIN
3780:

Line 4050: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

4046: ------------------------------------------------------------------------------------------------------
4047: *======================================================================================================*/
4048: ----------------------------------------------------------------------------------------------------------------
4049: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4050: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4052: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

4047: *======================================================================================================*/
4048: ----------------------------------------------------------------------------------------------------------------
4049: PROCEDURE get_accrual_period_information(p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4050: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4052: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

Line 4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

Line 4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

Line 4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

Line 4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE

4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

Line 4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE

4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type

Line 4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE

4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4066: ,p_acct_flag IN VARCHAR2

Line 4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE

4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4066: ,p_acct_flag IN VARCHAR2
4067: ,x_return_status OUT NOCOPY VARCHAR2

Line 4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE

4060: ,x_prvdr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.gl_period_name%TYPE
4061: ,x_recvr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_date%TYPE
4062: ,x_recvr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE
4063: ,x_recvr_gl_date OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_date%TYPE
4064: ,x_recvr_gl_period_name OUT NOCOPY pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE
4065: ,p_adj_ei_id IN pa_expenditure_items_all.expenditure_item_id%type
4066: ,p_acct_flag IN VARCHAR2
4067: ,x_return_status OUT NOCOPY VARCHAR2
4068: ,x_error_code OUT NOCOPY VARCHAR2

Line 4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

4068: ,x_error_code OUT NOCOPY VARCHAR2
4069: ,x_error_stage OUT NOCOPY VARCHAR2
4070: )
4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

4069: ,x_error_stage OUT NOCOPY VARCHAR2
4070: )
4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

Line 4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

4070: )
4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

4071: IS
4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

4072: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;

4073: l_prvdr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

Line 4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4074: l_prvdr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:

Line 4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4075: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:
4083: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.

Line 4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4076: l_recvr_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:
4083: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.
4084: l_gl_app_id NUMBER := 101;

Line 4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;

4077: l_recvr_gl_period_name pa_cost_distribution_lines_all.gl_period_name%TYPE := NULL;
4078: l_prvdr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4079: l_prvdr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4080: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4081: l_recvr_accrual_date pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
4082:
4083: l_pa_gl_app_id NUMBER := 101; -- We always go against the GL Period.
4084: l_gl_app_id NUMBER := 101;
4085: l_app_id NUMBER := NULL ;