1294: --
1295: PROCEDURE validate_award( X_return_status IN out NOCOPY varchar2) IS
1296:
1297: x_dummy number := 0;
1298: x_agreement_type pa_agreement_types.agreement_type%TYPE ;
1299: x_awd_snm gms_awards_all.award_short_name%TYPE;
1300: L_error BOOLEAN := FALSE ;
1301:
1302: Project_Check NUMBER(2) := 0;
1369: */
1370:
1371: cursor C_agreement is
1372: SELECT agreement_type
1373: FROM pa_agreement_types
1374: WHERE agreement_type = g_award_rec.type ;
1375:
1376: -- Debashis. Added exists clause. Removed rownum.
1377: CURSOR C_fnd_user is