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.

[Home] [Help]

APPS.PA_TRANSACTIONS dependencies on PA_COST_DISTRIBUTION_LINES

Line 609: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;

605:
606: l_x_gl_flag VARCHAR2(2);
607: -- Oct 2001 Enhanced Period Processing
608: -- Start EPP Changes
609: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
610: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
611: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
612: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
613: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

Line 610: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

606: l_x_gl_flag VARCHAR2(2);
607: -- Oct 2001 Enhanced Period Processing
608: -- Start EPP Changes
609: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
610: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
611: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
612: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
613: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
614: l_SobId pa_implementations_all.set_of_books_id%TYPE;

Line 611: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;

607: -- Oct 2001 Enhanced Period Processing
608: -- Start EPP Changes
609: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
610: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
611: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
612: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
613: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
614: l_SobId pa_implementations_all.set_of_books_id%TYPE;
615: l_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;

Line 612: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

608: -- Start EPP Changes
609: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
610: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
611: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
612: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
613: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
614: l_SobId pa_implementations_all.set_of_books_id%TYPE;
615: l_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
616:

Line 613: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

609: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
610: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
611: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
612: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
613: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
614: l_SobId pa_implementations_all.set_of_books_id%TYPE;
615: l_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
616:
617: x_return_status NUMBER;

Line 1170: update pa_cost_distribution_lines cdl1

1166: -- SLA need to have parent line_num populated with the latest cdl line
1167: -- num of adjusted expenditure item to resolve performance issue.
1168: --
1169: IF nvl(X_gl_flag,'N') in ('Y', 'P') THEN ---{
1170: update pa_cost_distribution_lines cdl1
1171: set cdl1.parent_line_num = ( select cdl2.line_num
1172: from pa_cost_distribution_lines cdl2
1173: where cdl2.expenditure_item_id = AdjEiTab(i)
1174: and cdl2.line_type = 'R'

Line 1172: from pa_cost_distribution_lines cdl2

1168: --
1169: IF nvl(X_gl_flag,'N') in ('Y', 'P') THEN ---{
1170: update pa_cost_distribution_lines cdl1
1171: set cdl1.parent_line_num = ( select cdl2.line_num
1172: from pa_cost_distribution_lines cdl2
1173: where cdl2.expenditure_item_id = AdjEiTab(i)
1174: and cdl2.line_type = 'R'
1175: and cdl2.reversed_flag is NULL
1176: and cdl2.line_num_reversed is NULL )