803: and fct_int_record_type = 'BLK_DTL';
804:
805: -- Enable the foot note flag for this failed
806: -- edit check
807: UPDATE fv_facts_submission
808: SET foot_note_flag = 'Y'
809: WHERE treasury_symbol_id = g_treasury_symbol_id;
810:
811: END IF;
857: and fct_int_record_type = 'BLK_DTL';
858:
859: -- Enable the foot note flag for this failed
860: -- edit check
861: UPDATE fv_facts_submission
862: SET foot_note_flag = 'Y'
863: WHERE treasury_symbol_id = g_treasury_symbol_id;
864:
865: END IF;
870: v_edit_check_status := 'Passed' ;
871:
872: -- Disable the foot note flag for this passed
873: -- edit check in case it has failed earlier
874: UPDATE fv_facts_submission
875: SET foot_note_flag = 'N'
876: WHERE treasury_symbol_id = g_treasury_symbol_id;
877:
878: ELSE