APPS.PA_TRANSACTIONS dependencies on PA_COST_DISTRIBUTION_LINES

Line 541: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;

537:
538: l_x_gl_flag VARCHAR2(2);
539: -- Oct 2001 Enhanced Period Processing
540: -- Start EPP Changes
541: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
542: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
543: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
544: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
545: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

Line 542: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

538: l_x_gl_flag VARCHAR2(2);
539: -- Oct 2001 Enhanced Period Processing
540: -- Start EPP Changes
541: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
542: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
543: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
544: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
545: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
546: l_SobId pa_implementations_all.set_of_books_id%TYPE;

Line 543: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;

539: -- Oct 2001 Enhanced Period Processing
540: -- Start EPP Changes
541: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
542: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
543: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
544: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
545: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
546: l_SobId pa_implementations_all.set_of_books_id%TYPE;
547: l_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;

Line 544: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

540: -- Start EPP Changes
541: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
542: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
543: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
544: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
545: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
546: l_SobId pa_implementations_all.set_of_books_id%TYPE;
547: l_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
548:

Line 545: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

541: l_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
542: l_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
543: l_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
544: l_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
545: l_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
546: l_SobId pa_implementations_all.set_of_books_id%TYPE;
547: l_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
548:
549: x_return_status NUMBER;

Line 1078: update pa_cost_distribution_lines cdl1

1074: -- SLA need to have parent line_num populated with the latest cdl line
1075: -- num of adjusted expenditure item to resolve performance issue.
1076: --
1077: IF nvl(X_gl_flag,'N') in ('Y', 'P') THEN ---{
1078: update pa_cost_distribution_lines cdl1
1079: set cdl1.parent_line_num = ( select cdl2.line_num
1080: from pa_cost_distribution_lines cdl2
1081: where cdl2.expenditure_item_id = AdjEiTab(i)
1082: and cdl2.line_type = 'R'

Line 1080: from pa_cost_distribution_lines cdl2

1076: --
1077: IF nvl(X_gl_flag,'N') in ('Y', 'P') THEN ---{
1078: update pa_cost_distribution_lines cdl1
1079: set cdl1.parent_line_num = ( select cdl2.line_num
1080: from pa_cost_distribution_lines cdl2
1081: where cdl2.expenditure_item_id = AdjEiTab(i)
1082: and cdl2.line_type = 'R'
1083: and cdl2.reversed_flag is NULL
1084: and cdl2.line_num_reversed is NULL )