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;
1368: */
1369:
1370: cursor C_agreement is
1371: SELECT agreement_type
1372: FROM pa_agreement_types
1373: WHERE agreement_type = g_award_rec.type ;
1374:
1375: -- Debashis. Added exists clause. Removed rownum.
1376: CURSOR C_fnd_user is