1201: --------------------------------------17----------------------------------------
1202: -- Start of Commnets
1203: -- avsingh
1204: -- Procedure Name : validate_asd_id
1205: -- Description : Validate against OKL_TXD_ASSETS_B
1206: -- Business Rules :
1207: -- Parameters : OUT Return Status, IN Rec Info
1208: -- Version : 1.0
1209: -- End of Commnets
1214: CURSOR c_asd_id_validate(p_asd_id NUMBER) is
1215: SELECT 1
1216: FROM DUAL
1217: WHERE EXISTS (SELECT '1'
1218: FROM OKL_TXD_ASSETS_B
1219: WHERE id = p_asd_id
1220: );
1221: BEGIN
1222: -- initialize return status