DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS dependencies on PA_IMPLEMENTATIONS_ALL

Line 546: l_SobId pa_implementations_all.set_of_books_id%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;
550: x_error_code VARCHAR2(100);

Line 547: l_RecvrSobId pa_implementations_all.set_of_books_id%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;
550: x_error_code VARCHAR2(100);
551: x_error_stage NUMBER;

Line 885: from pa_implementations_all

881: IF (PaDateTab(i) is NULL or RecvrPaDateTab(i) is null) THEN
882:
883: select set_of_books_id
884: into l_SobId
885: from pa_implementations_all
886: where org_id = nvl(OrgIdTab(i),-99);
887:
888: select set_of_books_id
889: into l_RecvrSobId

Line 890: from pa_implementations_all

886: where org_id = nvl(OrgIdTab(i),-99);
887:
888: select set_of_books_id
889: into l_RecvrSobId
890: from pa_implementations_all
891: where org_id = nvl(RecvOperUnitTab(i),-99);
892:
893: pa_integration.get_period_information(
894: p_expenditure_item_date => EiDateTab(i)