DBA Data[Home] [Help]

APPS.PA_BUDGET_WF dependencies on PA_BUDGET_TYPES

Line 531: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

527: AND TRUNC(SYSDATE) BETWEEN f.start_date AND nvl(f.end_date, TRUNC(SYSDATE)+1); --Added : 7688624
528:
529: l_workflow_started_by_id NUMBER;
530: l_project_id NUMBER;
531: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
532:
533: l_baseliner_employee_id NUMBER;
534:
535: l_baseliner_user_id NUMBER;

Line 790: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

786:
787: -- Local Variables
788: l_workflow_started_by_id NUMBER;
789: l_project_id NUMBER;
790: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
791:
792:
793: l_warnings_only_flag VARCHAR2(1);
794: l_warnings_only VARCHAR2(1) := 'Y';

Line 1206: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

1202:
1203: l_workflow_started_by_id NUMBER;
1204: l_baseliner_id NUMBER;
1205: l_project_id NUMBER;
1206: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
1207:
1208: l_row_found NUMBER;
1209: l_baselined_version_id NUMBER;
1210:

Line 1777: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

1773: , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1774: )
1775: Is
1776: l_federal_enabled VARCHAR2(1);
1777: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
1778:
1779: Begin
1780:
1781: l_budget_type_code := wf_engine.GetItemAttrText(itemtype => itemtype,