25:
26: BEGIN
27: select Award_Number
28: into p_award_number
29: from gms_ssa_awards_v
30: where award_id = p_award_id;
31:
32: RETURN TRUE;
33:
52:
53: BEGIN
54: select AWARD_ID, AWARD_SHORT_NAME
55: into p_award_id, p_award_name
56: from gms_ssa_awards_v
57: where AWARD_NUMBER = p_award_number;
58:
59: RETURN TRUE;
60: EXCEPTION
77:
78: BEGIN
79: select award_id
80: into p_award_id
81: from gms_ssa_awards_v
82: where award_number = p_award_number;
83:
84: RETURN TRUE;
85: EXCEPTION
170: l_award_funds varchar2(1);
171: BEGIN
172: select 'Y'
173: into l_award_funds
174: from gms_ssa_awards_v
175: where award_id = p_award_id
176: and project_id = p_project_id
177: and task_id = p_task_id;
178: