DBA Data[Home] [Help]

APPS.PA_XLA_INTERFACE_PKG dependencies on PA_PROJECTS_ALL

Line 67: g_project_org_id pa_projects_all.org_id%type; -- Project operating unit.

63: g_data_set_id Number; -- Cincurrent request id, budget version id etc.
64: g_imp_cr_ccid Number; -- Default supplier cost credit account
65:
66: g_entity_code Varchar2(30);
67: g_project_org_id pa_projects_all.org_id%type; -- Project operating unit.
68:
69: -- static global pl/sql tables for holding event type info
70: g_tab_module TEventInfo10;
71: g_tab_event_type_code TEventInfo35;

Line 1817: l_project_number pa_projects_all.segment1%type;

1813: -- Following variables used to build transaction number for budget
1814: -- Transaction number: 'project number' - 'budget type' - 'budget version number'
1815:
1816: l_budget_type pa_budget_types.budget_type%type;
1817: l_project_number pa_projects_all.segment1%type;
1818: l_budget_version_number pa_budget_versions.version_number%type;
1819: l_rev_budget_version_number pa_budget_versions.version_number%type;
1820:
1821: Begin

Line 1879: from pa_projects_all pp,

1875: select pp.org_id,pp.segment1,
1876: pbv.version_number,pbt.budget_type
1877: into g_project_org_id,l_project_number,
1878: l_budget_version_number,l_budget_type
1879: from pa_projects_all pp,
1880: pa_budget_versions pbv,
1881: pa_budget_types pbt
1882: where pbv.budget_version_id = g_data_set_id
1883: and pp.project_id = pbv.project_id