DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS dependencies on PA_IMPLEMENTATIONS_ALL

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

Line 615: l_RecvrSobId pa_implementations_all.set_of_books_id%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;
618: x_error_code VARCHAR2(100);
619: x_error_stage NUMBER;

Line 975: from pa_implementations_all

971: IF (PaDateTab(i) is NULL or RecvrPaDateTab(i) is null) THEN
972:
973: select set_of_books_id
974: into l_SobId
975: from pa_implementations_all
976: where org_id = nvl(OrgIdTab(i),-99);
977:
978: select set_of_books_id
979: into l_RecvrSobId

Line 980: from pa_implementations_all

976: where org_id = nvl(OrgIdTab(i),-99);
977:
978: select set_of_books_id
979: into l_RecvrSobId
980: from pa_implementations_all
981: where org_id = nvl(RecvOperUnitTab(i),-99);
982:
983: pa_integration.get_period_information(
984: p_expenditure_item_date => EiDateTab(i)