APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on GMS_AWARDS

Line 87: FROM gms_awards

83:
84: CURSOR l_award_csr (p_award_id NUMBER)
85: IS
86: SELECT budget_wf_enabled_flag
87: FROM gms_awards
88: WHERE award_id = p_award_id;
89:
90: l_budget_wf_enabled_flag gms_awards.budget_wf_enabled_flag%TYPE := 'N';
91:

Line 90: l_budget_wf_enabled_flag gms_awards.budget_wf_enabled_flag%TYPE := 'N';

86: SELECT budget_wf_enabled_flag
87: FROM gms_awards
88: WHERE award_id = p_award_id;
89:
90: l_budget_wf_enabled_flag gms_awards.budget_wf_enabled_flag%TYPE := 'N';
91:
92: BEGIN
93:
94: -- dbms_output.put_line('GMS_CLIENT_EXTN_BUDGET_WF.IS_BUDGET_WF_USED - start');

Line 199: FROM gms_awards -- gms_awards_v -- Bug 4004577

195: ( p_award_id NUMBER)
196: IS
197: SELECT award_number
198: , award_short_name
199: FROM gms_awards -- gms_awards_v -- Bug 4004577
200: WHERE award_id = p_award_id;
201:
202: --
203:

Line 318: l_award_id gms_awards.award_id%TYPE;

314:
315: ItemType varchar2(30) := 'GMSWF'; --<----Identifies the workflow process!!!
316: ItemKey varchar2(30);
317:
318: l_award_id gms_awards.award_id%TYPE;
319: l_award_number gms_awards.award_number%TYPE;
320: l_award_short_name gms_awards.award_short_name%TYPE;
321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;

Line 319: l_award_number gms_awards.award_number%TYPE;

315: ItemType varchar2(30) := 'GMSWF'; --<----Identifies the workflow process!!!
316: ItemKey varchar2(30);
317:
318: l_award_id gms_awards.award_id%TYPE;
319: l_award_number gms_awards.award_number%TYPE;
320: l_award_short_name gms_awards.award_short_name%TYPE;
321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;

Line 320: l_award_short_name gms_awards.award_short_name%TYPE;

316: ItemKey varchar2(30);
317:
318: l_award_id gms_awards.award_id%TYPE;
319: l_award_number gms_awards.award_number%TYPE;
320: l_award_short_name gms_awards.award_short_name%TYPE;
321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;

Line 938: FROM gms_awards -- gms_awards_v -- Bug 4004577

934: ( p_award_id NUMBER)
935: IS
936: SELECT award_number
937: ,award_short_name
938: FROM gms_awards -- gms_awards_v -- Bug 4004577
939: WHERE award_id = p_award_id;
940: --
941:
942: CURSOR l_baselined_csr

Line 1056: l_award_id gms_awards.award_id%TYPE;

1052:
1053: ItemType varchar2(30) := 'GMSWF'; --<----Identifies the workflow process!!!
1054: ItemKey varchar2(30);
1055:
1056: l_award_id gms_awards.award_id%TYPE;
1057: l_award_number gms_awards.award_number%TYPE;
1058: l_award_short_name gms_awards.award_short_name%TYPE;
1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;

Line 1057: l_award_number gms_awards.award_number%TYPE;

1053: ItemType varchar2(30) := 'GMSWF'; --<----Identifies the workflow process!!!
1054: ItemKey varchar2(30);
1055:
1056: l_award_id gms_awards.award_id%TYPE;
1057: l_award_number gms_awards.award_number%TYPE;
1058: l_award_short_name gms_awards.award_short_name%TYPE;
1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;

Line 1058: l_award_short_name gms_awards.award_short_name%TYPE;

1054: ItemKey varchar2(30);
1055:
1056: l_award_id gms_awards.award_id%TYPE;
1057: l_award_number gms_awards.award_number%TYPE;
1058: l_award_short_name gms_awards.award_short_name%TYPE;
1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;

Line 1631: -- (award_manager_id in gms_awards table)

1627: -- p_workflow_started_by_id - identifies the user that initiated the workflow
1628: --
1629: -- OUT NOCOPY
1630: -- p_budget_baseliner_id - unique identifier of the employee
1631: -- (award_manager_id in gms_awards table)
1632: -- that must approve this budget for baselining.
1633: --
1634:
1635: PROCEDURE Select_Budget_Approver